如何使用GridView显示条件查询的结果!
请问如何使用GridView显示条件查询的结果!,我是想实现根据下拉菜单的选项作为字段名,然后根据一个TextBox里的值进行模糊查询.
<asp:DropDownList ID="DropDownList1" runat="server" AutoPostBack="True">
<asp:ListItem Selected="True">au_lname</asp:ListItem>
<asp:ListItem>phone</asp:ListItem>
<asp:ListItem>city</asp:ListItem>
</asp:DropDownList>
<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
<asp:Button ID="search" runat="server" Text="搜索" />
<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:pubsConnectionString %>" SelectCommand="SELECT au_id, au_lname, au_fname, phone, address, city, state, zip, contract FROM authors where @title like '%'+@keyword+'%'">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="title" PropertyName="SelectedValue" />
<asp:ControlParameter ControlID="TextBox1" DefaultValue=" " Name="keyword" PropertyName="Text" />
</SelectParameters>
</asp:SqlDataSource>
/////////////////////////////////////////////////////
web.config里的连接串为:
<add name="pubsConnectionString" connectionString="Data Source=.;Initial Catalog=pubs;Integrated Security=True" providerName="System.Data.SqlClient"/>
/////////////////////////////////////////
上面不能显示任何查询结果,应该怎么写!