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

how to update table set from datagridview

Answers (2)