ExecuteNonQuery 带参数sql语句

        /// <summary>
        /// 执行带参数的sql语句。
        /// </summary>
        /// <param name="i"></param>
        public static void Parameter(int i)
        {

            string conString = "data source=.;Database=Codematic;user id=sa;password=123";
            SqlConnection myConnection = new SqlConnection(conString);
            string strsql = "insert into P_Category (CategoryId,Name,Descn) values (@CategoryI1d,@Name,@Descn)";
            SqlParameter[] par ={
                                 new SqlParameter("@CategoryI1d",SqlDbType.VarChar,20),
                                 new SqlParameter("@Name",SqlDbType.VarChar,80),
                                 new SqlParameter("@Descn",SqlDbType.VarChar,255)
                             };
            par[0].Value = i.ToString();
            par[1].Value = "2";
            par[2].Value = "2";

            myConnection.Open();
            SqlCommand cmd = new SqlCommand();
            cmd.Connection = myConnection;
            cmd.CommandText = strsql;
            cmd.CommandType = CommandType.Text;

            cmd.Parameters.Clear();
            cmd.Parameters.AddRange(par);

            cmd.ExecuteNonQuery();
            myConnection.Close();
        }