View Single Post
  #10 (permalink)  
Old January 27th, 2009, 02:17 AM
mashype mashype is offline
Authorized User
 
Join Date: Jan 2009
Posts: 25
Thanks: 3
Thanked 1 Time in 1 Post
Default Heres my issue

Here is where I am storing the User:

<asp:LoginNameID="LoginName1"runat="server"CssClass="style14"/>

This lets me see the user logged in, but....

Here is what I am trying to query:

<asp:SqlDataSourceID="cookie"runat="server"
ConnectionString="<%$ ConnectionStrings:ProdConnectionString %>"SelectCommand="SELECT [UserName], [UserID], [LastName] FROM [TblUsers] WHERE ([UserName] LIKE '%' + @UserName + '%')">
<SelectParameters>
<asp:CookieParameterCookieName="'LoginName1'"Name="UserName"Type="String"/>
</SelectParameters>
</asp:SqlDataSource>

This query does not return any values......any suggestions?