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 复制表 复制数据库存储过程的方法
- 积分获取和消费的存储过程学习示例
