//-----------------------------Looping SOAL------------------------------- public void tSoal() { ss = 5; SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DB_SHE"].ConnectionString); Btn_Submit.Visible = false; s_int_nomor_x = Convert.ToInt32(LblIdSoal.Text); try { SqlCommand cmdSoal = new SqlCommand("cusp_Tampil_Soal_ByNomor", con); cmdSoal.CommandType = CommandType.StoredProcedure; cmdSoal.Parameters.AddWithValue("@nomor", s_int_nomor_x); cmdSoal.Parameters.AddWithValue("@generatedID", Session["i_str_generatedID"].ToString()); LblGenerateID.Text = Session["i_str_generatedID"].ToString(); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr_soal = cmdSoal.ExecuteReader(); while (dr_soal.Read()) { nosoal = dr_soal["id_soal"].ToString(); tekssoal = dr_soal["deskripsi_soal"].ToString(); LblIdSoal.Text = dr_soal["id_soal"].ToString(); imagename = dr_soal["image_url"].ToString(); } Image1.DataBind(); con.Close(); Lbl_Soal.Text = tekssoal; LblURL.Text = imagename; SqlDataSource1.DataBind(); Rbl_jawabanA.DataBind(); //------------ mengambil nomor urut ---------------------------------------------------------------------- if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmdNomorSoal = new SqlCommand("dbo.cusp_Tampil_Soal_Row_Number", con); cmdNomorSoal.CommandType = CommandType.StoredProcedure; cmdNomorSoal.Parameters.AddWithValue("@id_soal", nosoal); SqlDataReader dr_nomor = cmdNomorSoal.ExecuteReader(); while (dr_nomor.Read()) { nomorsoal = dr_nomor["nomor"].ToString(); } con.Close(); } catch (Exception ex) { Response.Write(ex.Message); } Btn_AnswerKey.Visible = true; }
public void Btn_Submit_Click(object sender, EventArgs e) { ss = 10; SqlConnection con = new SqlConnection(System.Configuration.ConfigurationManager.ConnectionStrings["DB_SHE"].ConnectionString); s_int_nomor_x = 0; s_int_nomor_x = Convert.ToInt32(LblIdSoal.Text.ToString()); try { SqlCommand cmdSoal = new SqlCommand("cusp_Tampil_Soal_ByNomor", con); cmdSoal.CommandType = CommandType.StoredProcedure; cmdSoal.Parameters.AddWithValue("@nomor", s_int_nomor_x); cmdSoal.Parameters.AddWithValue("@generatedID", Session["i_str_generatedID"].ToString()); LblGenerateID.Text = Session["i_str_generatedID"].ToString(); if (con.State == ConnectionState.Closed) { con.Open(); } SqlDataReader dr_soal = cmdSoal.ExecuteReader(); while (dr_soal.Read()) { nosoal = dr_soal["id_soal"].ToString(); tekssoal = dr_soal["deskripsi_soal"].ToString(); LblIdSoal.Text = dr_soal["id_soal"].ToString(); } con.Close(); Lbl_Soal.Text = tekssoal; SqlDataSource1.DataBind(); Rbl_jawabanA.DataBind(); //------------ mengambil nomor urut ---------------------------------------------------------------------- if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmdNomorSoal = new SqlCommand("dbo.cusp_Tampil_Soal_Row_Number", con); cmdNomorSoal.CommandType = CommandType.StoredProcedure; cmdNomorSoal.Parameters.AddWithValue("@id_soal", nosoal); SqlDataReader dr_nomor = cmdNomorSoal.ExecuteReader(); while (dr_nomor.Read()) { nomorsoal = dr_nomor["nomor"].ToString(); } con.Close(); //---------------- menampilkan gambar soal ------------------------------------------------------------- if (con.State == ConnectionState.Closed) { con.Open(); } SqlCommand cmdGambarSoal = new SqlCommand("dbo.cusp_Tampil_SoalGambar_ByIdSoal", con); cmdGambarSoal.CommandType = CommandType.StoredProcedure; cmdGambarSoal.Parameters.AddWithValue("@id_soal", nosoal); con.Open(); SqlDataAdapter sda = new SqlDataAdapter(); sda.SelectCommand = cmdGambarSoal; DataSet ds = new DataSet(); sda.Fill(ds); Image1.DataBind(); SqlDataReader drGambar = cmdGambarSoal.ExecuteReader(); while (drGambar.Read()) { imagename = drGambar["name"].ToString(); } con.Close(); LblURL.Text = imagename.ToString(); Btn_AnswerKey.Visible = true; Response.Redirect("Tampil.aspx?s_str_generatedID=" + Session["i_str_generatedID"] + "&no=" + nosoal + "&soalnya=" + tekssoal + "&nomornya=" + nomorsoal + "&gambarnya=" + imagename); } catch (Exception ex) { Response.Write(ex.Message); } }