如何使用asp.net成员资格注释字段查询SQL数据源 [英] How to query SQL Data Source using asp.net Membership Comment Field

问题描述

我正在尝试使用asp.net成员资格提供程序注释字段作为参数来查询SQL数据源.
我的查询字符串如下所示:

I am trying to query a SQL Data Source by using the asp.net Membership Provider Comment Field as a parameter.
My Query String looks like this:

<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:dot_FremdConnectionString %>"
        SelectCommand="SELECT Maschine, Typ, Hostname, IP, Status FROM test WHERE Kunde= @Comment"
        <SelectParameters>
            
        </SelectParameters>

所以我想知道SelectParameter.
谁能告诉我如何编写此SelectParameter?

提前谢谢您.

So i am wondering about the SelectParameter.
Can anyone told me how to write this SelectParameter?

Thank you in advance.

推荐答案

ConnectionStrings:dot_FremdConnectionString％> SelectCommand ="SELECT机器，类型，主机名，IP，状态来自测试WHERE Kunde = @Comment" < SelectParameters> </SelectParameters>

ConnectionStrings:dot_FremdConnectionString %>" SelectCommand="SELECT Maschine, Typ, Hostname, IP, Status FROM test WHERE Kunde= @Comment" <SelectParameters> </SelectParameters>

所以我想知道SelectParameter.
谁能告诉我如何编写此SelectParameter?

提前谢谢您.

So i am wondering about the SelectParameter.
Can anyone told me how to write this SelectParameter?

Thank you in advance.

此处是有关如何查询sql数据源的深入说明的很好的链接.以及如何使用VS工具配置SQL数据源并为您生成代码.


http://www.asp.net/(S( pdfrohu0ajmwt445fanvj2r3))/learn/data-access/tutorial-48-vb.aspx

Here is a good link to an in depth explanation on how to query a sql datasource. Also how to use VS tool to configure an SQL Datasource and generate code for you.


http://www.asp.net/(S(pdfrohu0ajmwt445fanvj2r3))/learn/data-access/tutorial-48-vb.aspx

这篇关于如何使用asp.net成员资格注释字段查询SQL数据源的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！