化页面
cn=newSqlConnection(strconn);
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
privatevoidInitializeComponent()
{
this.Cv_id.ServerValidate+=newSystem.Web.UI.WebControls.ServerValidateEventHandler(this.Cv_id_ServerValidate);
this.Btn_ok.Click+=newSystem.EventHandler(this.Btn_ok_Click);
this.Btn_reset.Click+=newSystem.EventHandler(this.Btn_reset_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
privatevoidBtn_ok_Click(objectsender,System.EventArgse)
{
SqlCommandcm=newSqlCommand("insert_student_1",cn);
cm.CommandType=CommandType.StoredProcedure;
try
{
cm.Parameters.Add(newSqlParameter("@Student_id",SqlDbType.VarChar,50));
cm.Parameters["@Student_id"].Value=Tbx_id.Text;
cm.Parameters.Add(newSqlParameter("@Student_name",SqlDbType.VarChar,50));
cm.Parameters["@Student_name"].Value=Tbx_name.Text;
cm.Parameters.Add(newSqlParameter("@Student_sex",SqlDbType.Char,10));
cm.Parameters["@Student_sex"].Value=Ddl_sex.SelectedItem.Value;
cm.Parameters.Add(newSqlParameter("@Student_nation",SqlDbType.Char,10));
cm.Parameters["@Student_nation"].Value=Tbx_nation.Text;
cm.Parameters.Add(newSqlParameter("@Student_birthday",SqlDbType.DateTime,8));
cm.Parameters["@Student_birthday"].Value=Tbx_birthday.Text;
cm.Parameters.Add(newSqlParameter("@Student_time",SqlDbType.DateTime,8));
cm.Parameters["@Student_time"].Value=Tbx_time.Text;
cm.Parameters.Add(newSqlParameter("@Student_classid",SqlDbType.VarChar,50));
cm.Parameters["@Student_classid"].Value=Ddl_class.SelectedItem.Value;
cm.Parameters.Add(newSqlParameter("@Student_home",SqlDbType.VarChar,50));
cm.Parameters["@Student_home"].Value=Tbx_home.Text;
cm.Parameters.Add(newSqlParameter("@Student_else",SqlDbType.VarChar,50));
cm.Parameters["@Student_else"].Value=Tbx_else.Text;
cm.Connection.Open();
cm.ExecuteNonQuery();
cm.Connection.Close();
insert();
}
catch
{
Lbl_note.Text="添加失败,请检查输入!";
Lbl_note.Style["color"]="red";
}
}
publicvoidinsert()
{
stringstrsl="insertintousers(User_id,User_password,User_power)values(@User_id,@User_pwd,0)";
SqlCommandcm=newSqlCommand(strsl,cn);
cm.Parameters.Add(newSqlParameter("@User_id",SqlDbType.VarChar,50));
cm.Parameters["@User_id"].Value=Tbx_id.Text;
cm.Parameters.Add(newSqlParameter("@User_pwd",SqlDbType.VarChar,50));
cm.Parameters["@User_pwd"].Value=Tbx_id.Text;
cm.Connection.Open();
try
{
cm.ExecuteNonQuery();
Response.Redirect("student.aspx");
}
catch(SqlException)
{
Lbl_note.Text="添加失败";
Lbl_note.Style["color"]="red";
}
cm.Connection.Close();
}
privatevoidBtn_reset_Click(objectsender,System.EventArgse)
{
Response.Redirect("addstudent.aspx");
}
privatevoidCv_id_ServerValidate(objectsource,System.Web.UI.WebControls.ServerValidateEventArgsargs)
{
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
cn=newSqlConnection(strconn);
cn.Open();
SqlCommandcm=newSqlCommand("select_student_1",cn);
cm.CommandType=CommandType.StoredProcedure;
cm.Parameters.Add("@Student_id",SqlDbType.VarChar,50);
cm.Parameters["@Student_id"].Value=Tbx_id.Text;
SqlDataReaderdr=cm.ExecuteReader();
if(dr.Read())
{
args.IsValid=false;
}
else
{
args.IsValid=true;
}
cn.Close();
}
}
}
8.4课程信息管理页面
课程信息管理页面与学生信息维护页面非常相似,进行DataGrid控件Dgd-course的绑定操作,管理员可以在此页面进行课程信息的编辑和删除。
主要相关代码如下:
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
{
///
///course的摘要说明。
///
publicclasscourse:System.Web.UI.Page
{
SqlConnectioncn;
protectedSystem.Web.UI.WebControls.TextBoxTbx_name;
protectedSystem.Web.UI.WebControls.TextBoxTbx_id;
protectedSystem.Web.UI.WebControls.ButtonBtn_search;
protectedSystem.Web.UI.WebControls.DataGridDgd_course;
protectedSystem.Web.UI.WebControls.LabelLbl_note;
protectedSystem.Web.UI.WebControls.ButtonBtn_exit;
stringstrsql;
privatevoidPage_Load(objectsender,System.EventArgse)
{
//在此处放置用户代码以初始化页面
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
cn=newSqlConnection(strconn);
if(!IsPostBack)
Bindgrid();
}
#regionWebFormDesignergeneratedcode
overrideprotectedvoidOnInit(EventArgse)
{
//
//CODEGEN:该调用是ASP.NETWeb窗体设计器所必需的。
//
InitializeComponent();
base.OnInit(e);
}
///
///设计器支持所需的方法-不要使用代码编辑器修改
///此方法的内容。
///
privatevoidInitializeComponent()
{
this.Btn_search.Click+=newSystem.EventHandler(this.Btn_search_Click);
this.Btn_exit.Click+=newSystem.EventHandler(this.Btn_exit_Click);
this.Load+=newSystem.EventHandler(this.Page_Load);
}
#endregion
publicvoidDataGrid_Page(objectsender,DataGridPageChangedEventArgse)
{
Dgd_course.CurrentPageIndex=e.NewPageIndex;
Bindgrid();
}
publicvoidDataGrid_edit(objectsender,DataGridCommandEventArgse)
{
Dgd_course.EditItemIndex=(int)e.Item.ItemIndex;
Bindgrid();
}
publicvoidDataGrid_cancel(objectsender,DataGridCommandEventArgse)
{
Dgd_course.EditItemIndex=-1;
Bindgrid();
}
publicvoidDataGrid_delete(objectsender,DataGridCommandEventArgse)
{
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
论文参考文献写作格式