数据库课程设计2 - 学分管理系统 - 图文

}

if (!IsPostBack) {

string sql = \

DataTable temp = CreateAdapter.getAdapter(sql); select_Cno.DataSource = temp; select_Cno.DataTextField = \ select_Cno.DataValueField = \ select_Cno.DataBind();

select_Cno.Items.Insert(0, new ListItem(\全部\ grid_Cno_DataBind(\ } }

private void grid_Cno_DataBind(string C_number) {

string + \

DataTable dt = new DataTable(); dt = CreateAdapter.getAdapter(sql); grid_Cno.DataSource = dt; grid_Cno.DataBind(); }

protected void select_Cno_SelectedIndexChanged(object sender, EventArgs e) {

Cno = select_Cno.SelectedValue;

grid_Cno_DataBind(Cno); } }

sql

=

\

Student.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname,Grade

from

Student,Course,SC where Student.Sno=SC.Sno and Course.Cno=SC.Cno and Course.Cno like '%\

13>按照班级查：

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data;

using System.IO;

public partial class teacher_check_by_Sclass : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (Session[\ {

Page.ClientScript.RegisterStartupScript(this.GetType(), \\请先登录！');location.href='../Default.aspx'\ } }

protected void Button1_Click(object sender, EventArgs e) {

string sql = \ \

\'\

DataTable dt = new DataTable(); dt = CreateAdapter.getAdapter(sql); grid_class.DataSource = dt; grid_class.DataBind(); } }

14>按照学生姓名查：

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data; using System.IO;

public partial class teacher_check_by_Sname : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (Session[\

{

Page.ClientScript.RegisterStartupScript(this.GetType(), \\请先登录！');location.href='../Default.aspx'\ } }

protected void Button1_Click(object sender, EventArgs e) { string + \

DataTable dt = new DataTable(); dt = CreateAdapter.getAdapter(sql); grid_Sname.DataSource = dt; grid_Sname.DataBind(); } }

sql

=

\

Student.Sno,Sname,Sdept,Sclass,Ssex,Course.Cno,Cname,Grade

from

Student,Course,SC where Student.Sno=SC.Sno and Course.Cno=SC.Cno and Sname like '\

15>查各科平均分数：

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.IO; using System.Data;

public partial class teacher_course_average : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) {

if (Session[\ {

Page.ClientScript.RegisterStartupScript(this.GetType(), \\请先登录！');location.href='../Default.aspx'\ }

string sql = \VGrade from SC group by Cno\ DataTable dt = new DataTable(); dt = CreateAdapter.getAdapter(sql); grid_course.DataSource = dt; grid_course.DataBind(); }

}

16>修改用户密码：

using System;

using System.Collections.Generic; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data; using System.Web.Security; using System.IO;

using System.Data.SqlClient;

public partial class createpsw : System.Web.UI.Page {

protected void Page_Load(object sender, EventArgs e) { }

protected void Button1_Click(object sender, EventArgs e) { string stu_newpwd FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox1.Text.ToString(), \ string

tea_newpwd

FormsAuthentication.HashPasswordForStoringInConfigFile(TextBox1.Text.ToString(), \ string update = \ \ if (dbConnection.insert(update))

Response.Write(\密码修改成功');\ } }

17>删除学生：

using System;

using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI;

using System.Web.UI.WebControls; using System.Data.SqlClient; using System.Data;

= =