asp.net QueryStringParameter example: using GridView, SqlDataSource
QueryStringParameterExample.aspx
<%@ Page Language="C#" %>
<!DOCTYPE html>
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>asp.net QueryStringParameter example: using GridView, SqlDataSource</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:Red">QueryStringParameter and GridView Example</h2>
<asp:SqlDataSource
ID="SqlDataSource1"
runat="server"
ConnectionString="<%$ ConnectionStrings:NorthwindConnectionString %>"
SelectCommand="SELECT ProductID, ProductName, UnitPrice, Discontinued FROM Products WHERE SupplierID=@SupplierID"
>
<SelectParameters>
<asp:QueryStringParameter Name="SupplierID" QueryStringField="QSSupplierID" />
</SelectParameters>
</asp:SqlDataSource>
<asp:GridView
ID="GridView1"
runat="server"
DataSourceID="SqlDataSource1"
BackColor="CornflowerBlue"
ForeColor="AliceBlue"
Font-Italic="true"
GridLines="Horizontal"
HeaderStyle-BackColor="DarkBlue"
HeaderStyle-ForeColor="White"
HeaderStyle-Font-Italic="false"
BorderColor="LightBlue"
>
</asp:GridView>
</div>
</form>
</body>
</html>
HyperLinkExample.aspx
<%@ Page Language="C#" %>
<!DOCTYPE html>
<script runat="server">
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<title>QueryStringParameter example</title>
</head>
<body>
<form id="form1" runat="server">
<div>
<h2 style="color:Teal">HyperLink With QueryString</h2>
<asp:HyperLink
ID="HyperLink1"
runat="server"
NavigateUrl="~/QueryStringParameterExample.aspx?QSSupplierID=1"
Text="SupplierID=1: ProductList"
>
</asp:HyperLink>
</div>
</form>
</body>
</html>
- asp.net ControlParameter example: how to use ControlParameter
- asp.net DetailsView example: how to use DetailsView
- asp.net SqlCommand example: how to use SqlCommand
- asp.net SqlConnection example: how to use SqlConnection
- asp.net Data Update example: using GridView and SqlDataSource
- asp.net try, catch, finally, Exception example: how to handle error
