命名空间的就不写了
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);
就会报语句错误 改怎样写啊
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);
就会报语句错误 改怎样写啊
解决方案 »
- C# 如何实现图像编辑工具条??
- 本人新手求教多线程问题!这是一段代码,当文件传输完毕怎么用线程打开第二个窗口!
- .net程序的一些问题~~~~~~~`
- C#数据库数据插入问题
- INSERT 语句与 COLUMN FOREIGN KEY 约束 'FK_NewsInfo_NewsTypeInfo' 冲突。
- 怎样将作为条件的起始时间和截止时间显示在报表上??
- 自动对应粘贴用户/密码
- c# 字符串中如何删除掉“特殊字符”
- FTP服务器移动文件目录,可以上传,创建目录,删除,重命名,就是做不到移动,说是权限问题
- 读写文件!编码问题!
- 如何对url进行部分重写?
- 接口无法实现的小问题。。。。分数不多,请大侠帮忙!!
"delete from students where Stu_Number='{0}' or (Stu_Name='{1}' and Stu_age='{2}')",Stu_Number,Stu_Name,Stu_age