save by batch

[C Coudou]

How to approach inserting data to sql by batch number? i have textbox and button. if user type in textbox, let say. 'First Batch 4500110 ;insert to table tblBulk 4500111 ; 4500112 ; 4500113 ; 'Second Batch 4611001 4611002 4611003 i dont know what should i put in column2 so that it will know the batch --------- tblBulk --------- column1 column2 4500110 4500111 4500112 4500113 4611001 4611002 4611003

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」

[David Mujica]

Why don't you store the BATCH # with each transaction ?

[C Coudou]

solved. i used max query for batch no.

C# コードMicrosoft End User 2000-2008 「「「「「「「「「「「「「「「「「「「「「「「「「「「「 The best things in life are free 」」」」」」」」」」」」」」」」」」」」」」」」」」」」