学生信息管理系统系统源代码VIP免费

系统源代码一、登录界面代码usingSystem;usingSystem。Data;usingSystem。Configuration;usingSystem.Collections;usingSystem。Web；usingSystem。Web。Security;usingSystem。Web.UI;usingSystem.Web。UI。WebControls;usingSystem.Web。UI.WebControls。WebParts；usingSystem。Web.UI.HtmlControls；usingSystem.Data.SqlClient；publicpartialclasslogin:System。Web.UI。Page{protectedvoidtxtid_Click(objectsender,EventArgse)｛txtid.Text="";txtpassword。Text=””；｝protectedvoidButton1_Click（objectsender,EventArgse）{stringstrconn=ConfigurationManager.AppSettings["connStr”］;SqlConnectionconn=newSqlConnection（strconn）;conn.Open(）;DataSetds=newDataSet（)；SqlDataAdapterda=newSqlDataAdapter（”select*fromuserswhereuserid=’"+txtid.Text+"’anduserpwd='”+txtpassword.Text+"’”，conn)；da。Fill(ds);1if(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”);}elseif(Session［”userpower"］。ToString（）=="1”)｛Response。Redirect("student/index。aspx”）;}else｛Label3。Text="对不起，权限验证失败";｝｝conn.Close（）；ds.Clear（);}｝二、添加课程页面代码usingSystem；usingSystem.Data;2usingSystem.Configuration;usingSystem。Collections;usingSystem.Web；usingSystem.Web。Security;usingSystem。Web.UI;usingSystem.Web。UI.WebControls;usingSystem.Web.UI.WebControls.WebParts;usingSystem.Web。UI.HtmlControls;usingSystem.Data。SqlClient；publicpartialclassaddcourse：System.Web。UI。Page{SqlCommandmycmd；SqlConnectionconn；protectedvoidPage_Load（objectsender,EventArgse）｛courseid。Attributes。Add("onblur"，”checkcourseid（)")；stringstrconn=ConfigurationManager。AppSettings［”connStr”］;conn=newSqlConnection（strconn）；}protectedvoidButton1_Click(objectsender，EventArgse){if(courseid.Text.ToString（）==”")｛Label7.Text="课程号不能为空”；｝else｛stringsqlstr="";sqlstr=”insertintocourse（courseid，coursename，coursetime，fen，type,teacher）values(’”+courseid。Text+”’，’”+coursename。Text+”'，’”+coursetime。3Text+"’,'"+fen。Text+”',’”+type.Text+"’,’”+teacher.Text+"’）”；conn。Open();mycmd=newSqlCommand（sqlstr，conn);mycmd.Dispose（)；try{mycmd。ExecuteNonQuery(）;Response。Write("〈script〉javascript:alert(’添加成功！!！')；〈/script〉"）；}catch(SqlException){Response.Write（””)；}finally{conn。Close（)；sqlstr=""；}｝｝protectedvoidButton2_Click（objectsender,EventArgse）｛courseid。Text=””;coursename。Text=””；coursetime。Text=””；fen.Text=”";type。Text="”;｝protectedvoidButton3_Click（objectsender，EventArgse)4｛Response.Redirect("course。aspx")；}｝三、添加成绩程序代码usingSystem；usingSystem。Data；usingSystem。Configuration；usingSystem.Collections；usingSystem。Web；usingSystem。Web。Security;usingSystem.Web。UI；usingSystem。Web.UI.WebControls;usingSystem.Web.UI。WebControls.WebParts；usingSystem。Web。UI.HtmlControls;usingSystem.Data.SqlClient；publicpartialclassaddscore:System.Web.UI.Page｛SqlCommandmycmd；SqlConnectionconn;protectedvoidPage_Load(objectsender，EventArgse){stringstrconn=...