In this article, you will learn how to get the selected row in a GridView and display the values in TextBoxes using ASP.NET. A GridView allows us to select only a single row at a time. The sample makes use of the database. We will be pulling data from the UserDetail table.

Creating Table in SQL Server Database

Now create a table named UserDetail with the columns UserID and UserName. The table looks as below.

im1.gif

Now insert data into the table.

im2.gif

First of all drag the GridView control from the Data controls menu. It will add the GridView control's HTML source code as given above.

  1. <asp:GridView ID="GridView2" runat="server"></asp:GridView>
You will need to set the Bound column in order to see the text in the cells of the GridView control.

.aspx source code

  1. <%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="WebApplication120.WebForm1" %>
  2. <!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
  3. <html xmlns="http://www.w3.org/1999/xhtml">
  4. <head runat="server">
  5. <title></title>
  6. </head>
  7. <body>
  8. <form id="form1" runat="server">
  9. <div>
  10. UserID:
  11. <asp:TextBox ID="TextBoxUserID" runat="server"></asp:TextBox>
  12. <br />
  13. UserName:
  14. <asp:TextBox ID="TextBoxUserName" runat="server"></asp:TextBox>
  15. <br />
  16. <br />
  17. <asp:GridView ID="GridView1" runat="server" AutoGenerateSelectButton="True" OnSelectedIndexChanged="GridView1_SelectedIndexChanged"
  18. BackColor="#DEBA84" BorderColor="#DEBA84" BorderStyle="None" BorderWidth="1px"
  19. CellPadding="3" CellSpacing="2" AutoGenerateColumns="False">
  20. <FooterStyle BackColor="#F7DFB5" ForeColor="#8C4510" />
  21. <HeaderStyle BackColor="#A55129" Font-Bold="True" ForeColor="White" />
  22. <PagerStyle ForeColor="#8C4510" HorizontalAlign="Center" />
  23. <RowStyle BackColor="#FFF7E7" ForeColor="#8C4510" />
  24. <SelectedRowStyle BackColor="#738A9C" Font-Bold="True" ForeColor="White" />
  25. <SortedAscendingCellStyle BackColor="#FFF1D4" />
  26. <SortedAscendingHeaderStyle BackColor="#B95C30" />
  27. <SortedDescendingCellStyle BackColor="#F1E5CE" />
  28. <SortedDescendingHeaderStyle BackColor="#93451F" />
  29. <Columns>
  30. <asp:BoundField HeaderText="UserID" DataField="UserID" />
  31. <asp:BoundField HeaderText="UserName" DataField="UserName" />
  32. </Columns>
  33. </asp:GridView>
  34. </div>
  35. </form>
  36. </body>
  37. </html>
In the above GridView Properties set 'AutoGenerateSelectButton=True'. See the following image of a GridView after setting 'AutoGenerateSelectButton=True'. Select the GridView and press F4 for the property window.

im3.gif

See the Design view of your GridView. You will find a Hyperlink with a text as 'Select'.

im4.gif

Now add the following namespace.

  1. using System.Data.SqlClient;
  2. using System.Data;
Now write the connection string to connect to the database.
  1. string strConnection = "Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;";
Now double-click on the page and write the following code for binding the data with the GridView.
  1. using System;
  2. using System.Collections.Generic;
  3. using System.Linq;
  4. using System.Web;
  5. using System.Web.UI;
  6. using System.Web.UI.WebControls;
  7. using System.Data.SqlClient;
  8. using System.Data;
  9. namespace WebApplication120
  10. {
  11. public partial class WebForm1 : System.Web.UI.Page
  12. {
  13. protected void Page_Load(object sender, EventArgs e)
  14. {
  15. show();
  16. }
  17. private void show()
  18. {
  19. {
  20. SqlConnection con = new SqlConnection("Data Source=.; uid=sa; pwd=wintellect;database=Rohatash;");
  21. string strSQL = "Select * from UserDetail";
  22. SqlDataAdapter dt = new SqlDataAdapter(strSQL, con);
  23. DataSet ds = new DataSet();
  24. dt.Fill(ds, "UserDetail");
  25. con.Close();
  26. GridView1.DataSource = ds;
  27. GridView1.DataBind();
  28. }
  29. }
  30. }
  31. }
Now run the application.

im5.gif

Selecting Row

Selecting the row event is fired when you make a click on the select link. If you need any particular item in that row you can easily select it using the cells property. In the Gridview, double-Click on the SelectedIndexChanged Event and write the following code:

  1. protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
  2. {
  3. TextBoxUserID.Text = GridView1.SelectedRow.Cells[1].Text;
  4. TextBoxUserName.Text = GridView1.SelectedRow.Cells[2].Text;
  5. }
Now run the application and select a row; that will show the selected row data in the TextBoxes.

im6.gif

Some Helpful Resources