关于C#中,数据库数据的删除操作
using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Text;
using System.Windows.Forms;
using System.Data.SqlClient;
namespace WindowsApplication1
{
public partial class Form4 : Form
{
public Form4()
{
InitializeComponent();
}
public string table = "";
private void btnDel_Click(object sender, EventArgs e)
{
table = "TB_EMP";
string empId = textID.Text;
string empName = textName.Text;
string empSal = textSal.Text;
string empSex = textSex.Text;
string empBirthday = textBirthday.Text;
string str = "Server= LYP19900208;DataBase=test01;Uid=sa;Pwd=6020";
SqlConnection conn = null;
conn = new SqlConnection(str);
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.Text;
cmd.Connection = conn;
cmd.CommandText = "delete '" + table + "' where (empID = '" + empId + "') ";
conn.Open();
SqlDataAdapter sda = new SqlDataAdapter();
sda.SelectCommand = cmd;
DataSet ds = new DataSet();
sda.Fill(ds,table);
MessageBox.Show("删除成功!");
}
}
}
这是我的代码,运行的时候总是提示我sql语句出错,求解
------解决方案--------------------
"delete " + table + " where (empID = '" + empId + "') ";
去掉table的引号,如果empID 字段是数值型,就不要加引号
------解决方案--------------------改成这样
cmd.CommandText = "delete " + table + " where empID = '" + empId + "' ";
------解决方案--------------------应该是:
"delete table where empID='"+empId+"'";