SqlConnection conn = new SqlConnection("server=localhost;database=shoupiao;uid=sa;pwd=");
string strsql = "select zhannode.checi,riqi,zhannode.zhanm,zhannode.price from zhannode,chpksh where zhannode.checi=chpksh.checi and zhannode.zhanm='"TextBox1.Text"' and zhannode.zhanm='"TextBox2.Text"' and chpksh.riqi='"TextBox3.Text"'" ;
SqlCommand comm = new SqlCommand(strsql, conn);
很可能是引号匹配方面的错误,但我不会,帮忙改正啊。
string strsql = "select zhannode.checi,riqi,zhannode.zhanm,zhannode.price from zhannode,chpksh where zhannode.checi=chpksh.checi and zhannode.zhanm='"TextBox1.Text"' and zhannode.zhanm='"TextBox2.Text"' and chpksh.riqi='"TextBox3.Text"'" ;
SqlCommand comm = new SqlCommand(strsql, conn);
很可能是引号匹配方面的错误,但我不会,帮忙改正啊。
少加号!
zhannode.checi,riqi,zhannode.zhanm,zhannode.price
from zhannode,chpksh
where zhannode.checi=chpksh.checi
and zhannode.zhanm="+this.TextBox1.Text+"
and zhannode.zhanm="+this.TextBox2.Text+"
and chpksh.riqi="+this.TextBox3.Text+" ;
你这样试试
string strsql = "select zhannode.checi,riqi,zhannode.zhanm,zhannode.price from zhannode,chpksh where zhannode.checi=chpksh.checi and zhannode.zhanm='"+TextBox1.Text+"' and zhannode.zhanm='"+TextBox2.Text+"' and chpksh.riqi='"+TextBox3.Text+"'" ;
conn.open();
SqlCommand comm = new SqlCommand(strsql, conn);
…………
再看哪里有错误;
"select zhannode.checi,riqi,zhannode.zhanm,zhannode.price from zhannode,chpksh
where zhannode.checi=chpksh.checi and zhannode.zhanm='"
+ TextBox1.Text + "' and zhannode.zhanm='" + TextBox2.Text + "' and chpksh.riqi='" + TextBox3.Text + "'" ;
是不是少了加号.
后面pwd加上一分号.
"
select zhannode.checi,riqi,zhannode.zhanm,zhannode.price
from zhannode,chpksh
where zhannode.checi=chpksh.checi
and zhannode.zhanm='"+TextBox1.Text+"'
and zhannode.zhanm='"+TextBox2.Text+"'
and chpksh.riqi='"+TextBox3.Text+"'
" ;
SqlConnection conn = new SqlConnection("server=localhost;database=shoupiao;uid=sa;pwd=;");
少了加号了。
一楼已经告诉你了。你去试下。还有,你可以用断点调试,查看执行到string strsql……时,这个变量strsql是什么值。然后把这个值放数据库里直接走。就知道你的SQL语句有没有错了。
不是引号的错误,是少了很多+号,就是用来链接字符串的