朋友来看看，很简单。。。

[evonne0102]

SqlConnection conn = new SqlConnection("Data Source=(local);Integrated Security=SSPI;Initial Catalog=Northwind");
conn.Open();
string str = "INSERT into Customers(CustomerID,CompanyName) Values(@CustomerID,@CompanyName)";
SqlCommand cmm = new SqlCommand(str, conn);
SqlParameter prm = new SqlParameter("@CoustomerID", SqlDbType.NChar, 5);
prm.Direction = ParameterDirection.Input;
SqlParameter prm1 = new SqlParameter("@CompanyName", SqlDbType.NVarChar, 50);
prm1.Direction = ParameterDirection.Input;
cmm.Parameters.Add(prm);
cmm.Parameters.Add(prm1);
Console.WriteLine("Input your customerID value:");
prm.Value = Console.ReadLine();
Console.WriteLine("Inpur your companyName value:");
prm1.Value = Console.ReadLine();
Int32 recordAffected = cmm.ExecuteNonQuery();
Console.WriteLine("{0}record insert", recordAffected);
错误信息 未声明的变量@CustomerID！！帮忙改一下

[我被可乐淹死了]

SqlParameter prm = new SqlParameter("@CoustomerID", SqlDbType.NChar, 5);
-----------------------------------------------------------------------------
SqlParameter prm = new SqlParameter("@CustomerID", SqlDbType.NChar, 5);

[xingyaohua]

SqlParameter prm = new SqlParameter("@CoustomerID", SqlDbType.NChar, 5);
改成 SqlParameter prm = new SqlParameter("@CustomerID", SqlDbType.NChar, 5);

[Janyue]

lz英语过级了啊！
呵呵.........

[evonne0102]

谢谢 看来自己太粗心了！