repeater分页显示方法问题

[ww7610]

//Repeater分页控制显示方法
public void contrlRepeater(int userId)
{
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 + "";
DataTable dt = new DataTable(sql,conn);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
pds.PageSize = 5;
pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
rpUserList.DataSource = pds;
LabCountPage.Text = pds.PageCount.ToString();
labPage.Text = (pds.CurrentPageIndex + 1).ToString();
this.lbtnpritPage.Enabled = true;
this.lbtnFirstPage.Enabled = true;
this.lbtnNextPage.Enabled = true;
this.lbtnDownPage.Enabled = true;
if (pds.CurrentPageIndex < 1)
{
this.lbtnpritPage.Enabled = false;
this.lbtnFirstPage.Enabled = false;
}
if (pds.CurrentPageIndex == pds.PageCount - 1)
{
this.lbtnNextPage.Enabled = false;
this.lbtnDownPage.Enabled = false;
}
rpUserList.DataBind();
}
在DataTable dt = new DataTable(sql,conn);这句中报出下面两个错误

//错误 2 与“System.Data.DataTable.DataTable(string, string)”最匹配的重载方法具有一些无效参数
//错误 3 参数“2”: 无法从“System.Data.SqlClient.SqlConnection”转换为“string”

[Im_Sorry]

你创建table,没有进行填充fill,

[ww7610]

[Quote=引用楼主 的回复:]
//Repeater分页控制显示方法
public void contrlRepeater(int userId)
{
string connectionString = ConfigurationManager.ConnectionStrings["db_health"].ConnectionString;
SqlConnection c……
[/Quote]


我的页面使用上面语句，repeater显示不出内容

[慕容玄明]

DataTable第二个参数不是sql连接，而是连接字符串。

[ww7610]

[Quote=引用 3 楼 的回复:]

DataTable第二个参数不是sql连接，而是连接字符串。
[/Quote]


//Repeater分页控制显示方法
public void contrlRepeater(int userId)
{
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 sda = new SqlDataAdapter(sql,conn);
DataTable dt = new DataTable();
sda.Fill(dt);
PagedDataSource pds = new PagedDataSource();
pds.DataSource = dt.DefaultView;
pds.AllowPaging = true;
pds.PageSize = 5;
pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1;
rpUserList.DataSource = pds;
LabCountPage.Text = pds.PageCount.ToString();
labPage.Text = (pds.CurrentPageIndex + 1).ToString();
this.lbtnpritPage.Enabled = true;
this.lbtnFirstPage.Enabled = true;
this.lbtnNextPage.Enabled = true;
this.lbtnDownPage.Enabled = true;
if (pds.CurrentPageIndex < 1)
{
this.lbtnpritPage.Enabled = false;
this.lbtnFirstPage.Enabled = false;
}
if (pds.CurrentPageIndex == pds.PageCount - 1)
{
this.lbtnNextPage.Enabled = false;
this.lbtnDownPage.Enabled = false;
}
rpUserList.DataBind();
}
我现在改成这样了，看看对吗，这样没有错误了，但是显示不出数据

[webdiyer]

建议楼主试试AspNetPager，你自己写那么多代码，太难调试也太费时间了
http://www.webdiyer.com/controls/aspnetpager

[yp19910928]

DataTable第二个参数不是sql连接，而是连接字符串。

[ww7610]

[Quote=引用 6 楼 的回复:]

DataTable第二个参数不是sql连接，而是连接字符串。
[/Quote]

还是不明白，应该如何写