protected void GridView1_RowCommand(object sender, GridViewCommandEventArgs e)
        {
            int index = Convert.ToInt32(e.CommandArgument);
            string sqlQuery = "Update mytable set ID = @ID WHERE No ="+ index;
            GridOpen(sqlQuery);

        }
        void GridOpen(string send)
        {
            string con = "conn string";
            using (SqlConnection dataConnection = new SqlConnection(con))
            {
                using (SqlCommand dataCommand = new SqlCommand(send, dataConnection))
                {
                    int ld = 121;
                    dataCommand.Parameters.AddWithValue("ID", ld);
                    dataConnection.Open();
                    dataCommand.ExecuteNonQuery();
                    dataConnection.Close();

                }

            }
        }