This article explains how to get a row's cell value from a Grid View of a checked CheckBox in ASP.NET and C#. I have a GridView and inside it is a checkbox. Now I will explain how to get row values from a GridView when the checkbox is selected using ASP.NET and C#.

Procedure:

1. Now first create the Emp table in the database.

  1. Create table tbl_Emp(EmpId int, EmpName varchar(50), Company varchar(50), Address varchar(500))
2. And insert some records into the table.
  1. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(1, 'Ram', 'IDSLogic', 'DemoAddress')
  2. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(2, 'Shyam', 'HCl', 'DemoAddress')
  3. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(3, 'jitendra', 'Wipro', 'DemoAddress')
  4. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(4, 'Rihan', 'TCS', 'DemoAddress')
  5. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(5, 'Rohan', 'Tech', 'DemoAddress')
  6. Insert into tbl_Emp( EmpId, EmpName, Company, Address) values(6, 'Sohan', 'Newtech', 'DemoAddress')
3. After creating the table create the application (File ---> New ---> Website).

NewWebsite

4. Give the application the name “SelectedRowCellvalueGridview”.

EmptyWebsites

5. Then create a new item.

NewItem

WebForm

Now your aspx page is like this:

  1. <html xmlns="http://www.w3.org/1999/xhtml">
  2. <head runat="server">
  3. <title>Selected Row Cell value Gridview</title>
  4. </head>
  5. <body>
  6. <form id="form1" runat="server">
  7. <div>
  8. <asp:GridView ID="gvEmp" AutoGenerateColumns="false" CellPadding="5" runat="server">
  9. <Columns>
  10. <asp:TemplateField>
  11. <HeaderTemplate>
  12. <asp:CheckBox ID="chkAllSelect" runat="server" onclick="CheckAll(this);" />
  13. </HeaderTemplate>
  14. <ItemTemplate>
  15. <asp:CheckBox ID="chkSelect" runat="server" />
  16. </ItemTemplate>
  17. </asp:TemplateField>
  18. <asp:BoundField HeaderText="EmpId" DataField="EmpId" />
  19. <asp:BoundField HeaderText="EmpName" DataField="EmpName" />
  20. <asp:BoundField HeaderText="Company" DataField="Company" />
  21. <asp:BoundField HeaderText="Address" DataField="Address" />
  22. </Columns>
  23. <HeaderStyle BackColor="#5d5d5d" Font-Bold="true" ForeColor="White" />
  24. </asp:GridView>
  25. <asp:Button ID="btnGetRecord" Text="Get Selected Records" runat="server"
  26. Font-Bold="true" OnClick="btnGetRecord_Click" /><br /><br />
  29. <asp:Label ID="lblRecord" runat="server" />
  30. </div>
  31. </form>
  34. <script type="text/javascript">
  35. // for check all checkbox
  36. function CheckAll(Checkbox) {
  37. var GridVwHeaderCheckbox = document.getElementById("<%=gvEmp.ClientID %>");
  38. for (i = 1; i < GridVwHeaderCheckbox.rows.length; i++) {
  39. GridVwHeaderCheckbox.rows[i].cells[0].getElementsByTagName("INPUT")[0].checked = Checkbox.checked;
  40. }
  41. }
  42. </script>
  43. </body>
  44. </html>

Now add “using System.Data.SqlClient;” and “using System.Data;” in the code behind and write the following code to get the checked check box row values.

  1. protected void Page_Load(object sender, EventArgs e)
  2. {
  3. if (!IsPostBack)
  4. {
  5. Bindgv();
  6. }
  7. }
  8. // For bind Gridview
  9. protected void Bindgv()
  10. {
  11. SqlConnection con = new SqlConnection("data source=LENOVO;initial catalog=test;UID=sa;PWD=connect;");
  13. con.Open();
  14. SqlCommand cmd = new SqlCommand("Select EmpId, EmpName, Company, Address from tbl_Emp", con);
  15. SqlDataAdapter da = new SqlDataAdapter(cmd);
  16. DataSet ds = new DataSet();
  17. da.Fill(ds);
  18. con.Close();
  19. gvEmp.DataSource = ds;
  20. gvEmp.DataBind();
  22. }
  23. //for get record
  24. protected void btnGetRecord_Click(object sender, EventArgs e)
  25. {
  26. string str = string.Empty;
  27. string strname = string.Empty;
  28. foreach (GridViewRow gvrow in gvEmp.Rows)
  29. {
  30. CheckBox chk = (CheckBox)gvrow.FindControl("chkSelect");
  31. if (chk != null & chk.Checked)
  32. {
  33. str += "<b>EmpId :- </b>" + gvrow.Cells[1].Text + ", ";
  34. str += "<b>EmpName :- </b>" + gvrow.Cells[2].Text + ", ";
  35. str += "<b>Company :- </b>" + gvrow.Cells[3].Text + ", ";
  36. str += "<b>Addess :- </b>" + gvrow.Cells[4].Text;
  37. str += "<br />";
  38. }
  39. }
  40. lblRecord.Text = "<b>Selected EmpDetails: </b>" + str ;
  41. }

Test the page as in the following:

data in grid view

grid view