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

Question

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！！帮忙改一下

Answer 1

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

Answer 2

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