SQL BULK INSERT FROM DataGridView

[eckertc1]

Hey all,

I need some help figureing out how to insert the contents of a datagridview into an SQL database table. some of the columns are databound and some are not. in otherwords, some columns i need to insert the "Value" of the cell while others i will need to insert the "Text" of the cell.

any suggestions?

[stanav]

Is your DGV databound? If it is, you just use a dataadapter to update the datatable that it is bound to. Otherwise, you have to loop thru the DGV rows and insert one at a time using a SqlCommand.

[jmcilhinney]

You should put all your data into a DataTable and then use a DataAdapter or TableAdapter to Update the source table from the DataTable. If you have bound and unbound columns in your grid then you should loop through all the rows of the grid and perform whatever processing is needed to get the unbound data into the remaining columns of the DataTable. You then just call Update on the adapter and pass the table. This assumes that your adapter has the appropriate InsertCommand and UpdateCommand properties for the data your DataTable contains.