《（可编）学生信息管理系统系统源代码》由会员分享，可在线阅读，更多相关《（可编）学生信息管理系统系统源代码（41页珍藏版）》请在金锄头文库上搜索。
1、系统源代码一、登录界面代码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.ULWebControls;using System.Web.ULWebControls.WebParts;using System.Web.UI.HtmIControls:using System.Data.SqlClient;public pa
2、rtial class login : System.Web.UI.Page(protected void txtid_Click(object sender. EventArgs e)txtid.Text =txtpassword.Text =Iprotected void Buttonl_Click(object sender, EventArgs e)string strconn = ConfigurationManagcnAppSettingsIconnStr1 ;SqlConnection conn = new SqlConnection(strconn); conn.OpenO;D
3、ataSet ds=new DalaSet ();SqlDataAdapter da = new SqlDataAdapter(Mselect * from users where uscrid=,H + txtid.Tcxt + H, and userpwd=H, + txtpassword.Text + 心,conn);da.Fill(ds);if (ds.Tables0.Rows.Count=0)Labcl3 .Text =M账号或密码错误，请重新输入！ ”；elseSession HuscridH=txtid .Text ;Session MuserpwdM I = txtpasswo
4、rd.Text;Session MusernameH = ds.TabIes0.Rows0(,usernameM.ToString();SessionMuserpowerH = ds.Tables|0.Rows|0r userpowcrHJ.ToString(|;if (SessionMuserpowerH.ToString () = ”0)Response. Redirect(Hadmin/index.aspx);else if (Session!HuscrpowerM.ToString() = T)(Response. Redirect(Mstudent/index.aspxH);)els
5、eLabel3.Text = M对不起，权限验证失败”;conn.CloseO:ds.CIcar ();二、添加课程页面代码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.ULWebControls;using System.Web.Ul.WebControls.WebParts;using System.Web.UI.
6、HunlControls：using System.Data.SqlClient;public partial class addcourse : System.Web.UI.Page(SqlCommand myemd;SqlConnection conn;protected void Page_Load(object sender EventArgs e) courseid.Attributes.AddC，onblurH, Hcheckcourseid()M);string strconn = ConfigurationManager.AppScttingsr，connStrH|;conn
7、= new SqlConnection(strconn);)protected void Buttonl_Click(objecl sender, EventArgs e)if (courseid.Text.ToStringO = MM)ILabel7.Texl = ”课程号不能为空”；elseIstring sqlstr = ”；sqlstr = insert intocourse(courseidxoursenamc,coursetimc.fen.typc,teacher)valucs(M, + courseid.Text + ” + coursename.Text + coursetim
8、e.Text + fen Text + type Text + 二” +teacher.Text +conn.OpcnO;myemd = new SqlCommand(sqlstr conn);myemd. Dispose。；trymycmd.ExccutcNonQucryO；Response.WnteCscripOjavascripCalertC 添加成功!);”);catch (SqlException)Response. Write(Hjavascript:alert(,添加失败!);”);finally(conn.CloseO;sqlstr =”；protected void Butt
9、on2_Click(object sender, EvcntArgs e) courseid.Text =coursename.Text =coursetimc.Text =fen.Text = *type.Text = ”；)protected void Button3_Click(object sender, EvcntArgs e) Response. Redirect(Mcourse.aspxn);三、添加成绩程序代码using System;using System.Data;using System.Configuration:using System.Collections;us
10、ing Syslem.Web;using System.Web.Security;using System.Web.UI:using System.Web.Ul.WcbControls;using System.Web.ULWebControls.WebParts;using System.Web.UI.HtmlControls:using System.Data.SqlClienl:public partial class addscore : System.Web.UI.Page(SqlConunand myemd;SqlConnection conn;protected void Pag
11、e_Load(object sender EventArgs e)string strconn = ConngurationManagcr.AppSetlingsrconnStrM|: conn = new SqlConncction(strconn);protected void Buttonl_Click(object sender, EventArgs e)if (userid.Selected Value .ToString ()= )elsestring sqlstr = ”；sqlstr = insert intoscore( userid,uscmame.courseidcoii
12、rsename,score,year) alues( + userid.Selected Value + + username.Text + H,H + txtcourseid.SelectedValue + courscname.Tcxt +scorc.Text + txtyear.SelectedValue +conn.Open();mycmd = new SqlCominand(sqlstr, conn);mycmd. Dispose。：try(mycmd.ExecuteNonQueryO;Response. Wrile(Hjavascript:alert(,添加成功!):”)；catc
13、h (SqlException)(Response. Write(ljavascript:alert(,添加失败！ ！ ！):”)；finallyconn.CloscO;sqlstr = 5；protected void Button2_Click(object sender, EventArgs e)username.Text = ”；coursename.Text =”；score.Text =txtyear.Tcxt = ”；protected void Button3_Click(object sender, EventArgs e)Response.Rcdirect(Mscore.a
14、spxH);protected void userid_SelectedIndexChanged(object sender, EventArgs e)(string sqlstr =sqlstr = ” select username from students where userid =,M + userid.Selected Value +conn.OpenO;myemd = new SqlCommand(sqlstr, conn);myemd. Dispose。；SqlDataReader da:da = myemd.ExecuteReaderO;while (da.Read()us
15、ername.Text = da,usemamen.ToString();protected void txtcourseid_Selected!ndexChanged(object sender, EventArgs e)string sqlstr =sqlstr = Mselect coursenamc from course where courseid=,n + txtcourseid.SelectedValue +conn.Open();mycmd = new SqlCommand(sqlstn conn);mycmd.DisposeO;SqlDataReader da;da = m
