学生信息管理系统 系统源代码

一、登录界面代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

1

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

protected void txtid_Click(object sender, EventArgs e)

{

txtid.Text = \"\";

txtpassword.Text = \"\";

}

protected void Button1_Click(object sender, EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

conn.Open();

DataSet ds=new DataSet () ;

2

SqlDataAdapter da = new SqlDataAdapter(\"select * from users where userid='\" + txtid.Text + \"' and userpwd='\" + txtpassword.Text + \"'\

da.Fill(ds);

if (ds.Tables[0].Rows.Count==0)

{

Label3 .Text =\"账号或密码错误，请重新输入！\";

}

else

{

Session [\"userid\"]=txtid .Text ;

Session[\"userpwd\"] = txtpassword.Text;

Session[\"username\"]

ds.Tables[0].Rows[0][\"username\"].ToString();

Session[\"userpower\"]

ds.Tables[0].Rows[0][\"userpower\"].ToString();

3

=

=

if (Session[\"userpower\"].ToString () == \"0\") {

Response.Redirect(\"admin/index.aspx\");

}

else if (Session[\"userpower\"].ToString() == \"1\")

{

Response.Redirect(\"student/index.aspx\");

}

else

{

Label3.Text = \"对不起，权限验证失败\";

}

}

4

conn.Close(); ds.Clear ();

}

}

二、添加课程页面代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

5

using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class addcourse : System.Web.UI.Page

{

SqlCommand mycmd;

SqlConnection conn;

protected void Page_Load(object sender, EventArgs e)

{

courseid.Attributes.Add(\"onblur\

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

}

6

protected void Button1_Click(object sender, EventArgs e) {

if (courseid.Text.ToString() == \"\")

{

Label7.Text = \"课程号不能为空\";

}

else

{

string sqlstr = \"\";

sqlstr = \"insert course(courseid,coursename,coursetime,fen,type,teacher)values('\"

courseid.Text + \"','\" + coursename.Text + \"','\" + coursetime.Text fen.Text + \"','\" + type.Text + \"','\" + teacher.Text + \"')\";

conn.Open();

mycmd = new SqlCommand(sqlstr, conn);

into +

\"','\" + 7+

mycmd.Dispose(); try

{

mycmd.ExecuteNonQuery();

Response.Write(\"\");

}

catch (SqlException)

{

Response.Write(\"\");

}

finally

{

添加添加成

失

8

conn.Close(); sqlstr = \"\";

}

}

}

protected void Button2_Click(object sender, EventArgs e)

{

courseid.Text = \"\";

coursename.Text = \"\";

coursetime.Text = \"\";

fen.Text = \"\";

type.Text = \"\";

}

9

protected void Button3_Click(object sender, EventArgs e) {

Response.Redirect(\"course.aspx\");

}

}

三、添加成绩程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

10

using System.Web.UI.WebControls; using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class addscore : System.Web.UI.Page

{

SqlCommand mycmd;

SqlConnection conn;

protected void Page_Load(object sender, EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

}

11

protected void Button1_Click(object sender, EventArgs e) {

if (userid.SelectedValue .ToString ()== \"\")

{

Label11.Text = \"学号不能为空\";

}

else

{

string sqlstr = \"\";

sqlstr = \"insert into +

score(userid,username,courseid,coursename,score,[year])values('\"

userid.SelectedValue + \"','\" + username.Text + \"','\" + txtcourseid.SelectedValue + \"','\" + coursename.Text + \"','\" + score.Text + \"','\" + txtyear.SelectedValue + \"')\";

conn.Open();

12

mycmd = new SqlCommand(sqlstr, conn); mycmd.Dispose();

try

{

mycmd.ExecuteNonQuery();

Response.Write(\"\");

}

catch (SqlException)

{

Response.Write(\"\");

}

finally

添加添加成

失

13

{ conn.Close();

sqlstr = \"\";

}

}

}

protected void Button2_Click(object sender, EventArgs e)

{

username.Text = \"\";

coursename.Text = \"\";

score.Text = \"\";

txtyear.Text = \"\";

}

14

protected void Button3_Click(object sender, EventArgs e) {

Response.Redirect(\"score.aspx\");

}

protected void userid_SelectedIndexChanged(object sender, EventArgs e)

{

string sqlstr = \"\";

sqlstr = \"select username from students where userid='\" + userid.SelectedValue + \"'\";

conn.Open();

mycmd = new SqlCommand(sqlstr, conn);

mycmd.Dispose();

SqlDataReader da;

da = mycmd.ExecuteReader();

15

while (da.Read()) {

username.Text = da[\"username\"].ToString();

}

}

protected EventArgs e)

void txtcourseid_SelectedIndexChanged(object sender,

{

string sqlstr = \"\";

sqlstr = \"select coursename from course where courseid='\" + txtcourseid.SelectedValue + \"'\";

conn.Open();

mycmd = new SqlCommand(sqlstr, conn);

mycmd.Dispose();

16

SqlDataReader da; da = mycmd.ExecuteReader();

while (da.Read())

{

coursename.Text = da[\"coursename\"].ToString();

}

}

}

using System;

using System.IO;

using System.Text;

using System.Data;

17

四、添加学生程序代码 using System.Configuration; using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class addstudent : System.Web.UI.Page

{

SqlCommand mycmd;

protected void Page_Load(object sender, EventArgs e)

18

{ userid.Attributes.Add(\"onblur\

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

}

protected void Button1_Click(object sender, EventArgs e)

{

if (userid.Text.ToString() == \"\")

return;

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

string sqlstr = \"\";

string sql = \"\";

19

sqlstr = \"insert into students(userid,username,sex,minzu,birthday,class,comefrom,beizhu,xuey,zhuany,tel,idc,zhengzmm,zhiw,huoj,weij)values('\"

+

userid.Text

+

\"','\"

+

txtusername.Text + \"','\" + txtsex.SelectedItem.Value + \"','\" + txtminzu.Text + \"','\" + txtbirthday.Text + \"','\" + txtclass.Text + \"','\" + txtcomefrom.Text + \"','\" + txtbeizhu.Text + \"','\" + txtxuey.SelectedValue + \"','\" + txtzhuany.SelectedValue + \"','\" + txttel.Text + \"','\" + txtidc.Text + \"','\" + txtzzmm.SelectedValue + \"','\" + txtzhiw.Text + \"','\" + txthuoj.Text + \"','\" + txtweij.Text + \"')\";

conn.Open();

mycmd = new SqlCommand(sqlstr, conn);

mycmd.Dispose();

string name = this.FileUpload1.FileName;//获取上传文件的名称

string type = name.Substring(name.LastIndexOf(\"\\\\\") + 1);//获取上传文件的后缀

string ipath = Server.MapPath(\"images/\") +

DateTime.Now.ToString(\"yyyyMMddhhmmss\") + name;

string wpath = \"images\\\\\" +

DateTime.Now.ToString(\"yyyyMMddhhmmss\") + name;

20

string query1 = \"insert into images(userid,path) values('\" + userid.Text + \"',@path)\";

FileUpload1.SaveAs(ipath); //服务器保存路径

SqlCommand cm = new SqlCommand(query1);

cm.Connection = conn;

cm.Parameters.Add(\"@path\

cm.Parameters[\"@path\"].Value = wpath;

cm.ExecuteNonQuery();

// this.lb_info.Text = \"上传成功！\";

try

{

mycmd.ExecuteNonQuery();

string sqlstr1 = \"\";

sqlstr1 = \"insert into users(userid,username)values('\" + userid.Text

21

+ \"','\" + txtusername.Text + \"') \"; SqlCommand mycmd1 = new SqlCommand(sqlstr1, conn);

mycmd1.Dispose();

try

{

mycmd1.ExecuteNonQuery();

Response.Write(\"\");

}

catch (SqlException)

{

Response.Write(\"\");

}

添加添加成

失

22

finally {

sqlstr1 = \"\";

}

}

catch (SqlException)

{

Response.Write(\"\");

}

finally

{

conn.Close();

sqlstr = \"\";

23

} }

protected void Button2_Click(object sender, EventArgs e)

{

userid.Text = \"\";

txtusername.Text = \"\";

txtminzu.Text = \"\";

txtbirthday.Text = \"\";

txtclass.Text = \"\";

txtcomefrom.Text = \"\";

txtbeizhu.Text = \"\";

}

protected void Button3_Click(object sender, EventArgs e)

24

{ Response.Redirect(\"student.aspx\");

}

}

五、检查课程号唯一性程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

25

using System.Web.UI.WebControls.WebParts; using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class checkcourseid : System.Web.UI.Page

{

protected void Page_Load(object sender, EventArgs e)

{

Response.Expires = 0;

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

string nam = Request.QueryString[\"name\"].ToString();

string sql = \"select courseid from course where courseid='\" + nam + \"'\";

SqlCommand DBHelper;

26

DBHelper = new SqlCommand(sql, conn); conn.Open();

SqlDataReader dr = DBHelper.ExecuteReader();

if (dr.Read())

{

Response.Write(\"该课程号已经存在，请换一个\");

}

else

{

Response.Write(\"该课程号可以使用\");

}

dr.Close();

}

27

} 六、检查学号唯一性程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

28

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

protected void Page_Load(object sender, EventArgs e)

{

Response.Expires = 0;

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

string nam = Request.QueryString[\"name\"].ToString();

string sql = \"select userid from students where userid='\" + nam + \"'\";

SqlCommand DBHelper;

DBHelper = new SqlCommand(sql, conn);

conn.Open();

SqlDataReader dr = DBHelper.ExecuteReader();

29

if (dr.Read()) {

Response.Write(\"该学号已经存在，请换一个\");

}

else

{

Response.Write(\"该学号可以使用\"); }

dr.Close();

}

}

七、课程信息程序代码

using System;

30

using System.Data; using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class course : System.Web.UI.Page

{

SqlConnection conn;

31

SqlDataReader getdata; protected void Page_Load(object sender, EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

SqlDataReader getdata;

SqlCommand mycmd;

DataSet ds = new DataSet();

string sql = \"\";

sql = \"select * from course order by courseid\";

mycmd = new SqlCommand(sql, conn);

conn.Open();

getdata = mycmd.ExecuteReader();

32

grdMain.DataSource = getdata; grdMain.DataBind();

mycmd.Connection.Close();

conn.Close();

mycmd.Dispose();

}

protected void Button1_Click(object sender, EventArgs e)

{

DataSet ds;

SqlDataReader da;

string strsql = \"\";

SqlCommand cmd;

conn.Open();

33

strsql = \"select * from course where courseid='\" + courseid.Text + \"'or coursename like '\" + coursename.Text + \"'\";

cmd = new SqlCommand(strsql, conn);

da = cmd.ExecuteReader();

Datagrid1.DataSource = da;

Datagrid1.DataBind();

conn.Close();

cmd.Dispose();

cmd.Connection.Close();

}

}

八、编辑、删除学生信息程序代码

using System;

using System.Data;

34

using System.Configuration; using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class images_editstudent : System.Web.UI.Page

{

SqlCommand cmd;

SqlCommand cmd2;

35

protected void Page_Load(object sender, EventArgs e) {

if (!this.IsPostBack)

{

string sql = \"\";

SqlDataReader reader;

string uid = \"\";

uid = Page.Request[\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

sql = \"select * from students where userid='\" + uid + \"'\";

SqlCommand cmd;

cmd = new SqlCommand(sql, conn);

36

conn.Open(); reader = cmd.ExecuteReader();

while (reader.Read())

{

userid.Text = reader[\"userId\"].ToString();

txtusername.Text = reader[\"username\"].ToString();

txtsex.SelectedValue = reader[\"sex\"].ToString();

txtminzu.Text = reader[\"minzu\"].ToString();

txtbirthday.Text = reader[\"birthday\"].ToString();

txtclass.Text = reader[\"class\"].ToString();

txtcomefrom.Text = reader[\"comefrom\"].ToString();

txtxuey.Text = reader[\"xuey\"].ToString();

txtzhuany.Text = reader[\"zhuany\"].ToString();

37

txttel.Text = reader[\"tel\"].ToString(); txtidc.Text = reader[\"idc\"].ToString();

}

cmd.Dispose();

sql = \"\";

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

string uid=\"\";

uid=Page .Request [\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

38

SqlConnection conn = new SqlConnection(strconn); string sql=\"\";

sql = \"update students set userid='\" + userid.Text + \"',username='\" + txtusername.Text

+

\"',minzu='\"

+

txtminzu.Text

+

\"',sex='\"

+

txtsex.SelectedItem.Value + \"',birthday='\" + txtbirthday.Text + \"',class='\" + txtclass.Text + \"',comefrom='\" + txtcomefrom.Text + \"',beizhu='\" + txtbeizhu.Text + \"',xuey='\" + txtxuey.Text + \"',zhuany='\" + txtzhuany.Text + \"',tel='\" + txttel.Text + \"',idc='\" + txtidc.Text + \"',zhengzmm='\" + txtzzmm.SelectedValue + \"'where userid='\" + uid + \"'\";

cmd=new SqlCommand (sql,conn );

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label11.Style[\"color\"] = \"blue\";

Label11.Text = \"编辑成功\";

39

Response.Write(\"\"); }

catch(SqlException )

{

Label11.Text = \"编辑失败\";

Label11.Style[\"color\"] = \"red\";

}

cmd.Dispose();

conn.Close();

}

protected void Button2_Click(object sender, EventArgs e)

{

string sql = \"\";

40

string uid = \"\"; string sqlall = \"\";

uid = Page.Request[\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

sql = \"delete from students where userid='\" + uid + \"'\";

sqlall = \"delete from images where userid='\" + uid + \"'\";

cmd = new SqlCommand(sql, conn);

cmd2 = new SqlCommand(sqlall,conn);

conn.Open();

try

{

cmd.ExecuteNonQuery();

41

string sql1 = \"\"; sql1 = \"delete from users where userid='\" + uid + \"'\";

SqlCommand cmd1 = new SqlCommand(sql1, conn);

cmd1.Dispose();

try

{

cmd1.ExecuteNonQuery();

Label11.Style[\"color\"] = \"blue\";

Label11.Text = \"删除成功\";

Response.Write(\"\");

}

catch (SqlException)

{

删除成

42

Label11.Text = \"删除失败\"; Response.Write(\"\");

}

finally

{

sql1 = \"\";

}

}

catch(SqlException )

{

Label11.Text = \"删除失败\";

Label11.Style[\"color\"] = \"red\";

}

失

43

败 cmd.Dispose(); conn.Close();

userid.Text = \"\";

txtusername.Text = \"\";

txtminzu.Text = \"\";

txtbirthday.Text = \"\";

txtclass.Text = \"\";

txtcomefrom.Text = \"\";

txtbeizhu.Text = \"\";

txtxuey.Text = \"\";

txtzhuany.Text = \"\";

txttel.Text = \"\";

txtidc.Text = \"\";

44

} protected void Button3_Click(object sender, EventArgs e)

{

Response.Redirect(\"student.aspx\");

}

}

九、编辑、删除课程信息程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

45

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

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class editcourse : System.Web.UI.Page

{

SqlCommand cmd;

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

string sql = \"\";

46

SqlDataReader reader; string uid = \"\";

uid = Page.Request[\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

sql = \"select * from course where courseid='\" + uid + \"'\";

SqlCommand cmd;

cmd = new SqlCommand(sql, conn);

conn.Open();

reader = cmd.ExecuteReader();

while (reader.Read())

{

courseid.Text = reader[\"courseid\"].ToString();

47

coursename.Text = reader[\"coursename\"].ToString(); coursetime.Text = reader[\"coursetime\"].ToString();

fen.Text = reader[\"fen\"].ToString();

type.Text = reader[\"type\"].ToString();

type.Text = reader[\"teacher\"].ToString(); }

cmd.Dispose();

sql = \"\";

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

48

string uid = \"\"; uid = Page.Request[\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

string sql = \"\";

sql = \"update course set courseid='\" + courseid.Text +

\"',coursename='\" + coursename.Text + \"',coursetime='\" + coursetime.Text + \"',fen='\" + fen.Text + \"',type='\" + type.Text + \"',teacher='\" + teacher.Text + \"' where courseid='\" + uid + \"'\";

cmd = new SqlCommand(sql, conn);

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label7.Text = \"编辑成功\";

49

Response.Write(\"\"); }

catch (SqlException)

{

Label7.Text = \"编辑失败\";

}

cmd.Dispose();

conn.Close();

}

protected void Button2_Click(object sender, EventArgs e)

{

string sql = \"\";

string uid = \"\";

50

uid = Page.Request[\"id\"]; string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

sql = \"delete from course where courseid='\" + uid + \"'\";

cmd = new SqlCommand(sql, conn);

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label7.Text = \"删除成功\";

Response.Write(\"\");

}

catch (SqlException)

51

{ Label7.Text = \"删除失败\";

}

cmd.Dispose();

conn.Close();

courseid.Text = \"\";

coursename.Text = \"\";

coursetime.Text = \"\";

fen.Text = \"\";

type.Text = \"\";

}

protected void Button3_Click(object sender, EventArgs e)

{

52

Response.Redirect(\"course.aspx\"); }

}

十、编辑、删除成绩信息程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

53

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

public partial class editscore : System.Web.UI.Page

{

SqlCommand cmd;

SqlConnection conn;

protected void Page_Load(object sender, EventArgs e)

{

if (!this.IsPostBack)

{

string sql = \"\";

SqlDataReader reader;

string uid = \"\";

uid = Page.Request[\"id\"]; string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

sql = \"select * from score where id='\" + uid + \"'\";

SqlCommand cmd;

cmd = new SqlCommand(sql, conn);

conn.Open();

reader = cmd.ExecuteReader();

while (reader.Read())

{

id.Text = reader[\"id\"].ToString();

userid.Text = reader[\"userid\"].ToString();

username.Text = reader[\"username\"].ToString();

55

txtcourseid.Text = reader[\"courseid\"].ToString(); coursename.Text = reader[\"coursename\"].ToString();

score.Text = reader[\"score\"].ToString();

}

cmd.Dispose();

sql = \"\";

conn.Close();

}

}

protected void Button1_Click(object sender, EventArgs e)

{

string uid = \"\";

uid = Page.Request[\"id\"];

56

string sql = \"\"; string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

sql = \"update score set userid='\" + userid.SelectedValue + \"',username='\" + username.Text + \"',courseid='\" + txtcourseid.SelectedValue + \"',coursename='\" + coursename.Text + \"',score='\" + score.Text + \"',[year]='\" + txtyear.SelectedValue + \"'where id='\" + uid + \"'\";

cmd = new SqlCommand(sql,conn );

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label11.Text = \"编辑成功\";

Response.Write(\"\");

}

57

catch (SqlException) {

Label11.Text = \"编辑失败\";

}

cmd.Dispose();

conn.Close();

}

protected void Button2_Click(object sender, EventArgs e)

{

string sql = \"\";

string uid = \"\";

uid = Page.Request[\"id\"];

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

58

conn = new SqlConnection(strconn); sql = \"delete from score where id='\" + uid + \"'\";

cmd = new SqlCommand(sql, conn);

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label11.Text = \"删除成功\";

Response.Write(\"\");

}

catch (SqlException)

{

Label11.Text = \"删除失败\";

59

} cmd.Dispose();

conn.Close();

id.Text = \"\";

username.Text = \"\";

coursename.Text = \"\";

score.Text = \"\";

}

protected void Button3_Click(object sender, EventArgs e)

{

Response.Redirect(\"score.aspx\");

}

protected void userid_SelectedIndexChanged(object sender, EventArgs e)

60

{ string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

string sqlstr = \"\";

sqlstr = \"select username from students userid.SelectedValue + \"'\";

conn.Open();

cmd = new SqlCommand(sqlstr, conn);

cmd.Dispose();

SqlDataReader da;

da = cmd.ExecuteReader();

while (da.Read())

{

username.Text = da[\"username\"].ToString();

where userid='\" + 61

} }

protected void txtcourseid_SelectedIndexChanged(object sender,

EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

string sqlstr = \"\";

sqlstr = \"select coursename from course where courseid='\" txtcourseid.SelectedValue + \"'\";

conn.Open();

cmd = new SqlCommand(sqlstr, conn);

cmd.Dispose();

SqlDataReader da;

+ 62

da = cmd.ExecuteReader(); while (da.Read())

{

coursename.Text = da[\"coursename\"].ToString();

}

}

}

十一、修改密码程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

63

using System.Web.Security; using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class modify_pwd : System.Web.UI.Page

{

SqlConnection conn;

protected void Page_Load(object sender, EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

} protected void Button1_Click(object sender, EventArgs e)

{

string sql=\"\";

SqlCommand cmd;

string uid;

string pwd;

uid = Session[\"userid\"].ToString ();

pwd = Session[\"userpwd\"].ToString();

if (txtpassword.Text == \"\")

{

Label4.Text = \"原密码不能为空\";

}

65

else if (password.Text == \"\") {

Label4.Text = \"新密码不能为空\";

}

else if (password.Text != password1.Text)

{

Label4.Text = \"新密码和确认密码不一致\";

}

else if (txtpassword.Text != pwd)

{

Label4.Text = \"原密码不正确\";

}

else

66

{ sql = \"\";

sql = \"update users set userpwd='\" + password.Text + \"'where userid='\" + uid + \"'\";

cmd = new SqlCommand(sql, conn);

conn.Open();

try

{

cmd.ExecuteNonQuery();

Label4.Text = \"密码修改成功\";

}

catch (SqlException)

{

Label4.Text = \"密码修改失败\";

67

} finally

{

conn.Close();

}

}

}

protected void Button2_Click(object sender, EventArgs e)

{

Response.Redirect(\"student.aspx\");

}

}

十二、学生身份操作主界面程序代码

68

using System; using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

using System.Web.UI.HtmlControls;

using System.Data.SqlClient;

public partial class student : System.Web.UI.Page

{

69

protected void Page_Load(object sender, EventArgs e) {

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

SqlConnection conn = new SqlConnection(strconn);

string strsql = \"\";

string a = Session[\"userid\"].ToString();

conn.Open();

strsql = \"select * from students where userid='\"+a+\"'\";

DataSet ds=new DataSet () ;

SqlDataAdapter da= new SqlDataAdapter(strsql, conn);

da.Fill(ds);

if (ds.Tables[0].Rows.Count == 0)

{

70

Response .Write (\"没有记录\"); }

else

{

Label1.Text = ds.Tables[0].Rows[0][\"userid\"].ToString();

Label2.Text = ds.Tables[0].Rows[0][\"username\"].ToString();

Label3.Text = ds.Tables[0].Rows[0][\"sex\"].ToString();

Label4.Text = ds.Tables[0].Rows[0][\"minzu\"].ToString();

Label5.Text = DateTime Label7.Text = ds.Tables[0].Rows[0][\"class\"].ToString();

Label8.Text = ds.Tables[0].Rows[0][\"comefrom\"].ToString();

Label9.Text = ds.Tables[0].Rows[0][\"beizhu\"].ToString();

}

.Parse

71

(ds.Tables[0].Rows[0][\"birthday\"].ToString ()).ToShortDateString ();

conn.Close(); }

}

十三、学生身份成绩信息程序代码

using System;

using System.Data;

using System.Configuration;

using System.Collections;

using System.Web;

using System.Web.Security;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.WebControls.WebParts;

72

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

public partial class score : System.Web.UI.Page

{

SqlConnection conn;

protected void Page_Load(object sender, EventArgs e)

{

string strconn = ConfigurationManager.AppSettings[\"connStr\"];

conn = new SqlConnection(strconn);

SqlDataReader getdata;

SqlDataAdapter da = new SqlDataAdapter();

SqlCommand mycmd;

DataSet ds = new DataSet();

73

string Sql; Sql = \"select * from score where userid='\" + Session[\"userid\"] + \"'\";

mycmd = new SqlCommand(Sql, conn);

da.SelectCommand = mycmd;

da.Fill(ds, \"login\");

conn.Open();

// getdata = mycmd.ExecuteReader();

// grdMain.DataSource = getdata;

datagrid1.DataSource = ds.Tables[\"login\"]; ;

datagrid1.DataBind();

conn.Close();

}

protected void Button1_Click(object sender, EventArgs e)

74

{ datagrid1.CurrentPageIndex = 0;

SqlDataReader getdata;

SqlDataAdapter da = new SqlDataAdapter();

SqlCommand mycmd;

DataSet ds = new DataSet();

string Sql;

Sql = \"select * from score where userid='\" + txtscore.Text + \"'or year='\" + txtyear.SelectedValue + \"'\";

mycmd = new SqlCommand(Sql, conn);

da.SelectCommand = mycmd;

da.Fill(ds, \"login\");

conn.Open();

//getdata = mycmd.ExecuteReader();

75

//grdMain.DataSource = getdata; datagrid1.DataSource = ds.Tables[\"login\"]; ;

datagrid1.DataBind();

conn.Close();

}

protected void datagrid1_PageIndexChanged(object {

datagrid1.CurrentPageIndex = e.NewPageIndex;

datagrid1.DataBind();

}

} 雨滴穿石，不是靠蛮力，而是靠持之以恒。——拉蒂默

source,

76

DataGridPageChangedEventArgs e)