C# SqlParameter参数详细写法及其使用示例

一、第一种写法
SqlParameter[] parms = new SqlParameter[]
{
new SqlParameter("@NodeID",UserRight.GetNodeId()),
new SqlParameter("@A00",person.A00),
new SqlParameter("@ganburenzhi",person.BJXA0109),
new SqlParameter("@guanlichushi",person.GLCS),
new SqlParameter("@ganbushenfen",person.BJXA0110),
new SqlParameter("@flag",person.Flag),
new SqlParameter("@strInfo",person.Info),
new SqlParameter("@RETURN_VALUE",SqlDbType.Int)
};


一、第二种写法
/// <summary>
        /// 可以执行存储过程的ExecuteQuery
        /// </summary>
        /// <param name="sql">sql语句或存储过程名称</param>
        /// <param name="type">查询类型</param>
        /// <param name="parms">查询参数数组</param>
        /// <param name="commonTime">查询超时时间</param>
        /// <returns></returns>
        public static DataTable ExecuteQuery(string sql, CommandType type, SqlParameter[] parms, int commonTime) {
            if(sql + "" == "") {
                return null;
            }
            string ConnectionString = System.Configuration.ConfigurationSettings.AppSettings["DBConStr"];
            DataTable dt = null;
            try {