62,074
社区成员
发帖
与我相关
我的任务
分享
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
Bing();
}
}
protected void Bing()
{
string s = "server=.\\sql2005;database=test;uid=sa;pwd=123456;";
SqlConnection conn = new SqlConnection(s);
string sql = "select * from [user]";
SqlCommand cmd = new SqlCommand(sql, conn);
SqlDataAdapter sda = new SqlDataAdapter(sql, conn);
DataSet Set = new DataSet();
sda.Fill(Set);
PagedDataSource pds = new PagedDataSource();
pds.AllowPaging = true;
pds.PageSize = AspNetPager1.PageSize;
pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1;
pds.DataSource = Set.Tables[0].DefaultView;
gv.DataSource = pds;
gv.DataBind();
}
protected void AspNetPager1_PageChanged(object sender, EventArgs e)
{
Bing();
}