hello,
I have the same probleme since monday...
I'm looking for filtering my SQL's columns user field from the current windows's userid .
I followed some explaination but nothing works i let you see my code:
in my ASP page I would test with a short query:
<asp:sqldatasource id="SqlDataSource1" runat="server" connectionstring="<%$ ConnectionStrings:LabAccManConnectionString %>"
selectcommand="SELECT * FROM [account_user] WHERE [genacc_user_adacc] = @genacc_user_adacc">
<selectparameters>
<asp:parameter name="genacc_user_adacc" type="String" />
</selectparameters>
</asp:sqldatasource>
when i put 'hermans5' instead of @genacc_user_adacc it works it displays one line properly into my grid view
may be it come from the "code behind":
Imports System.Text.RegularExpressions
Imports System
Partial Class userpage
Inherits System.Web.UI.Page
Protected Sub SqlDataSource1_Selecting(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.SqlDataSourceSelectingEventArgs) Handles SqlDataSource1.Selecting
e.Command.Parameters("@genacc_user_adacc").Value = Me.User.Identity.Name
End Sub
End Class
Thanks you in advance, this problem makes me crazy it don't understand at all :(
Thanks
Best Regards
Samuel