这样试试 string strsql = "select PostBack_Id+"+i+" from Bbs_PostBack where PostBack_PostId=" + postid;
i变成字符了当然是没值了。 public void GetPostBackContent(string postid) { for (int i = 0; i < 10; i++) { string strsql = "select PostBack_Id"+i.tostring()+" from Bbs_PostBack where PostBack_PostId=" + postid;//PostBack_Id+i这个代码中的i并没有值是怎么回事? string ss = ExecuteScalars(strsql);//操作方法 if (ss != "") { strsql = "select PostBack_Content from Bbs_PostBack where PostBack_Id=" + ss;// string bb = ExecuteScalars(strsql);//执行方法 if (bb != "") { //执行代码 } }
这方法是要干什么的?奇形怪状的在0到10的循环中PostBack_Id+i,就是select PostBack_Id0, PostBack_Id1,PostBack_Id2...PostBack_Id9,LZ你确定表Bbs_PostBack 里面有这10个字段??假如有的话,这个要消耗多少性能直接select PostBack_Id0, PostBack_Id1,PostBack_Id2...PostBack_Id9 from Bbs_PostBack where PostBack_PostId=..然后在结果中判断执行代码不是更好下面那查询也一样很奇怪
for (int i = 0; i < 10; i++) { string strsql = "select PostBack_Id"+i+" from Bbs_PostBack where PostBack_PostId=" + postid; string ss = ExecuteScalars(strsql);//操作方法
还不如直接查询 select * from Bbs_PostBack where PostBack_PostId=" + postid sqldatareader遍历取PostBack_Id"+i+" 值
string strsql = "select PostBack_Id+"+i+" from Bbs_PostBack where PostBack_PostId=" + postid;
public void GetPostBackContent(string postid)
{ for (int i = 0; i < 10; i++)
{
string strsql = "select PostBack_Id"+i.tostring()+" from Bbs_PostBack where PostBack_PostId=" + postid;//PostBack_Id+i这个代码中的i并没有值是怎么回事? string ss = ExecuteScalars(strsql);//操作方法 if (ss != "") { strsql = "select PostBack_Content from Bbs_PostBack where PostBack_Id=" + ss;// string bb = ExecuteScalars(strsql);//执行方法 if (bb != "") { //执行代码 } }
{
string strsql = "select PostBack_Id"+i+" from Bbs_PostBack where PostBack_PostId=" + postid;
string ss = ExecuteScalars(strsql);//操作方法
select * from Bbs_PostBack where PostBack_PostId=" + postid
sqldatareader遍历取PostBack_Id"+i+" 值