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;">
