命令对象调用存储过程出错
代码:
---------------------------------------
SqlConnection nwindConn = new SqlConnection("Data Source=COMPUTER_SONG;Integrated Security=SSPI;" + "Initial Catalog=Northwind");
nwindConn.Open();
//string insertStr = "INSERT INTO cUSTOMERS (CustomerID,CompanyName) Values (@CustomerID,@CompanyName)";
string insertStr = "proInsertCustomers";
SqlCommand insertCMD = new SqlCommand(insertStr, nwindConn);
SqlParameter prm1 = new SqlParameter("@CustomerID", SqlDbType.NChar, 5);
prm1.Direction = ParameterDirection.Input;
SqlParameter prm2 = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 40);
prm2.Direction = ParameterDirection.Input;
insertCMD.Parameters.Add(prm1);
insertCMD.Parameters.Add(prm2);
prm1.Value = TextBox1.Text;
prm2.Value = TextBox2.Text;
Int32 recordsAffected = insertCMD.ExecuteNonQuery();
Response.Write(recordsAffected.ToString() + "条记录插入");
-----------------------------------------
存储过程
CREATE proc proInsertCustomers
@CustomerID nchar(5),@CompanyName nvarchar(40)
as
Insert into Customers (CustomerID,CompanyName)Values(@CustomerID,@CompanyName)
GO
-----------------------------------------
出错:
异常详细信息: System.Data.SqlClient.SqlException: 第 1 行: 'proInsertCustomers' 附近有语法错误。
源错误:
行 32: prm2.Value = TextBox2.Text;
行 33:
行 34: Int32 recordsAffected = insertCMD.ExecuteNonQuery();
行 35: Response.Write(recordsAffected.ToString() + "条记录插入");
行 36: }
源文件: d:\WebSite2\Default4.aspx.cs 行: 34