ASP.NET

ASP.NET RSS

to add checkbox in asp.net in gridview

Please support our ASP.NET advertiser: Intel Parallel Studio Home

•

Join Date: Sep 2008

Posts: 18

Reputation: mailtosridar is an unknown quantity at this point

Solved Threads: 0

mailtosridar mailtosridar is offline

Offline

Newbie Poster

to add checkbox in asp.net in gridview

Oct 8th, 2008

help me how to add checkbox in gridview in asp.net(by coding)

•

Join Date: Oct 2007

Posts: 6

Reputation: zezo is an unknown quantity at this point

Solved Threads: 0

zezo

Offline

Newbie Poster

Re: to add checkbox in asp.net in gridview

Oct 9th, 2008

1. right click on your DataGrid -->Property Builder -->Columns --> Template Column --> Apply --> Ok.
2. Right click again --> EidtTemplate --> choose Column you add --> drag CheckBox control from Toolbox and drop it in ItemTemplate field and if you need CheckBox in edit mode put another CheckBox control in EditItemTemplate field --> End Template Editing.

Code on the button:

 Help with Code Tags 
 ASP.NET Syntax (Toggle Plain Text) 
private void btn_Delete_Click(object sender, System.EventArgs e)
		{
			for(int i=0;i<dg_EditProduct.Items.Count;i++)
			{   
				CheckBox chk = new CheckBox();
				chk = (CheckBox)dg_EditProduct.Items[i].FindControl("chk_Delete");
				if(chk.Checked)
				{   
					DataTable myTable;
					myTable=(DataTable)Session["ProductTable"];
					int ID_Delete = Convert.ToInt32( myTable.Rows[i]["ProductID"]);
 
					Str_Conn = ConfigurationSettings.AppSettings["Fashion"];
					MyConn = new SqlConnection(Str_Conn);
 
					//Command to delete Product
//					SqlCommand cmd_DeleteProduct = new SqlCommand("dbo.DeleteProduct",MyConn);
					SqlCommand cmd_DeleteProduct = new SqlCommand("DeleteProduct",MyConn);
					cmd_DeleteProduct.CommandType = CommandType.StoredProcedure;
					SqlParameter ProductID_Delete = cmd_DeleteProduct.Parameters.Add("@ProductID",SqlDbType.Int);
					ProductID_Delete.Value = ID_Delete ;
 
					MyConn.Open();
					dg_EditProduct.DataSource = myTable;
					cmd_DeleteProduct.ExecuteNonQuery();
					MyConn.Close();
				}
			}
			BindData(); // it is the function you use to bind data to datagrid on page load
		}
private void btn_Delete_Click(object sender, System.EventArgs e)
		{
			for(int i=0;i<dg_EditProduct.Items.Count;i++)
			{   
				CheckBox chk = new CheckBox();
				chk = (CheckBox)dg_EditProduct.Items[i].FindControl("chk_Delete");
				if(chk.Checked)
				{   
					DataTable myTable;
					myTable=(DataTable)Session["ProductTable"];
					int ID_Delete = Convert.ToInt32( myTable.Rows[i]["ProductID"]);

					Str_Conn = ConfigurationSettings.AppSettings["Fashion"];
					MyConn = new SqlConnection(Str_Conn);
					
					//Command to delete Product
//					SqlCommand cmd_DeleteProduct = new SqlCommand("dbo.DeleteProduct",MyConn);
					SqlCommand cmd_DeleteProduct = new SqlCommand("DeleteProduct",MyConn);
					cmd_DeleteProduct.CommandType = CommandType.StoredProcedure;
					SqlParameter ProductID_Delete = cmd_DeleteProduct.Parameters.Add("@ProductID",SqlDbType.Int);
					ProductID_Delete.Value = ID_Delete ;

					MyConn.Open();
					dg_EditProduct.DataSource = myTable;
					cmd_DeleteProduct.ExecuteNonQuery();
					MyConn.Close();
				}
			}
			BindData(); // it is the function you use to bind data to datagrid on page load
		}