For the great god help 'new don't know how to modify the

CodePudding user response:

Adodc1. Refresh so many lines of the select * from above... The where... What is the use?

First of all, the string of text field to add double quotation marks, such as:
Adodc1. RecordSource=select * from customer information where customer name="" "& amp; Text1 (1). The Text & amp; "" ""

Secondly, there is no need to add so much Select, only keep number which line is ok:
Adodc1. RecordSource="select * from customer information where id=" & amp; Text1 (0). The Text

In the end, what do you want to do according to the last is back and forth?

CodePudding user response:

reference 1st floor milaoshu1020 response:

Adodc1. Refresh so many lines of the select * from above... The where... What is the use?

First of all, the string of text field to add double quotation marks, such as:
Adodc1. RecordSource=select * from customer information where customer name="" "& amp; Text1 (1). The Text & amp; "" ""

Secondly, there is no need to add so much Select, only keep number which line is ok:
Adodc1. RecordSource="select * from customer information where id=" & amp; Text1 (0). The Text

In the end, what do you want to do according to the last is back and forth?

ok I will try

CodePudding user response:

reference 1st floor milaoshu1020 response:

Adodc1. Refresh so many lines of the select * from above... The where... What is the use?

First of all, the string of text field to add double quotation marks, such as:
Adodc1. RecordSource=select * from customer information where customer name="" "& amp; Text1 (1). The Text & amp; "" ""

Secondly, there is no need to add so much Select, only keep number which line is ok:
Adodc1. RecordSource="select * from customer information where id=" & amp; Text1 (0). The Text

In the end, what do you want to do according to the last is back and forth?

I want to realize the database to add or delete

CodePudding user response:

Sorry, I didn't notice you are all of the text type, if the number is the text type, is sure to add double quotation marks:
Adodc1. RecordSource=select * from customer information where id="" "& amp; Text1 (0). The Text & amp; "" ""

Your Command2_Click is used to add or remove?

CodePudding user response:

If it is, then Adodc1. Update all of the statements below doesn't work, can comment out first.

CodePudding user response:

reference 5 floor milaoshu1020 reply:

if it is, then Adodc1. Update all of the statements below was useless, to comment out.

but delete the words will not be able to add data into database

CodePudding user response:

From the AddNew to Update, data has been taken out...

CodePudding user response:

The

reference 7 floor milaoshu1020 response:

from AddNew to Update, data has been taken out...

adds is right, but I want to add after the refresh, should how

CodePudding user response:

The

reference 7 floor milaoshu1020 response:

from AddNew to Update, data has been taken out...

thank you very much, has completed the