62,073
社区成员
发帖
与我相关
我的任务
分享为什么SelectParameters参数方式不对。
<asp:GridView ID="GridView1" runat="server" AllowPaging="True" AllowSorting="True"
AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="100%">
<Columns>
<asp:BoundField DataField="qyzzjgdm" HeaderText="机构代码" SortExpression="yxrq" />
<asp:BoundField DataField="qymc" HeaderText="企业名称" SortExpression="qymc" />
<asp:BoundField DataField="qyfr" HeaderText="企业法人" SortExpression="qyfr" />
<asp:BoundField DataField="gyxkzbh" HeaderText="工业许可证编号" SortExpression="gyxkzbh" />
<asp:BoundField DataField="wsxkzbh" HeaderText="卫生许可证编号" SortExpression="wsxkzbh" />
<asp:BoundField DataField="fzrq" HeaderText="发证日期" SortExpression="fzrq" />
<asp:BoundField DataField="yxrq" HeaderText="有效日期" SortExpression="yxrq" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SOUCon %>"
SelectCommand="SELECT qyzzjgdm, qymc, wsxkzbh, gyxkzbh, qyfr, fzrq, yxrq FROM SP WHERE (qyzzjgdm LIKE '%' + @qyzzjgdm + '%') AND (qymc LIKE '%' + @qymc + '%') AND (qyfr LIKE '%' + @qyfr + '%') AND (wsxkzbh LIKE '%' + @wsxkzbh + '%') AND (gyxkzbh LIKE '%' + @gyxkzbh + '%')" >
<SelectParameters>
<asp:QueryStringParameter Name="qyzzjgdm" QueryStringField="qyzzjgdm" Type="String" />
<asp:QueryStringParameter Name="qymc" QueryStringField="qymc" Type="String" />
<asp:QueryStringParameter Name="qyfr" QueryStringField="qyfr" Type="String" />
<asp:QueryStringParameter Name="wsxkzbh" QueryStringField="wsxkzbh" Type="String" />
<asp:QueryStringParameter Name="gyxkzbh" QueryStringField="gyxkzbh" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
AutoGenerateColumns="False" DataSourceID="SqlDataSource1" Width="100%">
<Columns>
<asp:BoundField DataField="qyzzjgdm" HeaderText="机构代码" SortExpression="yxrq" />
<asp:BoundField DataField="qymc" HeaderText="企业名称" SortExpression="qymc" />
<asp:BoundField DataField="qyfr" HeaderText="企业法人" SortExpression="qyfr" />
<asp:BoundField DataField="gyxkzbh" HeaderText="工业许可证编号" SortExpression="gyxkzbh" />
<asp:BoundField DataField="wsxkzbh" HeaderText="卫生许可证编号" SortExpression="wsxkzbh" />
<asp:BoundField DataField="fzrq" HeaderText="发证日期" SortExpression="fzrq" />
<asp:BoundField DataField="yxrq" HeaderText="有效日期" SortExpression="yxrq" />
</Columns>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:SOUCon %>"
SelectCommand="SELECT qyzzjgdm, qymc, wsxkzbh, gyxkzbh, qyfr, fzrq, yxrq FROM SP WHERE (qyzzjgdm LIKE '%' + @qyzzjgdm + '%') AND (qymc LIKE '%' + @qymc + '%') AND (qyfr LIKE '%' + @qyfr + '%') AND (wsxkzbh LIKE '%' + @wsxkzbh + '%') AND (gyxkzbh LIKE '%' + @gyxkzbh + '%')" >
<SelectParameters>
<asp:QueryStringParameter Name="qyzzjgdm" QueryStringField="qyzzjgdm" Type="String" />
<asp:QueryStringParameter Name="qymc" QueryStringField="qymc" Type="String" />
<asp:QueryStringParameter Name="qyfr" QueryStringField="qyfr" Type="String" />
<asp:QueryStringParameter Name="wsxkzbh" QueryStringField="wsxkzbh" Type="String" />
<asp:QueryStringParameter Name="gyxkzbh" QueryStringField="gyxkzbh" Type="String" />
</SelectParameters>
</asp:SqlDataSource>
...全文
请发表友善的回复…
发表回复
寒沙胜雪 2011-09-19
- 打赏
- 举报
我擦，时隔N年了。
寒沙胜雪 2011-09-19
- 打赏
- 举报
LS的貌似是提供控件的参数啊。
luojinping 2011-07-21
- 打赏
- 举报
这里有一个例子，你好好研究下吧~
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>ASP.NET Example</title>
</head>
<body>
<form id="form1" runat="server">
<p><asp:dropdownlist
id="DropDownList1"
runat="server"
autopostback="True">
<asp:listitem selected="True">Sales Representative</asp:listitem>
<asp:listitem>Sales Manager</asp:listitem>
<asp:listitem>Vice President, Sales</asp:listitem>
</asp:dropdownlist></p>
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$ ConnectionStrings:MyNorthwind%>"
selectcommand="SELECT LastName FROM Employees WHERE Title = @Title">
<selectparameters>
<asp:controlparameter name="Title" controlid="DropDownList1" propertyname="SelectedValue"/>
</selectparameters>
</asp:sqldatasource>
<p><asp:listbox
id="ListBox1"
runat="server"
datasourceid="SqlDataSource1"
datatextfield="LastName">
</asp:listbox></p>
</form>
</body>
</html>
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml" >
<head runat="server">
<title>ASP.NET Example</title>
</head>
<body>
<form id="form1" runat="server">
<p><asp:dropdownlist
id="DropDownList1"
runat="server"
autopostback="True">
<asp:listitem selected="True">Sales Representative</asp:listitem>
<asp:listitem>Sales Manager</asp:listitem>
<asp:listitem>Vice President, Sales</asp:listitem>
</asp:dropdownlist></p>
<asp:sqldatasource
id="SqlDataSource1"
runat="server"
connectionstring="<%$ ConnectionStrings:MyNorthwind%>"
selectcommand="SELECT LastName FROM Employees WHERE Title = @Title">
<selectparameters>
<asp:controlparameter name="Title" controlid="DropDownList1" propertyname="SelectedValue"/>
</selectparameters>
</asp:sqldatasource>
<p><asp:listbox
id="ListBox1"
runat="server"
datasourceid="SqlDataSource1"
datatextfield="LastName">
</asp:listbox></p>
</form>
</body>
</html>
