.Text;
cm.Parameters["@Student_name"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[2].Controls[0]).Text;
cm.Parameters["@Student_sex"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[3].Controls[0]).Text;
cm.Parameters["@Student_nation"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[4].Controls[0]).Text;
cm.Parameters["@Student_birthday"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[5].Controls[0]).Text;
cm.Parameters["@Student_time"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[6].Controls[0]).Text;
cm.Parameters["@Student_classid"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[7].Controls[0]).Text;
cm.Parameters["@Student_home"].Value=colvalue;
colvalue=((TextBox)e.Item.Cells[8].Controls[0]).Text;
cm.Parameters["@Student_else"].Value=colvalue;
cm.Parameters["@Student_id"].Value=Dgd_student.DataKeys[(int)e.Item.ItemIndex];
cm.Connection.Open();
cm.ExecuteNonQuery();
Lbl_note.Text="编辑成功";
Dgd_student.EditItemIndex=-1;
}
catch
{
Lbl_note.Text="编辑失败,请检查输入!";
Lbl_note.Style["color"]="red";
}
cm.Connection.Close();
Bindgrid();
}
publicvoidDataGrid_delete(objectsender,DataGridCommandEventArgse)
{
stringstrsql="deletefromstudentwhereStudent_id=@userid";
SqlCommandcm=newSqlCommand(strsql,cn);
cm.Parameters.Add(newSqlParameter("@userid",SqlDbType.VarChar,50));
cm.Parameters["@userid"].Value=Dgd_student.DataKeys[(int)e.Item.ItemIndex];
cm.Connection.Open();
try
{
cm.ExecuteNonQuery();
Lbl_note.Text="删除成功";
}
catch(SqlException)
{
Lbl_note.Text="删除失败";
Lbl_note.Style["color"]="red";
}
cm.Connection.Close();
Bindgrid();
}
publicvoidBindgrid()
{ strsql="select*fromstudent";
SqlDataAdapterda=newSqlDataAdapter(strsql,cn);
DataSetds=newDataSet();
da.Fill(ds);
Dgd_student.DataSource=ds;
Dgd_student.DataBind();
}
privatevoidBtn_ok_Click(objectsender,System.EventArgse)
{
strsql="select*fromstudentwhereStudent_id='"+Tbx_sortid.Text+"'orStudent_name='"+Tbx_name.Text+"'";
SqlDataAdapterda=newSqlDataAdapter(strsql,cn);
DataSetds=newDataSet();
da.Fill(ds);
Dgd_student.DataSource=ds;
Dgd_student.DataBind();
}
privatevoidLbtn_course_Click(objectsender,System.EventArgse)
{
Response.Redirect("course.aspx");
}
privatevoidLbtn_sortcourse_Click(objectsender,System.EventArgse)
{
Response.Redirect("student_course.aspx");
}
privatevoidLbtn_add_Click(objectsender,System.EventArgse)
{
Response.Redirect("addstudent.aspx");
}
privatevoidBtn_exit_Click(objectsender,System.EventArgse)
{
Response.Redirect("default.aspx");
}
privatevoidLbtn_grade_Click(objectsender,System.EventArgse)
{
Response.Redirect("grade_manage.aspx");
}
privatevoidLbtn_addclass_Click(objectsender,System.EventArgse)
{
Response.Redirect("classes.aspx");
}
privatevoidLbtn_addteacher_Click(objectsender,System.EventArgse)
{
Response.Redirect("teacher.aspx");
}
privatevoidLbtn_student_Click(objectsender,System.EventArgse)
{
Response.Redirect("student.aspx");
}
}
}
8.3学生信息添加页面
学生信息添加页面主要负责往数据库里添加数据。后台支持事件主要为Btn_ok_Click()事件负责当用户单击"确定"按钮后的数据库添加操作。利用RequiredFieldValidator控件可以用来验证用户输入信息是否为空。若输入学号存在,利用CustomValidator验证控件,触发ServerValidator事件,判断是否存在此学号的学生。"重置"按钮的click事件将完成刷新此页面的功能。
代码如下:
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
{
///
///addstudent的摘要说明。
///
publicclassaddstudent:System.Web.UI.Page
{
protectedSystem.Web.UI.WebControls.TextBoxTbx_id;
protectedSystem.Web.UI.WebControls.TextBoxTbx_name;
protectedSystem.Web.UI.WebControls.TextBoxTbx_nation;
protectedSystem.Web.UI.WebControls.TextBoxTbx_birthday;
protectedSystem.Web.UI.WebControls.TextBoxTbx_time;
protectedSystem.Web.UI.WebControls.TextBoxTbx_home;
protectedSystem.Web.UI.WebControls.TextBoxTbx_else;
protectedSystem.Web.UI.WebControls.DropDownListDdl_sex;
protectedSystem.Web.UI.WebControls.ButtonBtn_ok;
protectedSystem.Web.UI.WebControls.CustomValidatorCv_id;
protectedSystem.Web.UI.WebControls.LabelLbl_note;
protectedSystem.Web.UI.WebControls.ButtonBtn_reset;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_name;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_id;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_nation;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_birthday;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_time;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_class;
protectedSystem.Web.UI.WebControls.RequiredFieldValidatorRfv_home;
protectedSystem.Web.UI.WebControls.DropDownListDdl_class;
SqlConnectioncn;
privatevoidPage_Load(objectsender,System.EventArgse)
{//班级名称下拉列表框绑定
stringstrconn=ConfigurationSettings.AppSettings["dsn"];
SqlConnectioncn0=newSqlConnection(strconn);
if(!IsPostBack)
{
cn0.Open();
stringmysql="select*fromclass";
SqlCommandcm1=newSqlCommand(mysql,cn0);
SqlDataReaderdr1=cm1.ExecuteReader();
while(dr1.Read())
{
Ddl_class.Items.Add(newListItem(dr1["Class_name"].ToString(),dr1["Class_id"].ToString()));
}
cn0.Close();
}
//在此处放置用户代码以初始化页面
cn=newSqlConnection(strco
上一篇:
ASP_net002企业投资价值分析系统(论文和程序)
下一篇:
多年来只想说一句,我不怪你