在vb.net中登录的筛选器参数S​​QL Server ASP.NET [英] Filter parameter SQL Server ASP.NET logged in vb.net

问题描述

你好，

自星期一以来我也遇到同样的问题...
我正在寻找从当前Windows的用户ID过滤SQL列用户字段的信息.

我按照一些说明进行了操作，但没有任何效果，我让您看到我的代码:

在我的ASP页中，我将用一个简短的查询进行测试:

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>

当我放"hermans5"而不是@genacc_user_adacc时，它可以在我的网格视图中正确显示一行

可能来自后面的代码":

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

预先谢谢您，这个问题令我发疯，根本不了解:(

谢谢

最好的问候


Samuel

Thanks you in advance, this problem makes me crazy it don''t understand at all :(

Thanks

Best Regards


Samuel

推荐答案

ConnectionStrings:LabAccManConnectionString ％> " 选择命令 =" SELECT *从[帐户用户]那里[genacc_user_adacc] = @genacc_user_adacc" < selectparameters > < asp:parameters 名称 =" 类型 字符串" / < /selectparameters > < /asp:sqldatasource >

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>

当我放"hermans5"而不是@genacc_user_adacc时，它可以在我的网格视图中正确显示一行

可能来自后面的代码":

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

提前谢谢您，这个问题让我发疯了，根本不了解:(

谢谢

最好的问候


塞缪尔(Samuel)

Thanks you in advance, this problem makes me crazy it don''t understand at all :(

Thanks

Best Regards


Samuel

Dim name As String = User.Identity.Name.Split("\"c)(1) before e.Command.Parameters("@genacc_user_adacc").Value = name

这篇关于在vb.net中登录的筛选器参数S​​QL Server ASP.NET的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！