//-----------------------------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);
}
}
