新手上路遇到点麻烦,请高手支招,谢谢问题如下:使用Gridview提示 数据源不支持服务器端的数据分页以下是我的代码
protected void btnSearch_Click(object sender, EventArgs e)
{
String strContent;
strContent ="%"+this.txtContent.Text+"%";
string connString = System.Configuration.ConfigurationManager.ConnectionStrings["ResourceWebConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn; cmd.CommandText = "select * from Visit where "+this.ddlList.Text+" like @Content";
cmd.Parameters.AddWithValue("@Content", strContent);
conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); this.GridView1.DataSource = dr;
//绑定
this.GridView1.DataBind(); conn.Close();
}
}在网上查了下,好象是说SqlDataReader不支持分页,要换用DataSet,因为刚开始学习不熟悉,想请教下以上我写的查询代码该如何改,谢谢
protected void btnSearch_Click(object sender, EventArgs e)
{
String strContent;
strContent ="%"+this.txtContent.Text+"%";
string connString = System.Configuration.ConfigurationManager.ConnectionStrings["ResourceWebConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn; cmd.CommandText = "select * from Visit where "+this.ddlList.Text+" like @Content";
cmd.Parameters.AddWithValue("@Content", strContent);
conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); this.GridView1.DataSource = dr;
//绑定
this.GridView1.DataBind(); conn.Close();
}
}在网上查了下,好象是说SqlDataReader不支持分页,要换用DataSet,因为刚开始学习不熟悉,想请教下以上我写的查询代码该如何改,谢谢
解决方案 »
- 提取中文字符?
- session失效问题
- DataList更新数据问题!解决后马上给分。
- 从网上下的代码在vs2005调试成功,请问怎样脱离vs2005环境调试代码呢?
- 从装系统后以前的项目不能调试, 后创建的项目可以调试
- ========ASP.NET中调用js文件中的函数的问题========
- 看过PetShop3.0的请看看,关于IDAL
- asp.net中如何截取前面20个字?(DataBinder.Eval(Container.DataItem, "title"))
- 求一个HTML在线编辑器。。100分
- 以下代码编译执行时提示没有可用的错误信息!
- 不会写存储过程怎么办?
- 多用户同时引用Application中的一个对象进行读操作是否会互相排斥导致排队?
DataTable dtInfo = new DataTable();
object[] objValues = new object[dr.FieldCount];
while (dr.Read())
{
dr.GetValues(objValues);
dtInfo.LoadDataRow(objValues, true);
}
GridView1.DataSource = dtInfo;
GridView1.DataBind();
{
String strContent;
strContent ="%"+this.txtContent.Text+"%";
string connString = System.Configuration.ConfigurationManager.ConnectionStrings["ResourceWebConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(connString))
{
SqlCommand cmd = new SqlCommand();
cmd.Connection = conn; cmd.CommandText = "select top 10 *from Visit where "+this.ddlList.Text+" like @Content and id not in(select top 10*"+(i-1).Tostring()+" id from visit)"; //i是根据页面的textbox传入的值,表示当前页
cmd.Parameters.AddWithValue("@Content", strContent);
conn.Open(); SqlDataReader dr = cmd.ExecuteReader(); this.GridView1.DataSource = dr;
//绑定
this.GridView1.DataBind(); conn.Close();
}
}
cmd.CommandText = "";
cmd.Connection = con;
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds);
this.GridView1.DataSource = ds.Tables[0];