web应用开发作业

web课本配套资源：

http://www.tup.com.cn/upload/books/kj/079361-01.rar

解压密码：51318

<a href='https://www.itshuquan.com/book/28837'>本书预览</a>    <a href='https://www.itshuquan.com/bookreq?openid=oG09KxNO4BvTVP0lVr8-p2LGUhfA'>申请样书</a>

<a href='https://jiaoxue.wqxuetang.com/v1/b/dr/9787302506799'>在线试读</a>    <a href='https://www.itshuquan.com/order_fb?openid=oG09KxNO4BvTVP0lVr8-p2LGUhfA'>反馈用书</a>

其他资源

web程序

数据库部分

create database Student
go

create table student1(
studentno nchar(32) not null primary key,
stuName nvarchar(32) not null,
stuClass nvarchar(32) not null,
subject nvarchar(32) not null,
stuAge tinyint null,
stuPhone nchar(11) null,
stuGender nvarchar(4) null,
)

go
insert into student1 values('2019001','盐好香','计本一班','Web程序设计',20,'15634210056','男')
insert into student1 values('2019002','马笑笑','计本一班','软件工程',19,'17878341906','女')
insert into student1 values('2019003','宋村村','计本二班','操作系统',19,'17878560754','男')
insert into student1 values('2019004','贺仙子','计本二班','3dmax',19,'17878342356','女')
go

select *
from student1
go

Weform2.aspx.cs

using System;
using System.Collections.Generic;
using System.Data.SqlClient;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;

namespace WebApplication1
{
    public partial class WebForm2 : System.Web.UI.Page
    {
        protected void Page_Load(object sender, EventArgs e)
        {

        }

        protected void bt_AddStuInfo_Click(object sender, EventArgs e)
        {
            string stuNum = tb_stuNum.Text.Trim();
            string stuName = tb_stuName.Text.Trim();
            string stuClass = tb_stuClass.Text.Trim();
            string subject = tb_subject.Text.Trim();
            byte stuAge = 0;
            Byte.TryParse(tb_stuAge.Text.Trim(), out stuAge);
            string stuPhone = tb_stuPhone.Text.Trim();
            string stuGender = rbl_Gender.Select