能查询出数据来,但是一点击分页,GridView控件就不见了?是怎么回事呀?高手来帮忙呀!
以下为部分代码:
//打开数据库类
public class OpenDataBase
{
String strConn;
public OpenDataBase()
{
strConn = ConfigurationManager.ConnectionStrings["ConnAcmDB"].ConnectionString;
}
public void OpenDB(string strSql, GridView gv)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
da.Fill(ds);
}
gv.DataSource = ds;
gv.DataBind();
}
}//PageIndexChanging
protected void gvY3InState_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InState.PageIndex = e.NewPageIndex;
gvY3InState.DataBind();
}protected void gvY3InReadCard_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InReadCard.PageIndex = e.NewPageIndex;
gvY3InReadCard.DataBind();
}
//查询数据,绑定到GridView
protected void bntQuery_Click(object sender, EventArgs e)
{
if (DrpList_XM.Text.Trim() == "设备状态")
{
strSql = "select * from Y3InHardwareSB_Steta_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InState);
}
else if (DrpList_XM.Text.Trim() == "操作记录")
{
strSql = "select * from Y3InReadCard_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InReadCard);
}
}
以下为部分代码:
//打开数据库类
public class OpenDataBase
{
String strConn;
public OpenDataBase()
{
strConn = ConfigurationManager.ConnectionStrings["ConnAcmDB"].ConnectionString;
}
public void OpenDB(string strSql, GridView gv)
{
DataSet ds = new DataSet();
using (SqlConnection conn = new SqlConnection(strConn))
{
SqlDataAdapter da = new SqlDataAdapter(strSql, conn);
da.Fill(ds);
}
gv.DataSource = ds;
gv.DataBind();
}
}//PageIndexChanging
protected void gvY3InState_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InState.PageIndex = e.NewPageIndex;
gvY3InState.DataBind();
}protected void gvY3InReadCard_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InReadCard.PageIndex = e.NewPageIndex;
gvY3InReadCard.DataBind();
}
//查询数据,绑定到GridView
protected void bntQuery_Click(object sender, EventArgs e)
{
if (DrpList_XM.Text.Trim() == "设备状态")
{
strSql = "select * from Y3InHardwareSB_Steta_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InState);
}
else if (DrpList_XM.Text.Trim() == "操作记录")
{
strSql = "select * from Y3InReadCard_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InReadCard);
}
}
解决方案 »
- 用asp.net 后台绑定javascript做的动态新闻幻灯片播放效果?急!
- 在DATAVIEW查询结果打开对应的路径文件.
- 如何判断 Request["one"]的值是不是空值,最好是2.0中的方法,在线
- .net 2.0数据绑定的问题
- 郁闷,网站程序放到Win2003下无法正常操作执行,请问这是什么原因?
- 根据数据库,动态显示treeview
- 100分求救 ————如何在一个DATAGRID中动态生成一个模板列,并在这个列中加上一个RadioButton
- 能否介绍一些.NET的电子版读物?
- .net调试网站突然变得很慢
- 菜鸟请教各位高手!ASP。NET的怪现象——————急--急--急--急--急--——————
- ASP.NET网站管理工具出错~~~急,求救
- 这个功能怎么实现的?
{
gvY3InState.PageIndex = e.NewPageIndex; //分页
strSql = "select * from Y3InHardwareSB_Steta_view"; //分页后的数据 ...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InState);
}
protected void gvY3InState_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InState.PageIndex = e.NewPageIndex;
strSql = "select * from Y3InHardwareSB_Steta_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InState);
} protected void gvY3InReadCard_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
gvY3InReadCard.PageIndex = e.NewPageIndex;
strSql = "select * from Y3InReadCard_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InReadCard);
}
//查询数据,绑定到GridView
protected void bntQuery_Click(object sender, EventArgs e)
{
if (DrpList_XM.Text.Trim() == "设备状态")
{
strSql = "select * from Y3InHardwareSB_Steta_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InState);
}
else if (DrpList_XM.Text.Trim() == "操作记录")
{
strSql = "select * from Y3InReadCard_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InReadCard);
}
}
如果行的话。
把
strSql = "select * from Y3InReadCard_view";
...
...//增加一些条件选择SQL语句
db.OpenDB(strSql, gvY3InReadCard);
放到一个方法里,然后两处调用就行了
http://blog.csdn.net/insus/archive/2008/03/30/2229911.aspx
但这样会不会太浪费资源了?如果有几十万条数据会不会很慢呀?
然后调用,这样思路会比较清晰点。
{
GridView1.PageIndex = e.NewPageIndex;
bindData();//绑定数据
}