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

系统源代码

一、登录界面代码

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 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 () ;

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

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();

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

{

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

}

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

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

}

else

{

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

}

}

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;

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", "checkcourseid()");

string strconn = ConfigurationManager.AppSettings["connStr"]; conn = new SqlConnection(strconn);

}

protected void Button1_Click(object sender, EventArgs e)

{

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

{

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

}

else

{

string sqlstr = "";

sqlstr = "insert into

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);

mycmd.Dispose();

try

{

mycmd.ExecuteNonQuery();

Response.Write("");

}

catch (SqlException)

{

Response.Write("");

}

finally

{

conn.Close();

sqlstr = "";

}

}

}

protected void Button2_Click(object sender, EventArgs e)