//初始化考试科目
protected void InitData()
{
Coursemr course = new Coursemr(); //创建考试科目对象
DataSet ds = course.QueryCourse(); //查询考试科目信息
GridView1.DataSource = ds; //为GridView控件设置数据源
GridView1.DataBind(); //绑定数据
}
//初始化考试科目
protected void InitDDLData()
{
Coursemr course = new Coursemr(); //创建考试科目对象
DataSet ds = course.QueryCourse(); //查询考试科目信息
ddlCourse.DataSource = ds; //指名考试科目列表框数据源
ddlCourse.DataTextField = "Name"; //DataTextField显示Name字段值
ddlCourse.DataValueField = "ID"; //DataValueField显示ID字段值
ddlCourse.DataBind(); //绑定数据
}
//删除考试科目事件
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Coursemr course = new Coursemr(); //创建Coursemr对象
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
if (course.DeleteByStr(ID))
{
Response.Write("<script language=javascript>alert('成功删除考试科目！')</script>");
}
else
{
Response.Write("<script language=javascript>alert('删除考试科目失败！')</script>");
}
GridView1.EditIndex = -1;
InitData();
}
//初始化考试科目
protected void PaperData()
{
//实例化考试科目对象Coursemr
Coursemr papercs = new Coursemr();
//调用Coursemr公共类中SqlQueryCourse()来查询考试科目信息并保存在创建一个DataSet对象ds中
DataSet ds = papercs.QueryCourse();
//设置考试科目列表框的数据源
MyddlCourse.DataSource = ds;
//DataTextField显示Name字段值
MyddlCourse.DataTextField = "Name";
//DataValueField显示ID字段值
MyddlCourse.DataValueField = "ID";
//绑定数据
MyddlCourse.DataBind();
}
//GridView控件RowUpdating事件
protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //取出要删除记录的主键值
Coursemr course = new Coursemr(); //创建Coursemr对象
course.Name = ((TextBox)GridView1.Rows[e.RowIndex].FindControl("txtName")).Text;
if (course.UpdateByStr(ID))//使用Usersmr类UpdateByProc方法修改用户信息
{
Response.Write("<script language=javascript>alert('修改成功!')</script>");
}
else
{
Response.Write("<script language=javascript>alert('修改失败!')</script>");
}
GridView1.EditIndex = -1;
InitData();
}
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
Coursemr course = new Coursemr(); //创建考试科目对象
course.Name = txtName.Text; //设置考试科目对象属性
if (course.InsertByStr()) //调用添加考试科目方法添加考试科目
{
lblMessage.Text = "成功添加该考试科目！";
txtName.Text = "";
}
else
{
lblMessage.Text = "添加该考试科目失败！";
}
}
}
