一点下一页就出错,提示"="附近有错误
string ad=Request.Qurystring["itemid"];
SqlConnection mycon=new SqlConnection(ConfigurationSettings.Appsettings["con"]);
string str1="SELECT itemid,biaoti,neirong,zuozhe,datetime FROM TABLE1 WHERE ck="+ad;
//回复留言查询字串
SqlDataAdapter com=new SqlDataAdapter(str1,mycon);
mycon.open()
DataSet ds=new DataSet();
com.Fill(ds,"guest"); //填充DataSet
PagedDataSource objpage=new PagedDataSource();
objpage.DataSource=ds.Tables["guest"].DefaultView;
objpage.AllowPaging=true; //设置是否分页
objpage.PageSize=3; //每页显示的行数
int curpage;
if(Request.QueryString["page"]!=null) //判断是否有页面跳转请求
curpage=Convert.ToInt32(Request.QueryString["page"]);
else
curpage=1;
objpage.CurrentPageIndex=curpage-1;
if(!objpage.IsFirstPage)
HyperLink1.NavigateUrl=Request.CurrentExecutionFilePath+"?page="+Convert.ToString(curpage-1); //设定页面跳转路径
if(!objpage.IsLastPage)
HyperLink2.NavigateUrl=Request.CurrentExecutionFilePath+"?page="+Convert.ToString(curpage+1);
datalist1.DataSource=objpage; //设定DataList的数据源
datalist1.DataBind(); //绑定数据
mycon.close();
改为
com.Fill(ds,"TABLE1");
如果要填充B表“guest”
修改前边的SQL语句
"SELECT itemid,biaoti,neirong,zuozhe,datetime FROM TABLE1 WHERE ck="+ad;
为
"SELECT * FROM guest WHERE ck="+ad;
[不清楚数据库字段,用select * 代替
]
string ad=Request.Qurystring["itemid"];
所以下面的sql语句出错了。
string str1="SELECT itemid,biaoti,neirong,zuozhe,datetime FROM TABLE1 WHERE ck="+ad; //修改:
HyperLink1.NavigateUrl=Request.CurrentExecutionFilePath+"?page="+
Convert.ToString(curpage-1) + "&itemid=" +
Request.Qurystring["itemid"];
; //设定页面跳转路径