34龙超实习四学生成绩管理系统C#.docx
- 文档编号:6767396
- 上传时间:2023-05-10
- 格式:DOCX
- 页数:21
- 大小:596.67KB
34龙超实习四学生成绩管理系统C#.docx
《34龙超实习四学生成绩管理系统C#.docx》由会员分享,可在线阅读,更多相关《34龙超实习四学生成绩管理系统C#.docx(21页珍藏版)》请在冰点文库上搜索。
34龙超实习四学生成绩管理系统C#
课程实验报告
专业年级09计科
课程名称SQLServer数据库
指导教师王纯德
学生姓名龙超
学号34
实验日期2011-12-19
实验地点实验楼209
实验成绩
教务处制
20年月日
第一章:
SQLServer数据库的建立
1、在SQLSever2000中建立一个学生成绩表(xscj),建立一个学生表(xs):
设计表:
在表中输入学生信息:
2、建立一个课程表(KC)
设计表:
在表中输入信息:
3、建立一个成绩表
设计表:
在表中输入成绩信息
第二章:
ASP.NET(C#)学生成绩管理系统
一、学生信息录入
1、演示界面:
2、详细代码:
<%@PageLanguage="C#"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="Default2.aspx.cs"Inherits="Default2"Title="无标题页"%>
ContentID="Content1"ContentPlaceHolderID="head"Runat="Server"> .style15 { } .style16 { width: 39px; } .style17 { width: 178px; } .style18 { width: 129px; } .style19 { font-size: large; color: #000000; font-family: 宋体,Arial,Helvetica,sans-serif; }
Content>
ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server">
学生信息录入
选择专业
DropDownListID="zymlist"runat="server"DataSourceID="SqlDataSource1" DataTextField="ZY"DataValueField="ZY"AutoPostBack="True">
DropDownList>
选择学号
DropDownListID="xhlist"runat="server"AutoPostBack="True" DataSourceID="SqlDataSource2"DataTextField="XH"DataValueField="XH" ondatabound="xhlist_DataBound" onselectedindexchanged="xhlist_SelectIndexChanged">
DropDownList>
DetailsViewID="DetailsView1"runat="server"Height="50px"Width="125px" AutoGenerateRows="False"DataSourceID="SqlDataSource3" style="font-family: 宋体,Arial,Helvetica,sans-serif;font-size: large;color: #000000"> BoundFieldDataField="XH"HeaderText="学号"/> BoundFieldDataField="XM"HeaderText="姓名"/> BoundFieldDataField="ZY"HeaderText="专业"/> TemplateFieldHeaderText="性别"> CheckBoxID="CheckBox1"runat="server" Checked='<%#IsSex(Eval("XB"))%>'/> CheckBoxID="CheckBox1"runat="server" Checked='<%#IsSex(Eval("XB"))%>'/> LabelID="Label1"runat="server"Text='<%#StrIsSex(Eval("XB"))%>'> Label> TemplateField> BoundFieldDataField="CSSJ"HeaderText="出生时间"/> TemplateFieldHeaderText="总学分"> TextBoxID="TextBox1"runat="server"Enabled="False" Text='<%#Bind("ZXF")%>'> TextBox> LabelID="Label3"runat="server"Text='<%#Bind("ZXF")%>'> Label> LabelID="Label3"runat="server"Text='<%#Bind("ZXF")%>'> Label> TemplateField> BoundFieldDataField="BZ"HeaderText="备注"/> DetailsView> SqlDataSourceID="SqlDataSource3"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" SelectCommand="SELECT[XH],[XM],[XB],[CSSJ],[ZY],[BZ],[ZXF]FROM[XS]WHERE(([ZY]=@ZY)AND([XH]=@XH))"> ControlParameterControlID="zymlist"Name="ZY" PropertyName="SelectedValue"Type="String"/> ControlParameterControlID="xhlist"Name="XH"PropertyName="SelectedValue" Type="String"/> SqlDataSource> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" SelectCommand="SELECTDISTINCTZYFROMXS"> SqlDataSource>
SqlDataSourceID="SqlDataSource2"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString2%>" SelectCommand="SELECT[XH]FROM[XS]WHERE([ZY]=@ZY)"> ControlParameterControlID="zymlist"Name="ZY" PropertyName="SelectedValue"Type="String"/> SqlDataSource>
Content>
三、学生信息查询
1、界面演示:
2、详细代码:
<%@PageLanguage="C#"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="Default3.aspx.cs"Inherits="Default3"Title="无标题页"%>
ContentID="Content1"ContentPlaceHolderID="head"Runat="Server"> .style15 {font-family: 宋体,Arial,Helvetica,sans-serif; } .style16 { width: 155px; } .style17 { width: 203px; } .style18 { width: 58px; }
Content>
ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server"> 学号 TextBoxID="TextBox1"runat="server"> TextBox> 姓名 TextBoxID="TextBox2"runat="server"> TextBox> LabelID="Label2"runat="server"Text="专业"> Label> DropDownListID="DropDownList1"runat="server"AutoPostBack="True" DataSourceID="SqlDataSource1"DataTextField="ZY"DataValueField="ZY"> DropDownList> ButtonID="Button1"runat="server"Text="查询"/>
GridViewID="GridView1"runat="server"AllowPaging="True" AllowSorting="True"AutoGenerateColumns="False"DataKeyNames="XH" DataSourceID="SqlDataSource2"onpageindexchanged="GridView1_PageIndexChanged" onselectedindexchanged="GridView1_SelectIndexChanged"> CommandFieldShowSelectButton="True"/> BoundFieldDataField="XM"HeaderText="姓名"SortExpression="XM"/> BoundFieldDataField="XH"HeaderText="学号"ReadOnly="True" SortExpression="XH"/> TemplateFieldHeaderText="性别"SortExpression="XB"> TextBoxID="TextBox1"runat="server"Text='<%#Bind("XB")%>'> TextBox> LabelID="Label1"runat="server"Text='<%#IsSex(Eval("XB"))%>'> Label> TemplateField> BoundFieldDataField="CSSJ"HeaderText="出生时间"SortExpression="CSSJ"/> BoundFieldDataField="ZY"HeaderText="专业"SortExpression="ZY"/> BoundFieldDataField="ZXF"HeaderText="总学分"SortExpression="ZXF"/> BoundFieldDataField="BZ"HeaderText="备注"SortExpression="BZ"/> GridView> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" SelectCommand="SELECTDISTINCTZYFROMXS"> SqlDataSource> SqlDataSourceID="SqlDataSource2"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" SelectCommand="SELECT[XH],[CSSJ],[ZY],[ZXF],[BZ],[XM],[XB]FROM[XS]WHERE(([XH]=@XH)AND([XM]=@XM))"> ControlParameterControlID="TextBox1"Name="XH"PropertyName="Text" Type="String"/> ControlParameterControlID="TextBox2"Name="XM"PropertyName="Text" Type="String"/> SqlDataSource>
Content>
四、学生成绩录入
1、演示界面:
2、详细代码:
<%@PageLanguage="C#"MasterPageFile="~/MasterPage.master"AutoEventWireup="true"CodeFile="Default4.aspx.cs"Inherits="Default4"Title="无标题页"%>
ContentID="Content1"ContentPlaceHolderID="head"Runat="Server"> .style15 { width: 582px; } .style16 { width: 304px; } .style19 { width: 302px; } .style20 { width: 339px; }
Content>
ContentID="Content2"ContentPlaceHolderID="ContentPlaceHolder1"Runat="Server">
成绩信息录入
专业
DropDownListID="DropDownList1"runat="server"AutoPostBack="True" DataSourceID="SqlDataSource1"DataTextField="ZY"DataValueField="ZY">
DropDownList>
课程
DropDownListID="DropDownList2"runat="server"AutoPostBack="True" DataSourceID="SqlDataSource2"DataTextField="KCM"DataValueField="KCH" onselectedindexchanged="stuKCM_SelectedIndexChanged">
DropDownList>
GridViewID="GridView1"runat="server"AllowPaging="True" AllowSorting="True"AutoGenerateColumns="False"DataKeyNames="XH" DataSourceID="SqlDataSource3"onpageindexchanged="GridView1_PageIndexChanged" onselectedindexchanged="GridView1_SelectedIndexChanged"> BoundFieldDataField="XH"HeaderText="学号"ReadOnly="True" SortExpression="XH"/> BoundFieldDataField="XM"HeaderText="姓名"SortExpression="XM"/> BoundFieldDataField="ZY"HeaderText="专业"SortExpression="ZY"/> TemplateFieldHeaderText="成绩"> TextBoxID="TextBox1"runat="server"> TextBox> TemplateField> TemplateFieldHeaderText="操作"> RadioButtonListID="RadioButtonList1"runat="server"> ListItemSelected="True">保存 ListItem> ListItem>删除 ListItem> RadioButtonList> TemplateField> CommandFieldButtonType="Button"SelectText="确定"ShowSelectButton="True"/> GridView> SqlDataSourceID="SqlDataSource1"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" SelectCommand="SELECTDISTINCTZYFROMXS"> SqlDataSource> SqlDataSourceID="SqlDataSource2"runat="server" ConnectionString="<%$ConnectionStrings: xscjConnectionString%>" 如PPT文件的首页显示word图标,表示该PPT已包含配套word讲稿。双击word图标可打开word文档。
部分文档作品中含有的国旗、国徽等图片,仅作为作品整体效果示例展示,禁止商用。设计者仅对作品中独创性部分享有著作权。
冰点文库所有资源均是用户自行上传分享,仅供网友学习交流,未经上传用户书面授权,请勿作他用。