ExecuteNonQuery 带参数存储过程

        /// <summary>
        /// 执行存储过程
        /// </summary>
        /// <param name="i"></param>
        public static void ParameterSQL(int i)
        {

            string conString = "data source=.;Database=Codematic;user id=sa;password=123";
            SqlConnection myConnection = new SqlConnection(conString);
            string strsql = "UP_P_Category_ADD";
            SqlParameter[] par ={
                                 new SqlParameter("@CategoryId",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.StoredProcedure;
            cmd.Parameters.Clear();
            cmd.Parameters.AddRange(par);

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