*************** coding of retrieving values from table***********************
private void buttonnext_Click(object sender, EventArgs e)
{
this.BindingContext[ds.Tables[0]].Position -= 1;
con.Open();
SqlDataAdapter Adpt = new SqlDataAdapter("Select user_ans from MyNewSet where que_no= '" + label2.Text + "'", con);
Adpt.Fill(ds);
DataTable dt = ds.Tables[0];
try
{
if ((dt.Rows[0][2]).ToString().Equals((dt.Rows[0][7]).ToString()))
{
radioButton1.Checked = true;
}
if ((dt.Rows[0][3]).ToString().Equals((dt.Rows[0][7]).ToString()))
{
radioButton2.Checked = true;
}
if ((dt.Rows[0][4]).ToString().Equals((dt.Rows[0][7]).ToString()))
{
radioButton3.Checked = true;
}
if ((dt.Rows[0][5]).ToString().Equals((dt.Rows[0][7]).ToString()))
{
radioButton4.Checked = true;
}
}
catch(Exception)
{
}
con.Close();
}
Nileshkhochare, if this helps please login to Mark As Answer. | Alert Moderator