通用b/s数据库查询控件
通用查询控件 是一个我写的服务器控件,参考了一个高手的c/s代码完成
前台使用代码
![d.jpg](/images/cnblogs_com/dxxhh/d.jpg)
<tr>
<td>
<asp:datagrid id="DataGrid1" runat="server" AllowPaging="True" PageSize="5">
<PagerStyle Visible="False"></PagerStyle>
</asp:datagrid>
<cc1:searchcontrol id="SearchControl1" runat="server" ></cc1:searchcontrol></td>
</tr>
后台
using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
![](/Images/OutliningIndicators/None.gif)
namespace webss
{
/// <summary>
/// WebForm1 的摘要说明。
///其中page*是用来分页的
/// </summary>
public class WebForm1 : System.Web.UI.Page
{
私有变量
private void Page_Load(object sender, System.EventArgs e)
{
if (!IsPostBack)
{
// this.DataGrid1.DataSource=GetDataSource();
// this.DataGrid1.DataBind();
SearchControl1.DataSource=GetDataSource();//目的只是得到,字段名字
meth(null,new my1.myargs(""));
}
Page_list1.InitPagerControls(ref this.MyDataList, "select * from dic_country",ViewState["topFileter"].ToString(),"10");
Page_grid2.InitPagerControls(ref this.Datagrid2,"select * from dic_country",ViewState["topFileter"].ToString());
SearchControl1.myEvent+=new System.EventHandler(this.meth);
}
![](/Images/OutliningIndicators/InBlock.gif)
private void meth(object sender,System.EventArgs e)
{
DataView dv=GetDataSource().DefaultView;
string ff=((my1.myargs)e).Vs ;
dv.RowFilter=ff;
ViewState["topFileter"]=ff;
this.DataGrid1.DataSource=dv;
this.DataGrid1.DataBind();
}
![](/Images/OutliningIndicators/InBlock.gif)
private DataTable GetDataSource()
{
DataSet1 ds = new DataSet1();
ds.ReadXml(Server.MapPath("~/data/NorthWindOrders.xml"));
return ds.Tables[0];
![](/Images/OutliningIndicators/InBlock.gif)
}
![](/Images/OutliningIndicators/InBlock.gif)
Web 窗体设计器生成的代码
}
}
![](/Images/OutliningIndicators/None.gif)
https://files.cnblogs.com/dxxhh/searchControl.rar 控件代码
前台使用代码
![d.jpg](/images/cnblogs_com/dxxhh/d.jpg)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
后台
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/None.gif)
![](/Images/OutliningIndicators/ExpandedBlockStart.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockStart.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/InBlock.gif)
![](/Images/OutliningIndicators/ContractedSubBlock.gif)
![](/Images/OutliningIndicators/ExpandedSubBlockEnd.gif)
![](/Images/OutliningIndicators/ExpandedBlockEnd.gif)
![](/Images/OutliningIndicators/None.gif)
https://files.cnblogs.com/dxxhh/searchControl.rar 控件代码