C#小问题来看一下

jasondct 2007-01-23 10:09:15
命名空间的就不写了


string Stu_Number = textBox1.Text ;
string Stu_Age=textBox2.Text ;
string Stu_Sex = textBox3.Text ;
string Stu_Name = textBox4.Text ;

SqlConnection sqlcnn = new SqlConnection ();
sqlcnn.ConnectionString = " Data Source = jason; Initial Catalog = students ; Integrated Security = SSPI";
Dataset1 myset = new Dataset1 ();
SqlDataAdapter SDA = new SqlDataAdapter ("select * from students",sqlcnn);
string sql=string.Format ( "delete from students where Stu_Number = '{0}' ",Stu_Number);
sqlcnn.Open ();
SqlCommand com = new SqlCommand (sql,sqlcnn);

int i = com.ExecuteNonQuery ();
if (i<1)
MessageBox.Show ("操作失败!");
else
{MessageBox.Show ("删除成功!");}




代码没有问题可以删除一个条件;
主要是
string sql=string.Format ( "delete from students where Stu_Number = '{0}' ",Stu_Number);

要删除 多个条件的 现在可以删除符合 Stu_Number 加上其他条件删除同时符合
Stu_Number 和Stu_Name & Stu_age
string sql=string.Format ( "delete from students where Stu_Number = '{0}', and where Stu_Number = '{1}' ",Stu_Number,Stu_Number);
就会报语句错误 改怎样写啊




...全文
176 10 打赏 收藏 转发到动态 举报
AI 作业
写回复
用AI写文章
10 条回复
切换为时间正序
请发表友善的回复…
发表回复
jasondct 2007-01-24
  • 打赏
  • 举报
回复
我把错误代码粘过来的多了where 我的出错程序里没有那个where 呵呵这段简的代码就不拿里研究了 呵呵 谢谢各位!
sky_zm_sky 2007-01-23
  • 打赏
  • 举报
回复
上面看错了
"delete from students where Stu_Number='{0}' or (Stu_Name='{1}' and Stu_age='{2}')",Stu_Number,Stu_Name,Stu_age
sky_zm_sky 2007-01-23
  • 打赏
  • 举报
回复
"delete from students where Stu_Number='{0}' or (Stu_Number='{1}' and Stu_age='{2}')",Stu_Number,Stu_Number,Stu_age
jcyluck 2007-01-23
  • 打赏
  • 举报
回复
怎么两个条件都是 Stu_Number ,其中应该有一个是Stu_Name 吧
sky_zm_sky 2007-01-23
  • 打赏
  • 举报
回复
"delete from students where Stu_Number='"+Stu_Number+"' or (Stu_Number='"+Stu_Number+"' and Stu_age='"+Stu_age+"')"
jcyluck 2007-01-23
  • 打赏
  • 举报
回复
string sql=string.Format ( "delete from students where Stu_Number = '{0}' and Stu_Number = '{1}' ",Stu_Number,Stu_Number);
MegaChou 2007-01-23
  • 打赏
  • 举报
回复
liangxf0022(小新) 的正解
liangxf0022 2007-01-23
  • 打赏
  • 举报
回复
from students where Stu_Number = '{0}' or Stu_Number = '{1}'

不要加逗号
bitpolar 2007-01-23
  • 打赏
  • 举报
回复
sql语句基本功的问题
bitpolar 2007-01-23
  • 打赏
  • 举报
回复
string sql=string.Format ( "delete from students where Stu_Number = '{0}' or Stu_Number = '{1}' ",Stu_Number,Stu_Number);

//去掉第二个 where

111,097

社区成员

发帖
与我相关
我的任务
社区描述
.NET技术 C#
社区管理员
  • C#
  • AIGC Browser
  • by_封爱
加入社区
  • 近7日
  • 近30日
  • 至今
社区公告

让您成为最强悍的C#开发者

试试用AI创作助手写篇文章吧