tem.Web.UI.WebControls.ButtonBtn_enter;
privatevoidPage_Load(objectsender,System.EventArgse)
{
//在此处放置用户代码以初始化页面
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
privatevoidInitializeComponent()
{
this.Btn_enter.Click+=newSystem.EventHandler(this.Btn_enter_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
privatevoidBtn_enter_Click(objectsender,System.EventArgse)
{
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnectioncn=newSqlConnection(strconn);
cn.Open();
stringstrsql="select*fromuserswhereUser_id='"+Tbx_userid.Text+"'andUser_password='"+Tbx_userpwd.Text+"'";
SqlCommandcm=newSqlCommand(strsql,cn);
SqlDataReaderdr=cm.ExecuteReader();
if(dr.Read())
{Session["User_id"]=dr["User_id"];
Session["user_power"]=dr["User_power"];
if((int)Session["User_power"]==0)
{
Response.Redirect("query.aspx");
}
else
{
Response.Redirect("student.aspx");
}
}
else
{
Lbl_note.Text="对不起,登陆失败!";
}
cn.Close();
}
}
}
8.2学生信息维护页面
学生信息维护模块时SMS重管理学生学籍的部分。页面采用DataGrid控件的Dgd_student与DataSet数据集的绑定返回所有学生信息,可以对学生信息进行修改和删除。
代码如下:
usingSystem;
usingSystem.Collections;
usingSystem.ComponentModel;
usingSystem.Data;
usingSystem.Data.SqlClient;
usingSystem.Drawing;
usingSystem.Web;
usingSystem.Web.SessionState;
usingSystem.Web.UI;
usingSystem.Web.UI.WebControls;
usingSystem.Web.UI.HtmlControls;
usingSystem.Configuration;
namespacesms
{
///
///student的摘要说明。
///
publicclassstudent:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_course;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_sortcourse;
protectedSystem.Web.UI.WebControls.DataGridDgd_student;
protectedSystem.Web.UI.WebControls.ButtonBtn_all;
protectedSystem.Web.UI.WebControls.PanelPnl_sort;
protectedSystem.Web.UI.WebControls.TextBoxTbx_sortid;
protectedSystem.Web.UI.WebControls.ButtonBtn_ok;
SqlConnectioncn;
protectedSystem.Web.UI.WebControls.ButtonBtn_search;
protectedSystem.Web.UI.WebControls.LabelLbl_note;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_add;
protectedSystem.Web.UI.WebControls.TextBoxTbx_name;
protectedSystem.Web.UI.WebControls.ButtonBtn_exit;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_grade;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_addclass;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_addteacher;
protectedSystem.Web.UI.WebControls.LinkButtonLbtn_student;
stringstrsql;
privatevoidPage_Load(objectsender,System.EventArgse)
{
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
cn=newSqlConnection(strconn);
if(!IsPostBack)
Bindgrid();
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
InitializeComponent();
base.OnInit(e);
}
privatevoidInitializeComponent()
{
this.Lbtn_addclass.Click+=newSystem.EventHandler(this.Lbtn_addclass_Click);
this.Lbtn_addteacher.Click+=newSystem.EventHandler(this.Lbtn_addteacher_Click);
this.Lbtn_course.Click+=newSystem.EventHandler(this.Lbtn_course_Click);
this.Lbtn_sortcourse.Click+=newSystem.EventHandler(this.Lbtn_sortcourse_Click);
this.Lbtn_grade.Click+=newSystem.EventHandler(this.Lbtn_grade_Click);
this.Btn_search.Click+=newSystem.EventHandler(this.Btn_search_Click);
this.Btn_ok.Click+=newSystem.EventHandler(this.Btn_ok_Click);
this.Lbtn_add.Click+=newSystem.EventHandler(this.Lbtn_add_Click);
this.Btn_all.Click+=newSystem.EventHandler(this.Btn_all_Click);
this.Btn_exit.Click+=newSystem.EventHandler(this.Btn_exit_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
privatevoidBtn_search_Click(objectsender,System.EventArgse)
{
Pnl_sort.Visible=true;
}
privatevoidBtn_all_Click(objectsender,System.EventArgse)
{
Pnl_sort.Visible=false;
Bindgrid();
}
publicvoidDataGrid_Page(objectsender,DataGridPageChangedEventArgse)
{
Dgd_student.CurrentPageIndex=e.NewPageIndex;
Bindgrid();
}
publicvoidDataGrid_cancel(objectsender,DataGridCommandEventArgse)
{
Dgd_student.EditItemIndex=-1;
Bindgrid();
}
publicvoidDataGrid_edit(objectsender,DataGridCommandEventArgse)
{
Dgd_student.EditItemIndex=(int)e.Item.ItemIndex;
Bindgrid();
}
publicvoidDataGrid_update(objectsender,DataGridCommandEventArgse)
{
stringstrsql="updatestudentsetStudent_name=@Student_name,Student_sex=@Student_sex,Student_nation=@Student_nation,Student_birthday=@Student_birthday,Student_time=@Student_time,Student_classid=@Student_classid,Student_home=@Student_home,Student_else=@Student_elsewhereStudent_id=@Student_id";
SqlCommandcm=newSqlCommand(strsql,cn);
try
{
cm.Parameters.Add(newSqlParameter("@Student_name",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Student_sex",SqlDbType.Char,10));
cm.Parameters.Add(newSqlParameter("@Student_nation",SqlDbType.Char,10));
cm.Parameters.Add(newSqlParameter("@Student_birthday",SqlDbType.DateTime,8));
cm.Parameters.Add(newSqlParameter("@Student_time",SqlDbType.DateTime,8));
cm.Parameters.Add(newSqlParameter("@Student_classid",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Student_home",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Student_else",SqlDbType.VarChar,50));
cm.Parameters.Add(newSqlParameter("@Student_id",SqlDbType.VarChar,50));
stringcolvalue=((TextBox)e.Item.Cells[1].Controls[0])
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
ASP小区停车管理系统(Access)(含录像)