Question

数据源不支持服务器端的数据分页

if(!this.IsPostBack)
{
string newsTypeID = Request.QueryString["TypeID"].ToString();
SqlConnection con = DB.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select newsTypeName from newsType where newsTypeID='" + newsTypeID + "'",con);
this.Label1.Text = Convert.ToString(cmd.ExecuteScalar());
cmd.CommandText = "select * from newsTile where newsTypeID='" + newsTypeID + "'";
SqlDataReader sdr = cmd.ExecuteReader();
this.GridView1.DataSource = sdr;
this.GridView1.DataBind();
}

知道要用Dataset 不知道怎么改啊

Answer 1

很简单的.

因为你是SqlDataReader sdr = cmd.ExecuteReader(); 来绑定..
SqlDataReader是只能向前的记录集..是不支持分页的.

你改成用datatable来绑定就可以了.

一定绑定控件都是用这个来绑定的..以后要注意了.

Answer 2

f(!this.IsPostBack)
{
string newsTypeID = Request.QueryString["TypeID"].ToString();
SqlConnection con = DB.createConnection();
con.Open();
string sqlstr= "select * from newsTile where newsTypeID='" + newsTypeID + "'";
SqlDataAdapter da = new SqlDataAdapter(sqlstr,con);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
}
这样就行了啊,看清楚了啊,呵呵

Answer 3

if(!this.IsPostBack)
{
string newsTypeID = Request.QueryString["TypeID"].ToString();
SqlConnection con = DB.createConnection();
con.Open();
SqlCommand cmd = new SqlCommand("select newsTypeName from newsType where newsTypeID='" + newsTypeID + "'",con);
this.Label1.Text = Convert.ToString(cmd.ExecuteScalar());
cmd.CommandText = "select * from newsTile where newsTypeID='" + newsTypeID + "'";
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet(); da.Fill(ds);
GridView1.DataSource = ds.Tables[0].DefaultView;
GridView1.DataBind();
最后四排改成了用Dataset来进行，这样就可以用数据分页。