string [] aa=new string [] {" 700011 ", "700012", "100010"}; 

Have so a group of Numbers corresponding to the table a list of data
I want to insert the data in this array corresponding column,
Shipment is inserted into the bar code corresponding to the volume number should be how to write
PS: if you insert into could add the where

CodePudding user response:

Who said can't insert into plus the where


Like this insert into table (field 1, 2) the value (the select field 1, 2 the from field table2 where 1=1)

CodePudding user response:

You in this line for bar code data, with the Update

CodePudding user response:

You want to write an update statement PS insert into the back of the select is actually conditions don't be so rigid,

CodePudding user response:

Insert into table (bar code, the input volume, total volume, delivery volume number)
Select bar code, the input volume number, the total volume number, the shipping volume number from table where bar code in (" 700011 ", "700012", "100010")

CodePudding user response:

Insert into table (outbound volume number)
The select outbound volume number from tableA where tableA. Bar code='XXXX'

CodePudding user response:

Into a class is not good, why want to use an array?

CodePudding user response:

Fellow teachers, I'm sorry there is no clear, array I am to do experiments, under normal circumstances is a bar code collector, acquisition and on barcode richbox inside, I want to by getting the barcode and then increasing the corresponding shipment volume number starting from 1, until finish out this shipment, the goods continue to start from 1