Update Dynamic textbox values from Gridview to database.

See more:

C#

ASP.NET

Actually I have Updated Dynamic Textbox values from Gridview to database but according to 'rowindex' which is correct.

But Now I want to Update the values according to 'ID' which is in GridView. 'ID' is fetching from the database.

So There is a little problem in my code.

What should I write in my code for the 'ID'.

I have used this query which is correct. But in place of 'rowindex', I want to use 'ID'. The update query and some part of the code is given below -

int count = GridView2.Rows.Count;
            for (int i = 0; i < count; i++)
            {
                TextBox box3 = (TextBox)GridView2.Rows[rowIndex].Cells[3].FindControl("TextBox3");
                TextBox box4 = (TextBox)GridView2.Rows[rowIndex].Cells[4].FindControl("TextBox4");
                sc.Add(box3.Text + "," + box4.Text);
                rowIndex++;
                conn.Open();
                string sqlStatement = "update SampleTable set Intime2='" + box3.Text + "',Outtime2='" + box4.Text + "' where ID='" + rowIndex + "'";
               
                SqlCommand cmd = new SqlCommand(sqlStatement, conn);
                cmd.CommandType = CommandType.Text;
                cmd.ExecuteNonQuery();
                conn.Close();
            }