Posted on: 7/10/2014 1:50:39 PM | Views : 431

Hi,
I have a form on which I take userid, username and store in table.
Now, I want to retrieve the data for userid or username.
Currently what is happening is when I make session It's shows nothing on the page. But when I use gridview without session and select all fields * then it shows all the data on page.

This is my aspx :
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:userConnectionString %>" SelectCommand="SELECT * FROM [Quotes] WHERE ([UserName] = @UserName)"> <SelectParameters> <asp:SessionParameter Name="UserName" SessionField="Session" Type="String" /> </SelectParameters> </asp:SqlDataSource> <asp:GridView ID="GridView1" runat=" ...

Go to the complete details ...