int i=0;
if(str_name!="" || str_nrjj!="" || str_memo!="" || str_state!="" || str_jystate!="")
{
str_tj="where";
if(str_name!="")
{
i=1;
str_tj=str_tj+"name like '%"+str_name+"%'";
}
if(str_press!="")
{
if(i==1)
str_tj=str_tj+"and press like '%"+str_press+"%'";
else
{
str_tj=str_tj+"press like '%"+str_press+"%'";
i=1;
}
}
if(str_nrjj!="")
{
if(i==1)
str_tj=str_tj+"and nrjj like '%"+str_nrjj+"%'";
else
{ str_tj=str_tj+"nrjj like '%"+str_nrjj+"%'";
i=1;
}
}
if(str_memo!="")
{
if(i==1)
str_tj=str_tj+"and memo like '%"+str_memo+"%'";
else
{ str_tj=str_tj+"memo like '%"+str_memo+"%'";
i=1;
}
}
if(str_state!="")
{
if(i==1)
str_tj=str_tj+"and state= '%"+str_state+"%'";
else
{
str_tj=str_tj+ "state= '%"+str_state+"%'";
i=1;
}
}
if(str_jystate!="")
{
if(i==1)
str_tj=str_tj + "and jystate= '%"+str_jystate+"%'";
else
{
str_tj=str_tj + "jystate= '%"+str_jystate+"%'";
i=1;
}
}
}
else
str_tj="";
string cnnstr="Persist Security Info=false;userid=sa;password=;database=uds;";
SqlConnection cnn;
cnn = new SqlConnection(cnnstr);
cnn.Open();
SqlCommand cmd = new SqlCommand("Select count(*) as nums from UDS_BOOK_INFO" +str_tj,cnn);
好像是查询字符串出错,但是基础知识太差,不知怎么改正。请求帮助,谢谢了先~
if(str_name!="" || str_nrjj!="" || str_memo!="" || str_state!="" || str_jystate!="")
{
str_tj="where";
if(str_name!="")
{
i=1;
str_tj=str_tj+"name like '%"+str_name+"%'";
}
if(str_press!="")
{
if(i==1)
str_tj=str_tj+"and press like '%"+str_press+"%'";
else
{
str_tj=str_tj+"press like '%"+str_press+"%'";
i=1;
}
}
if(str_nrjj!="")
{
if(i==1)
str_tj=str_tj+"and nrjj like '%"+str_nrjj+"%'";
else
{ str_tj=str_tj+"nrjj like '%"+str_nrjj+"%'";
i=1;
}
}
if(str_memo!="")
{
if(i==1)
str_tj=str_tj+"and memo like '%"+str_memo+"%'";
else
{ str_tj=str_tj+"memo like '%"+str_memo+"%'";
i=1;
}
}
if(str_state!="")
{
if(i==1)
str_tj=str_tj+"and state= '%"+str_state+"%'";
else
{
str_tj=str_tj+ "state= '%"+str_state+"%'";
i=1;
}
}
if(str_jystate!="")
{
if(i==1)
str_tj=str_tj + "and jystate= '%"+str_jystate+"%'";
else
{
str_tj=str_tj + "jystate= '%"+str_jystate+"%'";
i=1;
}
}
}
else
str_tj="";
string cnnstr="Persist Security Info=false;userid=sa;password=;database=uds;";
SqlConnection cnn;
cnn = new SqlConnection(cnnstr);
cnn.Open();
SqlCommand cmd = new SqlCommand("Select count(*) as nums from UDS_BOOK_INFO" +str_tj,cnn);
好像是查询字符串出错,但是基础知识太差,不知怎么改正。请求帮助,谢谢了先~
其他的地方类似
SqlCommand cmd = new SqlCommand("Select count(*) as nums from UDS_BOOK_INFO" +str_tj,cnn);
这里也要加
SqlCommand cmd = new SqlCommand("Select count(*) as nums from UDS_BOOK_INFO " +str_tj,cnn);另外感觉楼主这样写else语句拼接之后会有问题,给其中几个变量赋值,另外几个留空,设断点看下最后的str_tj是什么样的,然后从这上面入手,修改代码
希望大家支持一下!