protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack) {
SqlConnection conn = DB.getConnection();
conn.Open();
SqlCommand Count = new SqlCommand();
Count.Connection = conn;
Count.CommandText = "select count(*) from T_SoftDown1";
AspNetPager1.RecordCount = (int)Count.ExecuteScalar();
//Response.Write(AspNetPager1.RecordCount);
conn.Close();
BindData();
} } public void BindData()
{
SqlConnection conn = DB.getConnection();
string sql = "select * from T_SoftDown1 order by E_id desc";//这句在大型数据中应该用:select top查询语句
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "temptbl");
DataTable dt = ds.Tables["temptbl"];
SoftDown.DataSource=dt;
SoftDown.DataBind();
}上面调用下面的方法,可是上下都有sql语句,各自代表什么意思呢?
{
if (!IsPostBack) {
SqlConnection conn = DB.getConnection();
conn.Open();
SqlCommand Count = new SqlCommand();
Count.Connection = conn;
Count.CommandText = "select count(*) from T_SoftDown1";
AspNetPager1.RecordCount = (int)Count.ExecuteScalar();
//Response.Write(AspNetPager1.RecordCount);
conn.Close();
BindData();
} } public void BindData()
{
SqlConnection conn = DB.getConnection();
string sql = "select * from T_SoftDown1 order by E_id desc";//这句在大型数据中应该用:select top查询语句
SqlDataAdapter da = new SqlDataAdapter(sql, conn);
DataSet ds = new DataSet();
da.Fill(ds, AspNetPager1.PageSize * (AspNetPager1.CurrentPageIndex - 1), AspNetPager1.PageSize, "temptbl");
DataTable dt = ds.Tables["temptbl"];
SoftDown.DataSource=dt;
SoftDown.DataBind();
}上面调用下面的方法,可是上下都有sql语句,各自代表什么意思呢?
解决方案 »
- 网页 播放器(.mpg格式的)
- .net怎么监视网页
- 用asp.net如何实现禁止在textbox中粘贴
- net中web程序怎么在服务器上部署
- |zyciis| 如何完全防止网站数据库注入呢 大家来看看我的方法 这样做 还有什么办法可以注入
- 快疯了。。。我真的表达不清了。。嘛。顺便补习下语文。。你们帮我补习下C#
- 页面加载的一个问题
- 弱弱的问个问题。。。。
- ***********************请问关于创建存储过程的问题******************
- 我在datagrid中嵌套了一个datagrid子控件,我如何实现分页!!!
- http://localhost:49538/TPInfoPlat/index.html无法显示网页,去掉数字就可以显示了?
- **************怎么样才能把信息同步到新浪微博呢?**************
select * from T_SoftDown1 order by E_id desc
才是得到具体的内容
{
string connectionString = ConfigurationManager.ConnectionStrings["db_health"].ConnectionString;
SqlConnection conn = new SqlConnection(connectionString);
conn.Open();
string sql = "select * from health_user_followup_content where user_id=" + userId + "";
SqlDataAdapter da = new SqlDataAdapter(sql,conn);
DataSet ds = new DataSet();
da.Fill(ds.AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"FollowContent");
DataTable dt = ds.Tables["FollowContent"];
rpUserList.DataSource = dt;
rpUserList.DataBind();
}
da.Fill(ds.AspNetPager1.PageSize*(AspNetPager1.CurrentPageIndex-1),AspNetPager1.PageSize,"FollowContent");
这句话的ds.AspNetPager1报出下面的错误
//“System.Data.DataSet”不包含“AspNetPager1”的定义,并且找不到可接受类型为“System.Data.DataSet”的第一个参数的扩展方法“AspNetPager1”(是否缺少 using 指令或程序集引用?