Insert Multiple Record In Database From Datagrid From Vb.net

[rajendrage]

I Want To Insert Multiple Records From Datagrid
On One Click Of Save Button Insert All Values In Database

[Saloni]

I Want To Insert Multiple Records From Datagrid
On One Click Of Save Button Insert All Values In Database

Put all the records in datatable/array/Coma Sep string and then send to db function and then do insertion it in a loop in 1 connection & transaction.

[Ramu Sangabathula]

I Want To Insert Multiple Records From Datagrid
On One Click Of Save Button Insert All Values In Database

please correct me if i am wrong, i think your requirement is to insert rows at one shot, for this you can use batch operations. create SQLBatch and add commands either insert or delete to that batch and execute that batch. if it is necessary use transactions also.

if you want to save data directly from a Datagrid, to my knowledge i don't think it is possible, because datagrid is for just viewing purpose

[harish8]

hi i read ur answer for the question to saving multiple records in datagrid.

As u said to use array. Can u please provide me a little bit of guided code to use array to save multiple records.

Thanks in Advance