资源预览内容
第1页 / 共37页
第2页 / 共37页
第3页 / 共37页
第4页 / 共37页
第5页 / 共37页
第6页 / 共37页
第7页 / 共37页
第8页 / 共37页
第9页 / 共37页
第10页 / 共37页
亲,该文档总共37页,到这儿已超出免费预览范围,如果喜欢就下载吧!
资源描述
精选资料系统源代码一、登录界面代码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.AppSettingsconnStr; 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.Tables0.Rows.Count=0) Label3 .Text =账号或密码错误,请重新输入!; else Session userid=txtid .Text ; Sessionuserpwd = txtpassword.Text; Sessionusername = ds.Tables0.Rows0username.ToString(); Sessionuserpower = ds.Tables0.Rows0userpower.ToString(); if (Sessionuserpower.ToString () = 0) Response.Redirect(admin/index.aspx); else if (Sessionuserpower.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.AppSettingsconnStr; 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(javascript:alert(添加成功!);); catch (SqlException) Response.Write(javascript:alert(添加失败!);); finally conn.Close(); sqlstr = ; protected void Button2_Click(object sender, EventArgs e) courseid.Text = ; coursename.Text = ; coursetime.Text = ; fen.Text = ; type.Text = ; 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;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.AppSettingsconnStr; conn = new SqlConnection(strconn); 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(); mycmd = new Sql
网站客服QQ:2055934822
金锄头文库版权所有
经营许可证:蜀ICP备13022795号 | 川公网安备 51140202000112号