Post
Ask Question

Display The Selected Row Data Of GridView In TextBoxes

This example will help you learn how to display the selected row data of GridView into the TextBoxes using 3-Tier Architecture in ASP.NET. 

Step 1
Open Visual Studio and select "ASP.NET Empty Website template". Select the path where you want to create the project.
 
Display The Selected Row Data Of GridView In TextBoxes

Step 2

After selecting ASP.NET Empty Web Site template, add a new "class library" project with the name “DAL” in solution explorer.

Display The Selected Row Data Of GridView In TextBoxes
 
Display The Selected Row Data Of GridView In TextBoxes

Step 3

After adding the new "class library" project with the name “DAL”, write the following code.

Namespaces

  1. using System.Data;  
  2. using System.Data.SqlClient;   
code

  1. publicclassclsDAL {  
  2.     SqlConnection con = new SqlConnection("Data Source=DESKTOP-LDDD5B0;Initial Catalog=3TireDB;Integrated Security=True");  
  3.     publicvoid InsetData(string _name, string _email, string _address) {  
  4.         con.Open();  
  5.         SqlDataAdapter adpt = new SqlDataAdapter("Insert into Usertbl(Name,Email,Address) values('" + _name + "','" + _email + "','" + _address + "')", con);  
  6.         DataTable dt = new DataTable();  
  7.         adpt.Fill(dt);  
  8.         con.Close();  
  9.     }  
  10.     publicvoid DeletData(Int32 _ID) {  
  11.         con.Open();  
  12.         SqlDataAdapter adpt = new SqlDataAdapter("Delete from Usertbl where ID= " + _ID + "", con);  
  13.         DataTable dt = new DataTable();  
  14.         adpt.Fill(dt);  
  15.         con.Close();  
  16.     }  
  17.     publicobject SelectData() {  
  18.         DataTable dt = new DataTable();  
  19.         SqlDataAdapter adpt = new SqlDataAdapter("Select * from Usertbl ", con);  
  20.         adpt.Fill(dt);  
  21.         return dt;  
  22.     }  
  23.     publicvoid hfData(Int32 _hfd) {  
  24.         DataTable dt = new DataTable();  
  25.         if (dt.Rows.Count > 0) {  
  26.             SqlDataAdapter adpt = new SqlDataAdapter("Select (ID) from Usertbl values(" + _hfd + ")", con);  
  27.             adpt.Fill(dt);  
  28.         }  
  29.     }  
  30.     publicvoid UpdData(string _name, string _email, string _address, Int32 _Id) {  
  31.         con.Open();  
  32.         SqlDataAdapter adpt = new SqlDataAdapter("Update Usertbl set [Name]='" + _name + "',[Email]='" + _email + "',[Address]='" + _address + "' where [ID]=" + _Id + "", con);  
  33.         DataTable dt = new DataTable();  
  34.         adpt.Fill(dt);  
  35.         con.Close();  
  36.     }  
  37. }  

Step 4

Now, add one more “Class Libray ” with the name “BLL” to the solution explorer to implement Business Logic Layer.

Step 5

After adding BLL, add the reference of “DAL” to it.

Step 6

After adding the reference to BLL, write the following code.

Namespaces

using DAL;

code

  1. publicclasscslBLL {  
  2.     clsDAL DALobj = newclsDAL();  
  3.     publicvoid Insertvalues(string _Nam, string _email, string _address) {  
  4.         DALobj.InsetData(_Nam, _email, _address);  
  5.     }  
  6.     publicvoid Deletevalues(Int32 _id) {  
  7.         DALobj.DeletData(_id);  
  8.     }  
  9.     publicobject SelectValues() {  
  10.         return DALobj.SelectData();  
  11.     }  
  12.     publicvoid hfDataID(Int32 _id) {  
  13.         DALobj.hfData(_id);  
  14.     }  
  15.     publicvoid UpdateValues(string _name, string _email, string _address, Int32 _Id) {  
  16.         DALobj.UpdData(_name, _email, _address, _Id);  
  17.     }  
  18. }  

Step 5

Now, add a new web form with the name ”Index.aspx” to your solution explorer’s Empty website templete.

Step 6

Now, design your “Index.asp” page using the following code.

