vs2015 dynamicweb8-8

最新推荐文章于 2024-03-09 22:13:24 发布

虾米大王

最新推荐文章于 2024-03-09 22:13:24 发布

阅读量185

点赞数

分类专栏： c# asp.net 文章标签： c#

本文链接：https://blog.csdn.net/modern358/article/details/115393707

版权

c# 同时被 2 个专栏收录

284 篇文章 0 订阅

订阅专栏

asp.net

258 篇文章 2 订阅

订阅专栏

webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_8.WebForm1" %>

<!DOCTYPE html>

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
<meta http-equiv="Content-Type" content="text/html; charset=utf-8"/>
    <title></title>
</head>
<body>
    <form id="form1" runat="server">
    <center><h3>学生信息</h3></center>
    <div style="width100%;height:200px;overflow:scroll;">
        <asp:GridView ID="GridView1" runat="server" HorizontalAlign="Center" AllowPaging="True" AllowSorting="True" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="stu_id" DataSourceID="SqlDataSource1" ForeColor="#333333" GridLines="None" PageSize="5">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="stu_id" HeaderText="学号" ReadOnly="True" SortExpression="stu_id" />
                <asp:BoundField DataField="stu_name" HeaderText="姓名" SortExpression="stu_name" />
                <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" />
                <asp:BoundField DataField="birth_date" HeaderText="生日" SortExpression="birth_date" />
                <asp:BoundField DataField="major" HeaderText="专业" SortExpression="major" />
                <asp:CheckBoxField DataField="isCPC" HeaderText="是否入党" SortExpression="isCPC" />
                <asp:BoundField DataField="email" HeaderText="电子邮件" SortExpression="email" />
                <asp:CommandField ShowEditButton="True" />
            </Columns>
            <EditRowStyle BackColor="#2461BF" />
            <FooterStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <HeaderStyle BackColor="#507CD1" Font-Bold="True" ForeColor="White" />
            <PagerStyle BackColor="#2461BF" ForeColor="White" HorizontalAlign="Center" />
            <RowStyle BackColor="#EFF3FB" />
            <SelectedRowStyle BackColor="#D1DDF1" Font-Bold="True" ForeColor="#333333" />
            <SortedAscendingCellStyle BackColor="#F5F7FB" />
            <SortedAscendingHeaderStyle BackColor="#6D95E1" />
            <SortedDescendingCellStyle BackColor="#E9EBEF" />
            <SortedDescendingHeaderStyle BackColor="#4870BE" />
        </asp:GridView>
        <asp:SqlDataSource ID="SqlDataSource1" runat="server" ConnectionString="<%$ ConnectionStrings:studentMISConnectionString %>" DeleteCommand="DELETE FROM [student] WHERE [stu_id] = @stu_id" InsertCommand="INSERT INTO [student] ([stu_id], [stu_name], [sex], [birth_date], [major], [isCPC], [email]) VALUES (@stu_id, @stu_name, @sex, @birth_date, @major, @isCPC, @email)" SelectCommand="SELECT * FROM [student]" UpdateCommand="UPDATE [student] SET [stu_name] = @stu_name, [sex] = @sex, [birth_date] = @birth_date, [major] = @major, [isCPC] = @isCPC, [email] = @email WHERE [stu_id] = @stu_id">
            <DeleteParameters>
                <asp:Parameter Name="stu_id" Type="String" />
            </DeleteParameters>
            <InsertParameters>
                <asp:Parameter Name="stu_id" Type="String" />
                <asp:Parameter Name="stu_name" Type="String" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="birth_date" Type="DateTime" />
                <asp:Parameter Name="major" Type="String" />
                <asp:Parameter Name="isCPC" Type="Boolean" />
                <asp:Parameter Name="email" Type="String" />
            </InsertParameters>
            <UpdateParameters>
                <asp:Parameter Name="stu_name" Type="String" />
                <asp:Parameter Name="sex" Type="String" />
                <asp:Parameter Name="birth_date" Type="DateTime" />
                <asp:Parameter Name="major" Type="String" />
                <asp:Parameter Name="isCPC" Type="Boolean" />
                <asp:Parameter Name="email" Type="String" />
                <asp:Parameter Name="stu_id" Type="String" />
            </UpdateParameters>
        </asp:SqlDataSource>
    </div>
    </form>
</body>
</html>

web.config

<?xml version="1.0" encoding="utf-8"?>

<!--
  有关如何配置 ASP.NET 应用程序的详细信息，请访问
  http://go.microsoft.com/fwlink/?LinkId=169433
  -->

<configuration>
    <connectionStrings>
        <add name="studentMISConnectionString" connectionString="Data Source=LAPTOP-AQKEN65V\SQLEXPRESS08;Initial Catalog=studentMIS;Persist Security Info=True;User ID=sa;Password=123456"
            providerName="System.Data.SqlClient" />
    </connectionStrings>
    <system.web>
      <compilation debug="true" targetFramework="4.5" />
      <httpRuntime targetFramework="4.5" />
    </system.web>

</configuration>

sql

--学生管理系统库
create database studentMIS;


use studentMIS;

--学生表
create table student(
	stu_id nvarchar(8) not null,
	stu_name nvarchar(8) not null,
	sex nvarchar(2) not null,
	birth_date datetime,
	major nvarchar(50) not null,
	isCPC bit,
	email nvarchar(20),
	primary key(stu_id)
);


--课程表
create table course(
	course_id smallint identity(1,1) not null,
	course_name nvarchar(50) not null
);


--成绩表
create table result(
	stu_id nvarchar(8) not null,
	course_id smallint not null,
	mark decimal(6,0) not null,
	primary key(stu_id,course_id)
);


insert into student values('20160101','王霞','女','1998-10-23','计算机信息管理','true','wx@163.com');
insert into student values('20160102','张大力','男','1998-07-02','计算机信息管理','false','zdf@163.com');
insert into student values('20160103','李长军','男','1998-5-14','计算机信息管理','false','lcj@163.com');
insert into student values('20160104','韩华东','男','1998-12-07','计算机信息管理','false','8562478@qq.com');
insert into student values('20160105','万芳','女','1998-01-27','软件技术','false','5478518@qq.com');
insert into student values('20160106','赵中千','男','1998-08-12','软件技术','true','5582178@qq.com');
insert into student values('20160107','吴空俊','男','1998-05-21','软件技术','false','4845512@qq.com');
insert into student values('20160108','方文其','男','1998-06-05','软件技术','false','8412563@qq.com');
insert into student values('20160109','唐汉','男','1998-04-18','计算机应用','false','1546315@qq.com');
insert into student values('20160110','刘含斌','男','1998-10-07','计算机应用','false','741526@qq.com');

insert into course values('高等数学');
insert into course values('大学英语');
insert into course values('邓小平理论概述');
insert into course values('毛泽东思想概述');
insert into course values('C语言程序设计');
insert into course values('数据结构');

insert into result values('20160101',1,'71');
insert into result values('20160101',2,'72');
insert into result values('20160101',3,'73');
insert into result values('20160101',4,'74');
insert into result values('20160101',5,'75');
insert into result values('20160101',6,'76');
insert into result values('20160102',1,'60');
insert into result values('20160102',2,'61');
insert into result values('20160102',3,'60');
insert into result values('20160102',4,'62');
insert into result values('20160102',5,'60');
insert into result values('20160102',6,'59');

虾米大王

关注

0
点赞
踩
0

收藏

觉得还不错? 一键收藏
打赏
0
评论
vs2015 dynamicweb8-8

webform1.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_8.WebForm1" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"><head runat="server"><meta http-equiv
复制链接

扫一扫