Gridview checkbox not updating

am not in a situation to test the code.
you can also try usign on GridView1_RowDataBound event

Here is my rest of code..

public bool ConvertToBool(object state)
    {
        return (state.ToString() == "1");
    }
   

    protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
    {
        string Book_Id = GridView1.DataKeys[e.RowIndex].Value.ToString();
       //string Book_Id = GridView1.Rows[e.RowIndex].Cells[0].ToString();
          
                string Available = "1";
                SqlConnection dbCon = new SqlConnection(cns);
                dbCon.Open();

                var dbCmd = new System.Data.SqlClient.SqlCommand();
                dbCmd.Connection = dbCon;
                dbCmd.CommandType = CommandType.Text;
                dbCmd.CommandText = "UPDATE [Book_sales] set [Available]=" + Available + "WHERE [Book_Id] = " + Book_Id;
                dbCmd.ExecuteNonQuery();

       
    }


Thanks in advance

Venky,
Can you post the ConvertToBool method. Also, check the view source of page and find what value get binding on Checked=''?

Thanks for your reply Crish
But what i am trying to do is  i just kept Enable editing in the gridview properties it automatically generates update botton
what i need to was if i click on edit button(automatically generated) and select the chck/unselect the checkbox and clieck on update button the database has to be updated to 0/1.
its an web application

Thanks in advance

Hi

You can refer following code for Gridview checkbox.

private void btnSubmit_Click(object sender, EventArgs e)

{

     foreach (DataGridViewRow dr in myDataGridView.Rows)

     {

         if(dr.Cells[0].Value != null) //Cells[0] Because in cell 0th cell we have added checkbox

          {

                    MessageBox.Show("Rows " +dr.Index + " selected");

          }

      }

}

But if you want to get more detail about this code and you want to know how to use datagridview with check box than just go for this below link.

http://www.dotnetspark.com/kb/151-add-checkbox-inside-datagridview-windows.aspx