how to update table set from datagridview

Question

how to update table set from datagridview ?

Raghav Jhavar · Answer

Assuming your dataGridView name is 'dataGridView1' foreach(DataGridViewRow DR in dataGridView1.Rows) { //do some check for example: if( DR.Cells[columnNumber].Value.ToString().Equals(someString) { //if it is true update //UPDATE SET something DR.Cells[columnNumber].Value.ToString() WHERE someColumn = someVal } } This is only quickly done I'm sure you know the command to update your database.

Ahmed Khaled · Answer

thank you so match but so match like this code For I As Integer = 0 To DataGridView1.Rows.Count - 1 cmd.Editdata(  UPDATE HAGZ2 SET id =' & DataGridView1.Rows(I).Cells(1).Value & ' idtet =' & DataGridView1.Rows(I).Cells(2).Value & ' studntname =' & DataGridView1.Rows(I).Cells(3).Value & ' mony =' & DataGridView1.Rows(I).Cells(4).Value & ' datemony =' & DataGridView1.Rows(I).Cells(5).Value & ' accept =' & DataGridView1.Rows(I).Cells(6).Value & ' dateaccept =' & DataGridView1.Rows(I).Cells(7).Value & ' WHERE OUTO =' & DataGridView1.Rows(I).Cells(0).Value & ' ) Next this code show me error data type mismatch in criteria expression