河北联大教务管理系统(7)

河北联合大学软件实训 第 18 页 共 30 页

{

string strsql=%users,teacher where users.User_id=teacher.Teacher_id\; DataAs = new DataAccess();

DataTable DT = DataAs.CreateDatatable(strsql);

}

GridView1.DataSource=DT;

GridView1.DataBind();

protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e) {

GridView1.PageIndex = e.NewPageIndex; Bindgrid(); }

protected void GridView1_RowCancelingEdit(object sender, GridViewCancelEditEventArgs e) {

GridView1.EditIndex = -1; Bindgrid(); }

protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e) {

string strsql = \ + GridView1.DataKeys[e.RowIndex].Value.ToString() + \; DataAs = new DataAccess();

bool Result = DataAs.ExecSql(strsql); if (Result) {

Lbl_show.Text = \删除成功\;

} else {

Lbl_show.Text = \删除失败\;

Lbl_show.Style[\] = \; }

Bindgrid(); }

protected void GridView1_RowEditing(object sender, GridViewEditEventArgs e) {

GridView1.EditIndex = e.NewEditIndex; Bindgrid();

18

河北联合大学软件实训 第 19 页 共 30 页

}

protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) {

GridViewRow gvr = GridView1.Rows[e.RowIndex]; string strsql = \ + ((TextBox)gvr.Cells[5].Controls[0]).Text + \ + GridView1.DataKeys[e.RowIndex].Value.ToString() + \; DataAs = new DataAccess();

bool Result = DataAs.ExecSql(strsql); if (Result) {

Lbl_show.Text = \编辑成功\; GridView1.EditIndex = -1; } else {

Lbl_show.Text = \编辑失败，请检查输入！\; Lbl_show.Style[\] = \; }

Bindgrid(); }

3）成绩录入界面代码：

protected void Btn_add_Click(object sender, System.EventArgs e)

{

string strsql = \Student_grade='\+Tbx_grade.Text+\

Student_id='\+Tbx_studentid.Text+\+

Ddl_course.SelectedItem.Value + \Course_year='\ + Tbx_term.Text+\;

DataAccess DataAs = new DataAccess(); bool Result = DataAs.ExecSql(strsql); if (!Result)

}

protected void Btn_exit_Click(object sender, System.EventArgs e) { }

//Response.Redirect(\{

Lbl_note.Text=\添加失败\;

Lbl_note.Style[\]=\;

}

19

河北联合大学软件实训 第 20 页 共 30 页

private void Cv_id_ServerValidate(object source, {

string strsql=\

System.Web.UI.WebControls.ServerValidateEventArgs args)

Student_id='\+Tbx_studentid.Text+\;

DataAccess DataAs = new DataAccess();

DataTable DT = DataAs.CreateDatatable(strsql);

}

protected void Tbx_studentid_TextChanged(object sender, {

if(DT.Rows.Count>0) { } else {

args.IsValid=false; }

args.IsValid=true;

System.EventArgs e)

//课程名称下拉列表框绑定 string mysql1=\course.* from student_course,course where student_course.Student_id='\+Tbx_studentid.Text+\student_course.Course_id=course.Course_id\;

DataAccess DataAs = new DataAccess();

DataTable DT = DataAs.CreateDatatable(mysql1); for (int i = 0; i < DT.Rows.Count;i++ ) {

Ddl_course.Items.Add(new

ListItem(DT.Rows[i][1].ToString(),DT.Rows[i][0].ToString())); } }

4）添加课程信息界面代码：

private void Cv_id_ServerValidate(object source,

System.Web.UI.WebControls.ServerValidateEventArgs args)

{

string strsql =\

Course_id='\+Tbx_id.Text+\;

DataAccess DataAs = new DataAccess();

DataTable DT = DataAs.CreateDatatable(strsql);

if( DT.Rows.Count != 0) { } else

args.IsValid=false;

20

河北联合大学软件实训 第 21 页 共 30 页

}

protected void Btn_ok_Click(object sender, System.EventArgs e) {

{ }

args.IsValid=true;

string strsql = \

course(Course_id,Course_name,Course_period,Course_credit,Course_kind,Course_describe) values('\ +

Tbx_id.Text + \ + Tbx_name.Text + \ + Tbx_period.Text + \ + Tbx_credit.Text + \ +

Ddl_kind.SelectedItem.Value + \ + Tbx_else.Text + \;

DataAccess DataAs = new DataAccess();

bool Result = DataAs.ExecSql(strsql); if (Result)

}

protected void Btn_reset_Click(object sender, System.EventArgs e) { }

Response.Redirect(\); { } else {

}

Lbl_remind.Text=\添加失败,请检查输入数据！\; Lbl_remind.Style[\]=\; Response.Redirect(\);

5）添加学生信息界面代码：

public partial class addstudent : System.Web.UI.Page

{

protected void Page_Load(object sender, System.EventArgs e) {//班级名称下拉列 …… 此处隐藏：2816字，全部文档内容请下载后查看。喜欢就下载吧 ……