SqlParameter参数类型的问题(c#.net)

来源：百度知道 编辑：UC知道 时间：2024/06/22 05:34:24
new SqlParameter(PARA_COURSE_ID,SqlDbType.UniqueIdentifier,16),
new SqlParameter(PARA_COURSE_NAME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_OBJECT,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_FORM,SqlDbType.VarChar,520),
new SqlParameter(PARA_RECOMMEND_AGENCY,SqlDbType.VarChar,520),
new SqlParameter(PARA_TRAIN_BUDGET,SqlDbType.VarChar,50),
new SqlParameter(PARA_ARRANGE_TIME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAIN_OBJECTIVE,SqlDbType.VarChar,50),
new SqlParameter(PARA_FUNDING_REQUIREMENT,SqlDbType.VarChar,50),

对应数据库为
courseId uniqueidentifier Unchecked
courseName varchar(50) Checked
trainedObject varchar(50) Checked
trainedForm varchar(520) Checked
recommendAgency varchar(520) Checked
trainBudget varchar(50) Checked

new SqlParameter(@courseid,SqlDbType.UniqueIdentifier,16),
///以下照上.
new SqlParameter(PARA_COURSE_NAME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_OBJECT,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAINED_FORM,SqlDbType.VarChar,520),
new SqlParameter(PARA_RECOMMEND_AGENCY,SqlDbType.VarChar,520),
new SqlParameter(PARA_TRAIN_BUDGET,SqlDbType.VarChar,50),
new SqlParameter(PARA_ARRANGE_TIME,SqlDbType.VarChar,50),
new SqlParameter(PARA_TRAIN_OBJECTIVE,SqlDbType.VarChar,50),
new SqlParameter(PARA_FUNDING_REQUIREMENT,SqlDbType.VarChar,50),

new SqlParameter的第一个参数是字符型的！需要用双引号括起来！你那样写编译都过不去！
new SqlParameter("PARA_COURSE_ID",SqlDbType.UniqueIdentifier,16),
new SqlParameter("PARA_COURSE_NAME",SqlDbType.VarChar,50),
new SqlParameter("PARA_TRAINED_OBJECT",SqlDbType.VarChar,50),
new SqlParameter("PARA_TRAINED_FORM",SqlDbType.VarChar,520),
new SqlParameter("