用預存程序向資料庫存值的具體實現

 本文為大家介紹下使用預存程序向資料庫存值的具體實現過程，感興趣的朋友不要錯過

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 )