public partial class _Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
string conn, sql;
conn = "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd;";
sql = "select addictno,name,sex from addict ";
OracleConnection cn = new OracleConnection(conn);
cn.Open();
OracleCommand cmd = new OracleCommand(sql, cn);
OracleDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataSource = rdr;
GridView1.AllowPaging = true;
GridView1.DataBind();
rdr.Close();
cn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
string conn, sql;
conn = "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd;";
sql = "select addictno,name,sex from addict ";
OracleConnection cn = new OracleConnection(conn);
cn.Open();
OracleCommand cmd = new OracleCommand(sql, cn);
OracleDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.PageIndex = e.NewPageIndex;
GridView1.PageSize = 10;
GridView1.AllowPaging = true;
GridView1.DataBind(); rdr.Close();
cn.Close();
}
}老问题,GridView1.DataBind();不允许分页的...如何改这段代码...
{
protected void Page_Load(object sender, EventArgs e)
{
string conn, sql;
conn = "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd;";
sql = "select addictno,name,sex from addict ";
OracleConnection cn = new OracleConnection(conn);
cn.Open();
OracleCommand cmd = new OracleCommand(sql, cn);
OracleDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.DataSource = rdr;
GridView1.AllowPaging = true;
GridView1.DataBind();
rdr.Close();
cn.Close();
}
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
string conn, sql;
conn = "Data Source=duke;Persist Security Info=True;User ID=gxjd;Password=gxjd;";
sql = "select addictno,name,sex from addict ";
OracleConnection cn = new OracleConnection(conn);
cn.Open();
OracleCommand cmd = new OracleCommand(sql, cn);
OracleDataReader rdr = cmd.ExecuteReader();
GridView1.DataSource = rdr;
GridView1.PageIndex = e.NewPageIndex;
GridView1.PageSize = 10;
GridView1.AllowPaging = true;
GridView1.DataBind(); rdr.Close();
cn.Close();
}
}老问题,GridView1.DataBind();不允许分页的...如何改这段代码...
解决方案 »
- cs调用客户端javascript
- 相同的数据只显示一个,形成一对多的关系。GIRDVIEW或其他控件都可
- datagrid 无刷新跳转
- 急!关于DropDownList控件的,谢谢!
- 我的智能查询系统,与大家分享!
- 我有一个c#编的asp.net定义类的文件,但是它只能和access数据库连用,有高手可以帮我改成跟sql连的吗? 文件在里面! 写明白一点可以吗?谢谢
- 在深圳哪个地方有培训.net,c#,sqlsever2000的啊?
- 我有一段简单的Web service程序,想把返回结果多加几个项,请问怎么加!
- IIS无法连接远程XP系统中的SQL数据库
- checked box怎么不管用啊?
- 一个菜菜问题。大家指点一下。:(
- windows service的执行顺序!!
{
GridViewYsxm.PageIndex = e.NewPageIndex;
BindYsxmData();
}应该是这样的吧。