<asp:GridView ID="GridView1" runat="server" DataSourceID="SqlDataSource1">
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.;Initial Catalog=Test;User ID=sa;pwd=sa"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [表] where Name like '%'+@Name+'%'">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="Name" Type="String" />
</SelectParameters>
</asp:GridView>
<asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="Data Source=.;Initial Catalog=Test;User ID=sa;pwd=sa"
ProviderName="System.Data.SqlClient" SelectCommand="SELECT * FROM [表] where Name like '%'+@Name+'%'">
<SelectParameters>
<asp:ControlParameter ControlID="DropDownList1" Name="Name" Type="String" />
</SelectParameters>
string s = DropDownList1.SelectValue;
或
string s = DropDownList1.SelectText;
把SelectCommand设成根据ddl的value取数据 后台执行绑定
具体显示的样式 就自己定把。。
我用的是 ASP.NET 技术,C#语言编写的.
不支持ControlParameter GridView呢
为什么呢?
有合适者联系:[email protected]
MSN:[email protected]