用存储过程向数据库存值的具体实现

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 ）