110,536
社区成员
发帖
与我相关
我的任务
分享
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "GetKey";
cmd.Parameters.Add(new SqlParameter("@KeyName", "CustomerID"));
cmd.Parameters.Add(new SqlParameter("@KeyValue", SqlDbType.Int));
cmd.Parameters[1].Direction = ParameterDirection.ReturnValue;
cmd.ExecuteNonQuery();
cmd.Parameters[1].Direction = ParameterDirection.Output
SqlParameter[] sqlParameters = {
new SqlParameter("@KeyName",SqlDbType.NVarChar,10),
new SqlParameter("@KeyValue",SqlDbType.Int),
};
sqlParameters[0].Value = KeyName的值;
sqlParameters[1].Value = KeyValue的值;
using (SqlConnection conn = new SqlConnection())
{
conn.ConnectionString = SqlOperate.ConnectionStringLocalTransaction;
SqlOperate.ExecuteNonQuery(conn, CommandType.StoredProcedure, "GetKey", sqlParameters);
}