Hi there
I have a GridView which I've sent to have all rows editable from the start. I've written SQL code behind to update the rows, however, when I run the page, it only updates the changes to the first row.
The changes are bound to the GridView, as when I click my Save Changes button, the new values are kept. But looking in the MySQL backend, only the first row has update.
Can someone please help? I'm really struggling here, and don't know where I'm going wrong.
Thanks in advance
public void newbuttonUpdate_Click(object sender, EventArgs e)
{
foreach (GridViewRow row in GridView2.Rows)
{
using (OdbcConnection conn = new OdbcConnection("DRIVER={MySQL ODBC 5.1 Driver};database=actiontracker;server=localhost;uid=root;pwd=tracker1;Port=3306;")) ;
UpdateInfo();
}
}
...
Go to the complete details ...