private void button4_Click(object sender, System.EventArgs e)
{
string id;
string myConnectionString = "";
if(myConnectionString == "")
{
//myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
myConnectionString = "Initial Catalog=Northwind;Data Source=lyj;user=sa;password=sa;";
}
try
{
SqlConnection myConnection = new SqlConnection(myConnectionString);
//string myInsertQuery = "DELECT FROM Customers WHERE;
SqlCommand myCommand = new SqlCommand();
id = ((DataTable)this.dataGrid1.DataSource).Rows[this.dataGrid1.CurrentRowIndex]["CustomerID"].ToString();
myCommand.CommandText = "UPDATE Customers (CustomerID,CompanyName, ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax) Values ('"+textBox11.Text+"','"+textBox1.Text+"', '"+textBox2.Text+"', '"+textBox3.Text+"', '"+textBox4.Text+"', '"+textBox5.Text+"', '"+textBox6.Text+"', '"+textBox7.Text+"', '"+textBox8.Text+"', '"+textBox9.Text+"', '"+textBox10.Text+"') WHERE CustomerID ='"+id+"'";
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close(); //label12.Visible = true;
}
catch(Exception err)
{
MessageBox.Show(err.ToString());
}
}主要是update语句,不用总是update…set…where…吧!我不知道错哪了!总是走到myCommand.ExecuteNonQuery();报错!
{
string id;
string myConnectionString = "";
if(myConnectionString == "")
{
//myConnectionString = "Initial Catalog=Northwind;Data Source=localhost;Integrated Security=SSPI;";
myConnectionString = "Initial Catalog=Northwind;Data Source=lyj;user=sa;password=sa;";
}
try
{
SqlConnection myConnection = new SqlConnection(myConnectionString);
//string myInsertQuery = "DELECT FROM Customers WHERE;
SqlCommand myCommand = new SqlCommand();
id = ((DataTable)this.dataGrid1.DataSource).Rows[this.dataGrid1.CurrentRowIndex]["CustomerID"].ToString();
myCommand.CommandText = "UPDATE Customers (CustomerID,CompanyName, ContactName,ContactTitle,Address,City,Region,PostalCode,Country,Phone,Fax) Values ('"+textBox11.Text+"','"+textBox1.Text+"', '"+textBox2.Text+"', '"+textBox3.Text+"', '"+textBox4.Text+"', '"+textBox5.Text+"', '"+textBox6.Text+"', '"+textBox7.Text+"', '"+textBox8.Text+"', '"+textBox9.Text+"', '"+textBox10.Text+"') WHERE CustomerID ='"+id+"'";
myCommand.Connection = myConnection;
myConnection.Open();
myCommand.ExecuteNonQuery();
myCommand.Connection.Close(); //label12.Visible = true;
}
catch(Exception err)
{
MessageBox.Show(err.ToString());
}
}主要是update语句,不用总是update…set…where…吧!我不知道错哪了!总是走到myCommand.ExecuteNonQuery();报错!
update table set fld1 = val1, fld2 = val2... where fldn = valn
如果Text里有单引号也会出错('附近有语法错误),用参数形式或者textBox.Text.Replace("'", "''")
2、//string myInsertQuery = "DELECT FROM Customers WHERE;
应该是:DELETE FROM Customers WHERE
set columnname1=value1 [, columnname2=value2, ...]
[where conditions]需要加强基本SQL的学习