Shulou(Shulou.com)06/03 Report--

Xiaobian to share with you how to use the storage process to store values in the database, I believe most people still do not know how, so share this article for your reference, I hope you have a lot of harvest after reading this article, let's go to understand it together!

Code in cs file

The code is as follows:

//Three standards for watching videos

//pass parameters from page

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);

//Number of homework reviews (articles)

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 );

//instantiate object (EDBoperation for learning library)

edb=new EDBoperation();

//use stored procedures

string procName="insert_Update_PROJECT_STANDARD";

//insert data

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 ("field name in database stored procedure," defined field name)

Code in aspx

The code is as follows:

stored procedure

The copy code is as follows:

//Create a stored procedure

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 data corresponding to image storage

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 )

The above is "how to use stored procedures to store values in the database" all the content of this article, thank you for reading! I believe that everyone has a certain understanding, hope to share the content to help everyone, if you still want to learn more knowledge, welcome to pay attention to the industry information channel!

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.