用存儲過程向數(shù)據(jù)庫存值的具體實(shí)現(xiàn)

更新時(shí)間：2014年01月14日 15:58:06 作者：

本文為大家介紹下使用存儲過程向數(shù)據(jù)庫存值的具體實(shí)現(xiàn)過程，感興趣的朋友不要錯(cuò)過

cs文件中的代碼

 
//收看視頻三個(gè)標(biāo)準(zhǔn) 
//從頁面?zhèn)鲄?shù)過來 
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); 

//作業(yè)批閱數(shù)（篇） 
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 ); 

//實(shí)例化對象（learning庫對應(yīng)的是EDBoperation） 
edb=new EDBoperation(); 
//使用存儲過程 
string procName="insert_Update_PROJECT_STANDARD"; 
//插入數(shù)據(jù) 
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 ("數(shù)據(jù)庫存儲過程中的字段名",定義的字段名)
aspx中的代碼

復(fù)制代碼代碼如下:

 
<tr> 
<td style="width: 101px; text-align: center;"> 
<asp:Label ID="Label2" runat="server" Text="收看視頻（分鐘）:" Font-Size="9pt" Width="132px"></asp:Label> 
</td> 
<td style="text-align: left;"colspan="2"> 
<table> 
<tr style="height:25px;"> 
<td style="width:180px;"><asp:TextBox id="TextBox1" runat="server"></asp:TextBox></td> 
<td style="width:180px;"><asp:TextBox id="TextBox4" runat="server"></asp:TextBox></td> 
</tr> 

<tr> 
<td class="auto-style3"><asp:TextBox id="TextBox2" runat="server"></asp:TextBox></td> 
<td class="auto-style3"><asp:TextBox id="TextBox5" runat="server"></asp:TextBox></td> 
</tr> 

<tr style="height:25px;"> 
<td style="width:180px;"><asp:TextBox id="TextBox3" runat="server" OnTextChanged="TextBox3_TextChanged"></asp:TextBox></td> 
<td style="width:180px;"><asp:TextBox id="TextBox6" runat="server"></asp:TextBox></td> 
</tr> 

</table> 

</td> 
</tr> 
<tr> 
<td style="width: 101px; text-align: center;"> 
<asp:Label ID="Labele" runat="server" Text="作業(yè)批閱數(shù)（篇）:" Font-Size="9pt" Width="132px"></asp:Label> 
</td> 
<td style="text-align: left;"colspan="2"> 
<table> 
<tr style="height:25px;"> 
<td style="width:180px;"><asp:TextBox id="TextBox7" runat="server"></asp:TextBox></td> 
<td style="width:180px;"><asp:TextBox id="TextBox10" runat="server"></asp:TextBox></td> 
</tr> 

<tr style="height:25px;"> 
<td style="width:180px;"><asp:TextBox id="TextBox8" runat="server"></asp:TextBox></td> 
<td style="width:180px;"><asp:TextBox id="TextBox11" runat="server"></asp:TextBox></td> 
</tr> 

<tr style="height:25px;"> 
<td style="width:180px;"><asp:TextBox id="TextBox9" runat="server"></asp:TextBox></td> 
<td style="width:180px;"><asp:TextBox id="TextBox12" runat="server"></asp:TextBox></td> 
</tr> 

存儲過程

復(fù)制代碼代碼如下:

 
//創(chuàng)建存儲過程 

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 

//像存儲過程中對應(yīng)著插入數(shù)據(jù) 

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 ) 