mysql存储过程实现将dat文件入库,用存储过程向数据库存值的具体实现

cs文件中的代码

//收看视频三个标准

//从页面传参数过来

int V1_BiaoZhou = Convert.ToInt32(TextBox1.Text);

int V1_FeiZhi= Convert.ToInt32(TextBox4.Text);

int V2_BiaoZhou = Convert.ToInt32(TextBox2.Text);

int V2_FeiZhi= Convert.ToInt32(TextBox5.Text);

int V3_BiaoZhou = Convert.ToInt32(TextBox3.Text);

int V3_FeiZhi= Convert.ToInt32(TextBox6.Text);

//作业批阅数(篇)

int Z1_BiaoZhun=Convert .ToInt32 (TextBox7 .Text );

int Z1_FeiZhi=Convert .ToInt32 (TextBox10 .Text );

int Z2_BiaoZhun=Convert .ToInt32 (TextBox8 .Text );

int Z2_FeiZhi=Convert .ToInt32 (TextBox11 .Text );

int Z3_BiaoZhun=Convert .ToInt32 (TextBox9 .Text );

int Z3_FeiZhi=Convert .ToInt32 (TextBox12 .Text );

//实例化对象(learning库对应的是EDBoperation)

edb=new EDBoperation();

//使用存储过程

string procName="insert_Update_PROJECT_STANDARD";

//插入数据

SqlParameter[] spp=new SqlParameter[]{

new SqlParameter("@PROJECT_ID",projectID),

new SqlParameter("@V1_BIAOZHOU",V1_BiaoZhou),

new SqlParameter ("@V1_FENGZHI",V1_FeiZhi),

new SqlParameter ("@V2_BIAOZHOU",V2_BiaoZhou),

new SqlParameter ("@V2_FENGZHI",V2_FeiZhi),

new SqlParameter ("@V3_BIAOZHOU",V3_BiaoZhou),

new SqlParameter ("@V3_FENGZHI",V3_FeiZhi),

new SqlParameter ("@Z1_BIAOZHUN",Z1_BiaoZhun),

new SqlParameter ("@Z1_FENZHI",Z1_FeiZhi),

new SqlParameter ("@Z2_BIAOZHUN",Z2_BiaoZhun),

new SqlParameter ("@Z2_FENZHI",Z2_FeiZhi),

new SqlParameter ("@Z3_BIAOZHUN",Z3_BiaoZhun),

new SqlParameter ("@Z3_FENZHI",Z3_FeiZhi)

};

new SqlParameter ("数据库存储过程中的字段名",定义的字段名)

aspx中的代码

存储过程

//创建存储过程

create PROC insert_Update_PROJECT_STANDARD

@PROJECT_ID INT,

@V1_BIAOZHOU INT,

@V1_FENGZHI INT,

@V2_BIAOZHOU INT,

@V2_FENGZHI INT,

@V3_BIAOZHOU INT,

@V3_FENGZHI INT,

@Z1_BIAOZHUN INT,

@Z1_FENZHI INT,

@Z2_BIAOZHUN INT,

@Z2_FENZHI INT,

@Z3_BIAOZHUN INT,

@Z3_FENZHI INT

AS

//像存储过程中对应着插入数据

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V1_BIAOZHOU,@V1_FENGZHI)

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V2_BIAOZHOU,@V2_FENGZHI)

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid,KHBZ,FZ) values(@PROJECT_ID,@V3_BIAOZHOU,@V3_FENGZHI)

INSERT INTO T_LEARNING_PROJECT_STANDARD (Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z1_BIAOZHUN ,@Z1_FENZHI )

INSERT INTO T_LEARNING_PROJECT_STANDARD(Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z2_BIAOZHUN ,@Z2_FENZHI )

INSERT INTO T_LEARNING_PROJECT_STANDARD (Sid ,KHBZ ,FZ )VALUES(@PROJECT_ID ,@Z3_BIAOZHUN ,@Z3_FENZHI )