通用b/s数据库查询控件
通用查询控件 是一个我写的服务器控件,参考了一个高手的c/s代码完成
前台使用代码
![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;
![]()
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);
}
![]()
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();
}
![]()
private DataTable GetDataSource()
{
DataSet1 ds = new DataSet1();
ds.ReadXml(Server.MapPath("~/data/NorthWindOrders.xml"));
return ds.Tables[0];
![]()
}
![]()
Web 窗体设计器生成的代码
}
}
![]()
https://files.cnblogs.com/dxxhh/searchControl.rar 控件代码
前台使用代码

<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;
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);
}
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();
}
private DataTable GetDataSource()
{
DataSet1 ds = new DataSet1();
ds.ReadXml(Server.MapPath("~/data/NorthWindOrders.xml"));
return ds.Tables[0];
}
Web 窗体设计器生成的代码
}
}
https://files.cnblogs.com/dxxhh/searchControl.rar 控件代码


浙公网安备 33010602011771号