Index.aspx

  1. <%@PageLanguage="C#"AutoEventWireup="true"CodeFile="Indext.aspx.cs"Inherits="Indext"%>  
  2. <!DOCTYPEhtmlPUBLIC"-//W3C//DTD XHTML 1.0 Transitional//EN""http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">  
  3. <htmlxmlns="http://www.w3.org/1999/xhtml"> <headid="Head1" runat="server">  
  4.     <title></title>  
  5.     <styletype="text/css"> .style1 { width: 71%; } .style2 { font-size: large; color: #000046; } </style> </head> <body>  
  6.         <formid="form1"runat="server">  
  7.             <tablealign="center"class="style1">  
  8.                 <tr>  
  9.                     <td>                                                                                       <spanclass="style2"><strong>3 - Tire Architecture</strong></span>  </td>  
  10.                 </tr>  
  11.                 <tr>  
  12.                     <td>  
  13.                         <asp:HiddenFieldID="HiddenField1"runat="server" />  
  14.                     </td>  
  15.                     <td>   </td>  
  16.                     <td>   </td>  
  17.                 </tr>  
  18.                 <tr>  
  19.                     <td>                                                                       <asp:LabelID="Label1"runat="server"Text="Name">  
  20.                             </asp:Label>   <asp:TextBoxID="TextBox1"runat="server"Width="222px"Style="margin-left: 5px">  
  21.                                 </asp:TextBox>    <asp:RequiredFieldValidatorID="RequiredFieldValidator1"runat="server"ErrorMessage="Name is Reqired" ControlToValidate="TextBox1" ForeColor="Red">  
  22.                                     </asp:RequiredFieldValidator>  
  23.                     </td>  
  24.                 </tr>  
  25.                 <tr>  
  26.                     <td>                                                                    <asp:LabelID="Label2"runat="server"Text="Emmail">  
  27.                             </asp:Label>    <asp:TextBoxID="TextBox2"runat="server"Width="222px"Style="margin-left: 0px">  
  28.                                 </asp:TextBox>    <asp:RequiredFieldValidatorID="RequiredFieldValidator2"runat="server"ErrorMessage="Email is Required" ControlToValidate="TextBox2" ForeColor="Red">  
  29.                                     </asp:RequiredFieldValidator>  
  30.                     </td>  
  31.                 </tr>  
  32.                 <tr>  
  33.                     <td>                                                                    <asp:LabelID="Label3"runat="server"Text="Address">  
  34.                             </asp:Label>    <asp:TextBoxID="TextBox3"runat="server"Width="222px"Style="margin-left: 0px">  
  35.                                 </asp:TextBox>    <asp:RequiredFieldValidatorID="RequiredFieldValidator3"runat="server"ErrorMessage="Address is Required" ControlToValidate="TextBox3" ForeColor="Red">  
  36.                                     </asp:RequiredFieldValidator>  
  37.                     </td>  
  38.                 </tr>  
  39.                 <tr>  
  40.                     <td>                                                                                     
  41.                         <asp:ButtonID="Savebtn"runat="server"Text="Save"Width="62px"OnClick="Savebtn_Click" Style="margin-left: 5px" />  
  42.                         <asp:ButtonID="Updatebtn"runat="server"Text="Update"Width="63px"OnClick="Updatebtn_Click" Style="margin-left: 18px" />  
  43.                         <asp:ButtonID="Delete"runat="server"Style="text-align: left; margin-left: 15px;" Text="Delete" Width="58px" OnClick="Delete_Click" />  
  44.                     </td>  
  45.                 </tr>  
  46.                 <tr>  
  47.                     <tdstyle="text-align: left">                                                                     <asp:Label ID="Label4" runat="server" Style="text-align: center" Text="Label" Font-Bold="True" Font-Size="Large" ForeColor="#009900"></asp:Label>  
  48.                         </td>  
  49.                 </tr>  
  50.                 <tr>  
  51.                     <td>                                <asp:GridViewID="GridView1"runat="server"AutoGenerateSelectButton="True"OnSelectedIndexChanged="GridView1_SelectedIndexChanged" AutoGenerateColumns="False" OnRowDataBound="GridView1_RowDataBound" Style="margin-left: 265px;  
  52.   
  53. margin-top: -16px" BackColor="White" BorderColor="#3366CC" BorderStyle="None" BorderWidth="1px" CellPadding="4">  
  54.                             <Columns>  
  55.                                 <asp:BoundFieldDataField="ID"HeaderText="ID"ReadOnly="True"SortExpression="ID" />  
  56.                                 <asp:BoundFieldDataField="Name"HeaderText="Name"SortExpression="Name" />  
  57.                                 <asp:BoundFieldDataField="Email"HeaderText="Email"SortExpression="Email" />  
  58.                                 <asp:BoundFieldDataField="Address"HeaderText="Address"SortExpression="Address" />  
  59.                             </Columns>  
  60.                             <FooterStyleBackColor="#99CCCC"ForeColor="#003399" />  
  61.                             <HeaderStyleBackColor="#003399"Font-Bold="True"ForeColor="#CCCCFF" />  
  62.                             <PagerStyleBackColor="#99CCCC"ForeColor="#003399"HorizontalAlign="Left" />  
  63.                             <RowStyleBackColor="White"ForeColor="#003399" />  
  64.                             <SelectedRowStyleBackColor="#009999"ForeColor="#CCFF99"Font-Bold="true" />  
  65.                             <SortedAscendingCellStyleBackColor="#EDF6F6" />  
  66.                             <SortedAscendingHeaderStyleBackColor="#0D4AC4" />  
  67.                             <SortedDescendingCellStyleBackColor="#D6DFDF" />  
  68.                             <SortedDescendingHeaderStyleBackColor="#002876" />  
  69.                             </asp:GridView>  
  70.                     </td>  
  71.                 </tr>  
  72.       </table>  
  73.    </form>  
  74.   </body>  
  75. </html>  

Step 7

Now, add a reference to BLL to your solution explorer’s empty website template. Write the following code on the “Index.aspx.cs” page.

Index.aspx.cs

  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 BLL;  
  8. publicpartialclassIndext: System.Web.UI.Page {  
  9.     protectedvoid Page_Load(object sender, EventArgs e) {  
  10.         Label4.Visible = false;  
  11.     }  
  12.     protectedvoid Savebtn_Click(object sender, EventArgs e) {  
  13.         cslBLL clsBLLobj = newcslBLL();  
  14.         clsBLLobj.Insertvalues(TextBox1.Text, TextBox2.Text, TextBox3.Text);  
  15.         GridView1.DataSource = clsBLLobj.SelectValues();  
  16.         GridView1.DataBind();  
  17.         Label4.Visible = true;  
  18.         Label4.Text = "Data Insered";  
  19.     }  
  20.     protectedvoid Updatebtn_Click(object sender, EventArgs e) {  
  21.         cslBLL clsBLLobj = newcslBLL();  
  22.         clsBLLobj.UpdateValues(TextBox1.Text, TextBox2.Text, TextBox3.Text, Convert.ToInt32(HiddenField1.Value));  
  23.         GridView1.DataSource = clsBLLobj.SelectValues();  
  24.         GridView1.DataBind();  
  25.         Label4.Visible = true;  
  26.         Label4.Text = "Record Updated";  
  27.     }  
  28.     protectedvoid Delete_Click(object sender, EventArgs e) {  
  29.         cslBLL clsBLLobj = newcslBLL();  
  30.         clsBLLobj.Deletevalues(Convert.ToInt32(HiddenField1.Value));  
  31.         GridView1.DataSource = clsBLLobj.SelectValues();  
  32.         GridView1.DataBind();  
  33.         Label4.Visible = true;  
  34.         Label4.Text = "Record Deleted";  
  35.     }  
  36.     protectedvoid GridView1_SelectedIndexChanged(object sender, EventArgs e) {  
  37.         GridViewRow row = GridView1.SelectedRow;  
  38.         HiddenField1.Value = row.Cells[1].Text;  
  39.         TextBox1.Text = row.Cells[2].Text;  
  40.         TextBox2.Text = row.Cells[3].Text;  
  41.         TextBox3.Text = row.Cells[4].Text;  
  42.     }  
  43.     protectedvoid GridView1_RowDataBound(object sender, GridViewRowEventArgs e) {  
  44.         if (e.Row.RowType == DataControlRowType.Header) {  
  45.             e.Row.Cells[0].Style.Add(HtmlTextWriterStyle.Display, "none");  
  46.         }  
  47.         if (e.Row.RowType == DataControlRowType.DataRow) {  
  48.             e.Row.Cells[0].Style.Add(HtmlTextWriterStyle.Display, "none");  
  49.             e.Row.Attributes["onclick"] = ClientScript.GetPostBackClientHyperlink(this.GridView1, "Select$" + e.Row.RowIndex);  
  50.         }  
  51.     }  
  52. }  
Next Recommended Reading Values of Selected Row from a Gridview in TextBox