用存儲(chǔ)過程向數(shù)據(jù)庫存值的具體實(shí)現(xiàn)
更新時(shí)間:2014年01月14日 15:58:06 作者:
本文為大家介紹下使用存儲(chǔ)過程向數(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í)例化對(duì)象(learning庫對(duì)應(yīng)的是EDBoperation)
edb=new EDBoperation();
//使用存儲(chǔ)過程
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ù)庫存儲(chǔ)過程中的字段名",定義的字段名)
aspx中的代碼
<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>
存儲(chǔ)過程
//創(chuàng)建存儲(chǔ)過程
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
//像存儲(chǔ)過程中對(duì)應(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 )
復(fù)制代碼 代碼如下:
//收看視頻三個(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í)例化對(duì)象(learning庫對(duì)應(yīng)的是EDBoperation)
edb=new EDBoperation();
//使用存儲(chǔ)過程
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ù)庫存儲(chǔ)過程中的字段名",定義的字段名)
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>
存儲(chǔ)過程
復(fù)制代碼 代碼如下:
//創(chuàng)建存儲(chǔ)過程
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
//像存儲(chǔ)過程中對(duì)應(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 )
您可能感興趣的文章:
- sqlserver數(shù)據(jù)庫使用存儲(chǔ)過程和dbmail實(shí)現(xiàn)定時(shí)發(fā)送郵件
- MSSQL監(jiān)控?cái)?shù)據(jù)庫的DDL操作(創(chuàng)建,修改,刪除存儲(chǔ)過程,創(chuàng)建,修改,刪除表等)
- sqlSQL數(shù)據(jù)庫怎么批量為存儲(chǔ)過程/函數(shù)授權(quán)呢?
- mysql 導(dǎo)入導(dǎo)出數(shù)據(jù)庫以及函數(shù)、存儲(chǔ)過程的介紹
- Oracle中 關(guān)于數(shù)據(jù)庫存儲(chǔ)過程和存儲(chǔ)函數(shù)的使用
- sql處理數(shù)據(jù)庫鎖的存儲(chǔ)過程分享
- SQL Server中通過擴(kuò)展存儲(chǔ)過程實(shí)現(xiàn)數(shù)據(jù)庫的遠(yuǎn)程備份與恢復(fù)
- MSSQL MySQL 數(shù)據(jù)庫分頁(存儲(chǔ)過程)
- 從創(chuàng)建數(shù)據(jù)庫到存儲(chǔ)過程與用戶自定義函數(shù)的小感
- SQLserver 數(shù)據(jù)庫危險(xiǎn)存儲(chǔ)過程刪除與恢復(fù)方法
- sqlserver關(guān)于分頁存儲(chǔ)過程的優(yōu)化【讓數(shù)據(jù)庫按我們的意思執(zhí)行查詢計(jì)劃】
- mysql 查詢數(shù)據(jù)庫中的存儲(chǔ)過程與函數(shù)的語句
- 分頁存儲(chǔ)過程(用存儲(chǔ)過程實(shí)現(xiàn)數(shù)據(jù)庫的分頁代碼)
- 為數(shù)據(jù)庫生成某個(gè)字段充填隨機(jī)數(shù)的存儲(chǔ)過程
- sql 判斷數(shù)據(jù)庫,表,存儲(chǔ)過程等是否存在的代碼
- Oracle存儲(chǔ)過程之?dāng)?shù)據(jù)庫中獲取數(shù)據(jù)實(shí)例
- sqlserver 復(fù)制表 復(fù)制數(shù)據(jù)庫存儲(chǔ)過程的方法
- 積分獲取和消費(fèi)的存儲(chǔ)過程學(xué)習(xí)示例
相關(guān)文章
VB.NET驗(yàn)證郵件地址的合法性實(shí)現(xiàn)代碼
現(xiàn)在,對(duì)于用戶在Web頁面上或電話中給出的Email地址,我們越來越不敢肯定它是否真的有效。在今天這個(gè)垃圾郵件泛濫成災(zāi)的年代,人們完全有理由舍不得輕易透露Email地址。2011-04-04ASP.net實(shí)現(xiàn)頁面跳轉(zhuǎn)的方法
在ASP.NET進(jìn)行頁面開發(fā)時(shí)候經(jīng)常遇到需要進(jìn)行頁面跳轉(zhuǎn)的操作。這個(gè)其實(shí)并不難,關(guān)鍵是知不知道的問題。下面給出操作方法。2013-06-06ASP.NET?Core?MVC中使用Tag?Helper組件
這篇文章介紹了ASP.NET?Core?MVC中使用Tag?Helper組件的方法,對(duì)大家的學(xué)習(xí)或者工作具有一定的參考學(xué)習(xí)價(jià)值,需要的朋友們下面隨著小編來一起學(xué)習(xí)學(xué)習(xí)吧2022-02-02asp.net中Response.Redirect與Server.Transfer的區(qū)別分析
一般來說如果需要在兩個(gè)頁面間共享數(shù)據(jù),而且數(shù)據(jù)量比較大的時(shí)候,用transfer會(huì)比較合適,在第二個(gè)頁面中可以直接使用前一頁面的數(shù)據(jù)。2010-10-10ASP.NET UserControl 通信的具體實(shí)現(xiàn)
下面我就用ASP.NET的UserControl模擬SharePoint UserControl通信,兩者的本質(zhì),思想和實(shí)現(xiàn)方式都不變。2013-06-06Asp.net 中mvc 實(shí)現(xiàn)超時(shí)彈窗后跳轉(zhuǎn)功能
這篇文章主要介紹了Asp.net 中mvc 實(shí)現(xiàn)超時(shí)彈窗后跳轉(zhuǎn)功能,非常不錯(cuò),具有參考借鑒價(jià)值,需要的朋友可以參考下2017-02-02ASP.NET使用WebService實(shí)現(xiàn)天氣預(yù)報(bào)功能
這篇文章主要為大家詳細(xì)介紹了ASP.NET使用WebService實(shí)現(xiàn)天氣預(yù)報(bào)功能的相關(guān)資料,感興趣的小伙伴們可以參考一下2016-08-08