代码:
---------------------------------------
            
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