程序師世界是廣大編程愛好者互助、分享、學習的平台,程序師世界有你更精彩!
首頁
編程語言
C語言|JAVA編程
Python編程
網頁編程
ASP編程|PHP編程
JSP編程
數據庫知識
MYSQL數據庫|SqlServer數據庫
Oracle數據庫|DB2數據庫
 程式師世界 >> 編程語言 >> .NET網頁編程 >> ASP.NET >> 關於ASP.NET >> 用存儲過程向數據庫存值的具體實現

用存儲過程向數據庫存值的具體實現

編輯:關於ASP.NET

     本文為大家介紹下使用存儲過程向數據庫存值的具體實現過程,感興趣的朋友不要錯過

    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 )   
    1. 上一頁:
    2. 下一頁:
    Copyright © 程式師世界 All Rights Reserved