vs2015 dynamicweb8-4 ado.net SqlDataSource数据源控件的使用

最新推荐文章于 2023-02-15 09:18:16 发布

虾米大王

最新推荐文章于 2023-02-15 09:18:16 发布

阅读量237

点赞数

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

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

版权

c# 同时被 2 个专栏收录

284 篇文章 0 订阅

订阅专栏

asp.net

258 篇文章 2 订阅

订阅专栏

需要使用可视化设计方式，配置sqldatasource数据源控件的连接。

最终代码结果如下：

webform1.aspx

<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_4.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="text-align:center;width:100%;height:200px;overflow:scroll;">
        <asp:SqlDataSource ID="sdsStudent" runat="server" ConnectionString="<%$ ConnectionStrings:studentMISConnectionString %>" SelectCommand="SELECT * FROM [student]"></asp:SqlDataSource>
        <asp:GridView ID="gvStudent" runat="server" HorizontalAlign="Center" Font-Size="Small" AutoGenerateColumns="False" CellPadding="4" DataKeyNames="stu_id" DataSourceID="sdsStudent" ForeColor="#333333" GridLines="None">
            <AlternatingRowStyle BackColor="White" />
            <Columns>
                <asp:BoundField DataField="stu_id" HeaderText="学号" ReadOnly="True" SortExpression="stu_id">
                <ItemStyle Width="200px" />
                </asp:BoundField>
                <asp:BoundField DataField="stu_name" HeaderText="姓名" SortExpression="stu_name" >
                <ItemStyle Width="200px" />
                </asp:BoundField>
                <asp:BoundField DataField="sex" HeaderText="性别" SortExpression="sex" >
                <ItemStyle Width="200px" />
                </asp:BoundField>
                <asp:BoundField DataField="birth_date" DataFormatString="{0:d}" HeaderText="出生日期" SortExpression="birth_date" >
                <ItemStyle Width="200px" />
                </asp:BoundField>
                <asp:BoundField DataField="major" HeaderText="专业" SortExpression="major" >
                <ItemStyle Width="200px" />
                </asp:BoundField>
                <asp:CheckBoxField DataField="isCPC" HeaderText="是否党员" SortExpression="isCPC" >
                <ItemStyle Width="200px" />
                </asp:CheckBoxField>
                <asp:BoundField DataField="email" HeaderText="电子邮件" SortExpression="email" >
                <ItemStyle Width="200px" />
                </asp:BoundField>
            </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>
    </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文件

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-4 ado.net SqlDataSource数据源控件的使用

需要使用可视化设计方式，配置sqldatasource数据源控件的连接。最终代码结果如下：webform1.aspx<%@ Page Language="C#" AutoEventWireup="true" CodeBehind="WebForm1.aspx.cs" Inherits="dynamicweb8_4.WebForm1" %><!DOCTYPE html><html xmlns="http://www.w3.org/1999/xhtml"&gt
复制链接

扫一扫