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