if (!IsPostBack)
{
string sql = "select *,datediff(hh,getdate(),yqwc_time) as sy from ask_info where request_man='" + Session["user_name"].ToString() + "' order by ask_from_time desc";
ask_list(sql, GridView1);
}public void ask_list(string sql, GridView GridView1)
{
SqlConnection con = DB.CreateConn();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet myds = new DataSet();
con.Open();
sda.Fill(myds, "ask_list");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sda.Dispose();
con.Close();
con.Dispose();
}我在GridView属性里设置了AllowPaging="True" protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
}我为什么我点击GridView控件上的自动生成的页数不换页呢?
而且点一个页数时要点两下才不能点(没有连接了)请指教!
{
string sql = "select *,datediff(hh,getdate(),yqwc_time) as sy from ask_info where request_man='" + Session["user_name"].ToString() + "' order by ask_from_time desc";
ask_list(sql, GridView1);
}public void ask_list(string sql, GridView GridView1)
{
SqlConnection con = DB.CreateConn();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet myds = new DataSet();
con.Open();
sda.Fill(myds, "ask_list");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sda.Dispose();
con.Close();
con.Dispose();
}我在GridView属性里设置了AllowPaging="True" protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
}我为什么我点击GridView控件上的自动生成的页数不换页呢?
而且点一个页数时要点两下才不能点(没有连接了)请指教!
解决方案 »
- 【求助】rangeVal的MaximumValue属性的值无法转换为类型Integer
- 请问有人知道asp.net中加入ascx控件后Button无事件了,是怎么回事?
- (急)DllImport如何对项目文件中的DLL进行引用
- windows.open() 和 window.showModalDialog ()区别是什么
- 如何把一个对象放在GLOBAL.asax中?
- cookie问题
- 使用了存贮过程,但是提交英文新闻还是出错!
- 大家谁实现过在webforms上实现气球提示错误这个功能?
- 怎么取得Oracle数据表中ROWID(是oracle随机编排的行索引)列值?
- Repeater控件获取div
- 如果新闻系统 中生成的静态页面使用 shtml 格式的服务器指令来包含 其它页面。
- 请问怎样在类库文件中使用session?
ask_list(sql, GridView1);
{
string sql = "select *,datediff(hh,getdate(),yqwc_time) as sy from ask_info where request_man='" + Session["user_name"].ToString() + "' order by ask_from_time desc";
SqlConnection con = DB.CreateConn();
SqlDataAdapter sda = new SqlDataAdapter(sql, con);
DataSet myds = new DataSet();
con.Open();
sda.Fill(myds, "ask_list");
GridView1.DataSource = myds.Tables[0];
GridView1.DataKeyNames = new string[] { "id" };//主键
GridView1.DataBind();
sda.Dispose();
con.Close();
con.Dispose();
}
...
if (!IsPostBack)
{ BindData();
}
...
protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GridView1.PageIndex = e.NewPageIndex;
BindData();
}
{
GridView1.PageIndex = e.NewPageIndex;
BindData();
}