SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = " + TextBox1.Text"and Name="+TextBox2.Text,sqlconn);我想验证ID和NAME都是表里的数据,用的是嵌套但语句报错,不知道怎么改,大家帮忙看看
解决方案 »
- 懂flex工程文档结构的高人来帮忙喽分独给回答最好的人
- 各位朋友,小弟现在碰到了一些怪问题,请大家一起进来参考下
- 关于用户登陆问题.急........
- 请问如何把null值付给整形或数字型,日期型变量?
- 问一个很基本的问题
- asp.net中在.cs文件里弹出确定框后点击确定后再转向另一个页面,如何实现,在线等
- DataGrid中用dgdChild.Items(i).Cells(11).Text方法去不到值?!奇怪了!!解决了马上给分!
- DataGrid1.Columns.RemoveAt(3)为何不灵了?
- access中请问在insert语句中如何向日期类型字段写入?感谢了!!!
- 能否实现让页面完全载入后再执行其他操作,如检索数据等等,(写在pageload里,c#)?多谢
- 要使鼠标移动到某个列后,显示相关信息?
- 关于datagrid
SqlCommand sqlcmd = new SqlCommand(sqlString,sqlconn);
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = ' " + TextBox1.Text + " ' and Name= ' "+TextBox2.Text +"'" ,sqlconn);
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = " + TextBox1.Text"and Name='"+TextBox2.Text+"'",sqlconn);
如果不是数字
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = '" + TextBox1.Text"' and Name='"+TextBox2.Text+"'",sqlconn);
但是建议你用parameter
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = @ID and Name=@name",sqlconn);
sqlcmd.Parameters.Add("@id",txtid.Text)
...
2."and Name"的and前面加空格
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = " + TextBox1.Text" and Name='"+TextBox2.Text+"'",sqlconn);
SqlCommand sqlcmd = new SqlCommand("select * from Employee where ID = " + TextBox1.Text+" and Name='"+TextBox2.Text+"'",sqlconn);