LinkButton in GridView and QueryString in ASP.NET

This example explains how to use LinkButton in GridView and QueryString in ASP.NET to pass or transfer variable data to other page using QueryString and QueryStringParameters.

I've put a searchbox at the top of page and based on search text entered in textbox, gridview is populated, In the gridview i've put a Link Button in ItemTemplate column.



LinkButton field is hyperlink which points to Details.aspx and sends RecordID as QueryString to Details.aspx page where another gridview is populated to show Details of selected record by retrieving the QueryString variable using QueryStringParameters.

HTML SOURCE OF DEFAULT.ASPX

---

<asp:TextBox ID="txtSearch" runat="server"/>

<asp:Button ID="btnSearch" runat="server"

            Text="Search" OnClick="btnSearch_Click"/>

<asp:GridView ID="GridView1" runat="server"

              AutoGenerateColumns="False"

              DataSourceID="SqlDataSource1">

<Columns>

<asp:TemplateField HeaderText="Name">

<ItemTemplate>

<asp:LinkButton ID="lnkname" runat="server"

                Text='<%#Eval("Name") %>'

                PostBackUrl='<%#"~/Details.aspx?ID="+Eval("ID")%>'>

</asp:LinkButton>

</ItemTemplate>

</asp:TemplateField>

<asp:BoundField DataField="City" HeaderText="City"/>

</Columns>

</asp:GridView>

<asp:SqlDataSource ID="SqlDataSource1" runat="server"

ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

SelectCommand="SELECT [ID], [Name], [City], [Country]

               FROM [Location]

               WHERE ([Name] LIKE '%' + @Name + '%')">

<SelectParameters>

<asp:ControlParameter ControlID="txtSearch" Name="Name" 

                      PropertyName="Text" Type="String"/>

</SelectParameters>

</asp:SqlDataSource>

HTML SOURCE OF DETAILS.ASPX

---

   1:  <asp:GridView ID="GridView1" runat="server"

   2:                AutoGenerateColumns="False"

   3:                DataSourceID="SqlDataSource1">

   4:  <Columns>

   5:  <asp:BoundField DataField="ID" HeaderText="ID"/>

   6:  <asp:BoundField DataField="Name" HeaderText="Name"/>

   7:  <asp:BoundField DataField="City" HeaderText="City"/>

   8:  <asp:BoundField DataField="Country" HeaderText="Country"/>

   9:  </Columns>

  10:  </asp:GridView>

  11:   

  12:  <asp:SqlDataSource ID="SqlDataSource1" runat="server"

  13:  ConnectionString="<%$ ConnectionStrings:ConnectionString %>"

  14:  SelectCommand="SELECT [ID], [Name], [City], [Country]

  15:                 FROM [Location] WHERE ([ID] = @ID)">

  16:   

  17:  <SelectParameters>

  18:  <asp:QueryStringParameter Name="ID" QueryStringField="ID" 

  19:                            Type="Decimal"/>

  20:  </SelectParameters>

  21:  </asp:SqlDataSource>

Related Posts:
Creating winforms AutoComplete TextBox using C# in Windows application
Disable copy paste cut and right click in textbox on aspx page using javascript
Ajax autocomplete extender textbox in EditItemTemaplate of GridView
ASP.NET-Exporting paging enabled GridView to pdf using iTextSharp and C#

Tweet

If you like this post than join us or share