mysql executenonquery_未处理 mySqlCommand.ExecuteNonQuery();'=' 附近有语法错误." 急，在线等。望大神解答...

privatevoidinrevise_Load(objectsender,EventArgse){Stringstr="select*fromdbo.[peroninf]";databaseconn=newdatabase();SqlCommandmySqlCommand=newSqlCommand(str,conn.mySqlConn...

private void inrevise_Load(object sender, EventArgs e)

{

String str = "select * from dbo.[peroninf] ";

database conn = new database();

SqlCommand mySqlCommand = new SqlCommand(str, conn.mySqlConnection);

SqlDataReader str1;

str1 = mySqlCommand.ExecuteReader();

while (str1.Read())

comboBox1.Items.Add(str1.GetString(0));

conn.mySqlConnection.Close();

comboBox1.SelectedIndex = 0;

}

private void button1_Click(object sender, EventArgs e)

{

if (comboBox1.Text != "" && textBox1.Text != "" && comboBox2.Text != "选择字段")

{

string str = "update dbo.[peroninf] set " + comboBox2.Text + "='" + textBox1.Text.Trim() + "' where 员工编号='" + comboBox1.Text + "'";

database conn = new database();

SqlCommand mySqlCommand = new SqlCommand(str, conn.mySqlConnection);

mySqlCommand.ExecuteNonQuery();

MessageBox.Show("修改成功");

comboBox1.Text ="";

comboBox2.Text ="";

textBox1.Clear();

}

else

{

MessageBox.Show("不能为空");

};

}

说是：

mySqlCommand.ExecuteNonQuery();

展开