Vb use ADODC connection SQL problems-CodePudding

Adodc2. You. Fields (0). The Value=https://bbs.csdn.net/topics/Text1.Text

Adodc1. RecordSource="select the commodity name from commodity information where product id='" & amp; Str (Text1. Text) & amp; "'
"Adodc2. You. Fields (1). The Value=https://bbs.csdn.net/topics/Adodc1.RecordSource

Adodc1. RecordSource="select commodity prices from commodity information where product id='" & amp; Str (Text1. Text) & amp; "'
"Adodc2. You. Fields. (2) Value=https://bbs.csdn.net/topics/Adodc1.RecordSource

D=InputBox (" please enter the quantity you require, "" quantity selection")
Adodc2. You. Fields (3). The Value=https://bbs.csdn.net/topics/d

Always say a multi-step operation errors, please check step by step, but where is the wrong ah, consult a great god

CodePudding user response:

I am small white one

CodePudding user response:

Writing is not closely:

 Adodc2. You. Fields (0). The Value=https://bbs.csdn.net/topics/Text1.Text 
Adodc1. RecordSource="select the commodity name from commodity information where product id='" & amp; Str (Text1. Text) & amp; "' 
"Adodc2. You. Fields (1) (0) Value=https://bbs.csdn.net/topics/Adodc1.Recordset 
Adodc1. RecordSource="select commodity prices from commodity information where product id='" & amp; Str (Text1. Text) & amp; "' 
"Adodc2. You. Fields (2). (0) Value=https://bbs.csdn.net/topics/Adodc1.Recordset 
D=InputBox (" please enter the quantity you require, "" quantity selection") 
Adodc2. You. Fields (3). The Value=https://bbs.csdn.net/topics/d

CodePudding user response:

Writing can be simplified:

 Adodc2. You. The Fields (0). The Value=https://bbs.csdn.net/topics/Text1.Text 
Adodc1. RecordSource="select name of commodity, commodity prices from commodity information where product id='" & amp; Str (Text1. Text) & amp; "' 
"Adodc2. You. Fields (1) (0) Value=https://bbs.csdn.net/topics/Adodc1.Recordset 
Adodc2. You. Fields. (2) Value=https://bbs.csdn.net/topics/Adodc1.Recordset (1) 
D=InputBox (" please enter the quantity you require, "" quantity selection") 
Adodc2. You. Fields (3). The Value=https://bbs.csdn.net/topics/d