Hi,
I am using a GridView and in it I am using following HyperLink to pass GridView Show Date column value to the next page:
<asp:TemplateField HeaderText="Booking">
<ItemTemplate>
<asp:HyperLink ID="ShowDealers" NavigateUrl='<%#"~/ViewDealers.aspx?ShowDate=" + Eval("ShowDate") %>' runat="server">View Dealers</asp:HyperLink>
</ItemTemplate>
On the next page I want to generate a list from SQL database (populating in another GridView) and use ShowDate querystring value as a filter for WHERE statement. SQL query I am writing looks like this:
string sqlCommand = "SELECT * FROM ShowDealer WHERE ShowDate = request.querystring("ShowDate")";
But it does not work. I know it is not exactly right. Could you please give me a direction or show me a sample how to use request.querystring value in SQL WHERE f ...
Go to the complete details ...