我正在為 T-SQL 創建一個簡單的桌面示例，但由于某種原因它引發了例外。例外出現在 int j = cmd.ExecuteNonQuery();
DateTime d = DateTime.Now;
String Id = textBox4.Text;
String date = d.ToString();
String quantity = textBox2.Text;
String connectionstring = @"Data Source = (LocalDB)\MSSQLLocalDB; AttachDbFilename = C:\Users\Junaid Computers\source\repos\WindowsFormsApp3\Softech.mdf;Integrated Security = True";
SqlConnection con = new SqlConnection(connectionstring);
String query = "INSERT INTO order (CustomerId,OrderDate,OrderQuantity) VALUES('" Id "','" date "','" quantity "')";
SqlCommand cmd = new SqlCommand(query, con);
con.Open();
int j = cmd.ExecuteNonQuery();
if (j > 0)
{
MessageBox.Show("Data Inserted:");
}
else if (j == 0)
{
MessageBox.Show("SOrry! No Insertion:");
}
uj5u.com熱心網友回復：
嘗試INSERT INTO \"order\".“訂單”一詞是保留關鍵字。這對我有用。
轉載請註明出處，本文鏈接：https://www.uj5u.com/houduan/521050.html
標籤：C＃tsql例外