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中的代碼
復制代碼 代碼如下:
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="作業批閱數（篇）:" 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>
存儲過程
復制代碼 代碼如下:
//創建存儲過程
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 )
您可能感興趣的文章:- sqlserver數據庫使用存儲過程和dbmail實現定時發送郵件
- MSSQL監控數據庫的DDL操作(創建，修改，刪除存儲過程，創建，修改，刪除表等)
- sqlSQL數據庫怎么批量為存儲過程/函數授權呢？
- mysql 導入導出數據庫以及函數、存儲過程的介紹
- Oracle中 關于數據庫存儲過程和存儲函數的使用
- sql處理數據庫鎖的存儲過程分享
- SQL Server中通過擴展存儲過程實現數據庫的遠程備份與恢復
- MSSQL MySQL 數據庫分頁(存儲過程)
- 從創建數據庫到存儲過程與用戶自定義函數的小感
- SQLserver 數據庫危險存儲過程刪除與恢復方法
- sqlserver關于分頁存儲過程的優化【讓數據庫按我們的意思執行查詢計劃】
- mysql 查詢數據庫中的存儲過程與函數的語句
- 分頁存儲過程(用存儲過程實現數據庫的分頁代碼)
- 為數據庫生成某個字段充填隨機數的存儲過程
- sql 判斷數據庫,表，存儲過程等是否存在的代碼
- Oracle存儲過程之數據庫中獲取數據實例
- sqlserver 復制表 復制數據庫存儲過程的方法
- 積分獲取和消費的存儲過程學習示例
