Hi Ali
for (int cellIndex = 0; cellIndex < GridView1.Rows.Count; cellIndex++)
{
GridViewRow row = GridView1.Rows[cellIndex];
int questionNumber = Convert.ToInt32(cellIndex + 1);
RadioButtonList lst = ((RadioButtonList)row.FindControl("RadioButtonList1")) as RadioButtonList;
string answer = (lst != null) ? lst.SelectedValue.ToString() : String.Empty;
values.Add(questionNumber, answer);
IFormatProvider culture = new CultureInfo("fr-Fr", true);
string constr1;
constr1 = ConfigurationManager.ConnectionStrings["constr"].ConnectionString;
con = new SqlConnection(constr1);
con.Open();
string sql = "SELECT * FROM paper where qno="+ questionNumber +"";
cmd = new SqlCommand(sql, con);
rd = cmd.ExecuteReader();
if (rd.Read())
{
int ransid = Convert.ToInt32(rd.GetValue(9).ToString());
if (answer == "N/A")
{
nanswer = nanswer + 1;
lblnotanswered.Text = Convert.ToString(nanswer);
}
else if (Convert.ToInt32(answer)==ransid)
{
total = total + 1;
lbltotalmarks.Text = Convert.ToString(total);
}
else
{
wanswer = wanswer + 1;
lblwronanswer.Text = Convert.ToString(wanswer);
}
}
}
Thanks & Regard's
Prabhakar
Best Regard's
Prabhakar
Ali, if this helps please login to Mark As Answer. | Alert Moderator