08-04-21, 09:53 AM
08-04-21, 03:22 PM
PHP كود :
for i=0 to datagridview1.rows.count-1
dim sqlstr as string="update tablename set column3='" & datagridview1.rows(i).Cells("column3").Value & "' where ColID="& datagridview1.rows(i).Cells("ColID").Value
dim da as new SqlDataAdapter(sqlstr,con) or dim cmd as new SqlCommand(SqlStr, Con)
con.open
da.fill(dt) or cmd.ExecuteNonQuery()
con.close
next