C#小问题来看一下

[jasondct]

命名空间的就不写了


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);
就会报语句错误 改怎样写啊

[bitpolar]

string sql=string.Format ( "delete from students where Stu_Number = '{0}' or Stu_Number = '{1}' ",Stu_Number,Stu_Number);

//去掉第二个 where

[bitpolar]

sql语句基本功的问题

[liangxf0022]

from students where Stu_Number = '{0}' or Stu_Number = '{1}'

不要加逗号

[MegaChou]

liangxf0022(小新) 的正解

[jcyluck]

string sql=string.Format ( "delete from students where Stu_Number = '{0}' and Stu_Number = '{1}' ",Stu_Number,Stu_Number);

[sky_zm_sky]

"delete from students where Stu_Number='"+Stu_Number+"' or (Stu_Number='"+Stu_Number+"' and Stu_age='"+Stu_age+"')"

[jcyluck]

怎么两个条件都是 Stu_Number ，其中应该有一个是Stu_Name 吧

[sky_zm_sky]

"delete from students where Stu_Number='{0}' or (Stu_Number='{1}' and Stu_age='{2}')",Stu_Number,Stu_Number,Stu_age

[sky_zm_sky]

上面看错了
"delete from students where Stu_Number='{0}' or (Stu_Name='{1}' and Stu_age='{2}')",Stu_Number,Stu_Name,Stu_age

[jasondct]

我把错误代码粘过来的多了where 我的出错程序里没有那个where 呵呵这段简的代码就不拿里研究了 呵呵 谢谢各位!