为什么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>

解决方案 »

  1.   

    这里有一个例子，你好好研究下吧~
    <!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>