 |
| |
ช่วยแก้ให้หน่อยนะค่ะ Failed to convert parameter value from a String to a Int32. |
| |
 |
|
|
 |
 |
|
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=resterant;Integrated Security=True");
SqlCommand com = new SqlCommand("INSERT INTO [order](tableNo,order,price) VALUES (@tableNo,@order,@price)", con);
SqlParameter param = new SqlParameter();
param = new SqlParameter();
param.ParameterName = "@tableNo";
param.SqlDbType = SqlDbType.NChar;
param.Value = label2.Text;
com.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@order";
param.SqlDbType = SqlDbType.NVarChar;
param.Value = label3.Text;
com.Parameters.Add(param);
param = new SqlParameter();
param.ParameterName = "@price";
param.SqlDbType = SqlDbType.Int;
param.Value = label5.Text;
com.Parameters.Add(param);
con.Open();
com.ExecuteNonQuery();
แก้เป็น
Code (C#)
com.Parameters.Add("@tableNo", SqlDbType.NVarChar).Value = label2.Text;
com.Parameters.Add("@order", SqlDbType.NVarChar).Value = label3.Text;
com.Parameters.Add("@price", SqlDbType.Int).Value = int.Parse(label5.Text); //<-- convert parameter value from a String to a Int32.
|
 |
 |
 |
 |
| Date :
2010-01-27 08:44:01 |
By :
tungman |
|
 |
 |
 |
 |
|
|
 |
 |
|
 |
 |
| |
|
|
|
| |
|
if(label5.Text != "")
{
param.Value = (int)label5.Text;
}
ต้องมั่นใจว่า label5.Text มีค่าจริงๆ นะ แล้ว สามารถ convert เป็น int ได้ด้วย
|
| |
|
|
| |
| Date :
2010-01-27 11:04:34 |
By :
numenoy |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;Initial Catalog=resterant;Integrated Security=True");
SqlCommand com = new SqlCommand("INSERT INTO [order](tableNo,order,price) VALUES (@tableNo,@order,@price)", con);
com.Parameters.Add("@tableNo", SqlDbType.NVarChar).Value = label2.Text;
com.Parameters.Add("@order", SqlDbType.NVarChar).Value = label3.Text;
com.Parameters.Add("@price", SqlDbType.Int).Value = int.Parse(label5.Text); //<-- convert parameter value from a String to a Int32.
con.Open();
com.ExecuteNonQuery();
ที่ขีดเส้นใต้มันerror อีกแล้วค่ะ
ERROR >>>> Incorrect syntax near the keyword 'order'.
|
| |
|
|
| |
| Date :
2010-01-27 12:43:58 |
By :
N-smile |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
Code (C#)
SqlCommand com = new SqlCommand("INSERT INTO [order] ([tableNo], [order], [price]) VALUES (@tableNo, @order, @price)", con);
คำว่า order เป็น keyword ไม่ควรใช้ตั้งชื่อ table หรือ field
|
| |
|
|
| |
| Date :
2010-01-27 12:53:58 |
By :
tungman |
|
|
| |
|
|
|
|
|
| |
|
|
|
| |
|
|
|
| |
|
เย้ๆ แก้ได้แล้วค่ะ ขอบคุณนะค่ะ ส่วนคำแนะนำจะเก็บไว้ปรับปรุงค่ะ
|
| |
|
|
| |
| Date :
2010-01-27 13:34:08 |
By :
N-smile |
|
|
| |
|
|
|
|
|
| |
|
|
|
|
|
