@kalpesh
private void GetCurrentQuestion(int questionId, DataTable dtQuestions)
{
if (QuestionId <= dtQuestions.Rows.Count)
{
lblQuestion.Text = dtQuestions.Rows[questionId - 1]["QuestionDescription"].ToString();
DataTable dtOptions = PopulateOptions(questionId);
List<ListItem> options = new List<ListItem>();
for (int i = 0; i < dtOptions.Rows.Count; i++)
{
options.AddRange(new ListItem[] { new ListItem(dtOptions.Rows[i][1].ToString(), i.ToString()) });
}
rbtnOptions.Items.Clear();
rbtnOptions.Items.AddRange(options.ToArray());
rbtnOptions.DataBind();
}
else
{
dvQuestion.Visible = false;
dvResult.Visible = true;
using (SqlConnection con = new SqlConnection(ConString))
{
using (SqlCommand cmd = new SqlCommand("insert INTO resulttable", con))
{
//i'm struck here
}
lblResult.Text = string.Format("You Scored {0}/{1}", Score, QuestionId - 1);
}
}
}