//ɾ�������¼�
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
SingleProblemmr singleproblem = new SingleProblemmr(); //������ѡ�����
int ID = int.Parse(GridView1.DataKeys[e.RowIndex].Values[0].ToString()); //ȡ��Ҫɾ����¼������ֵ
if (singleproblem.DeleteByStr(ID))
{
Response.Write("<script language=javascript>alert('�ɹ�ɾ�����⣡')</script>");
}
else
{
Response.Write("<script language=javascript>alert('ɾ������ʧ�ܣ�')</script>");
}
GridView1.EditIndex = -1;
GridViewBind();//���°�����
}
//��ʼ������
protected void InitData()
{
int SingleProblemID = int.Parse(Request["ID"].ToString()); //ȡ�����ݹ�����������
SingleProblemmr singleproblem = new SingleProblemmr(); //������ѡ�����
if (singleproblem.LoadData(SingleProblemID)) //���ȡ����Ŀ��Ϣ���ֱ������Ӧ�ؼ���ʾ
{
ddlCourse.SelectedValue = singleproblem.CourseID.ToString();
txtTitle.Text = singleproblem.Title;
txtAnswerA.Text = singleproblem.AnswerA;
txtAnswerB.Text = singleproblem.AnswerB;
txtAnswerC.Text = singleproblem.AnswerC;
txtAnswerD.Text = singleproblem.AnswerD;
ddlAnswer.SelectedItem.Text = singleproblem.Answer;
}
else //��ѯ�����������ʾ
{
lblMessage.Text = "�������ݳ����";
}
}
//��ӻ����¼�
protected void imgBtnSave_Click(object sender, ImageClickEventArgs e)
{
if (Page.IsValid)
{
SingleProblemmr singleproblem = new SingleProblemmr(); //������ѡ�����
singleproblem.CourseID = int.Parse(ddlCourse.SelectedValue);//Ϊ��ѡ���������Ը�ֵ
singleproblem.Title = txtTitle.Text;
singleproblem.AnswerA = txtAnswerA.Text;
singleproblem.AnswerB = txtAnswerB.Text;
singleproblem.AnswerC = txtAnswerC.Text;
singleproblem.AnswerD = txtAnswerD.Text;
singleproblem.Answer = ddlAnswer.SelectedItem.Text;
if (Request["ID"] != null) //���������Ŀ��Ϣ
{
singleproblem.ID = int.Parse(Request["ID"].ToString()); //ȡ����������
if (singleproblem.UpdateByStr(int.Parse(Request["ID"].ToString())))//���������ⷽ��������
{
lblMessage.Text = "�ɹ��ĸõ�ѡ�⣡";
}
else
{
lblMessage.Text = "�ĸõ�ѡ��ʧ�ܣ�";
}
}
else //������������
{
if (singleproblem.InsertByStr()) //����������ⷽ���������
{
lblMessage.Text = "�ɹ���Ӹõ�ѡ�⣡";
}
else
{
lblMessage.Text = "��Ӹõ�ѡ��ʧ�ܣ�";
}
}
}
}
//ɾ��������¼
protected void ImageButton1_Click(object sender, ImageClickEventArgs e)
{
SingleProblemmr single = new SingleProblemmr();//����SingleProblemmr����
foreach (GridViewRow dr in GridView1.Rows)//��GridView�е�ÿһ�н����ж�
{
if (((CheckBox)dr.FindControl("xuanze")).Checked)//���ѡ���˽���ɾ��
{
int ID = int.Parse(((Label)dr.FindControl("Label1")).Text);
single.ID = ID;
single.DeleteByStr(ID);
}
}
}
//GridView�ؼ��������¼�
protected void GridViewBind()
{
SingleProblemmr singleproblem = new SingleProblemmr(); //������ѡ�����
DataSet ds = singleproblem.QuerySingleProblem(int.Parse(ddlCourse.SelectedValue));//���ݿ��Կ�Ŀ��ѯ��ѡ����Ϣ
GridView1.DataSource = ds.Tables[0].DefaultView; //ΪGridView�ؼ�ָ������Դ
GridView1.DataBind(); //������
}
