I have a SQL data source and I'm trying to concatenate the logged in user with my SQL SELECT string. I think I have the syntax wrong, though. Can someone help?
<asp:SqlDataSource ID="SqlDataSource1" runat="server"
ConnectionString="<%$ ConnectionStrings:SQLConnection %>"
SelectCommand="SELECT dcca_firstname, FROM tblDCCreditApplication WHERE dcca_userid='" & DirectCast(Page, PageBaseClass).CurrentLoggedUser.ID & "'">