Comments by Member 12049271 (Top 2 by date)

I'm not using DataTable instead i have used SqlReader to read from my database

My Code is as follows...

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["HousingConnectionString"].ConnectionString);
SqlCommand com = new SqlCommand("Select First_Name , Middle_Name , Last_Name , Mobile_No , Email, DOB , Age , Education , Office_Add , Native_Add , PAN_Card , Aadhar_Card , Religion , Business_Job , Married_Unmarried , No_Of_Members from Primary_Member where Flat = '" + Request.QueryString["fnum"] + "'", conn);
conn.Open();
SqlDataReader dr = com.ExecuteReader();
if (dr.Read())
{
TextBoxFN.Text = dr["First_Name"].ToString();
TextBoxMN.Text = dr["Middle_Name"].ToString();
TextBoxLN.Text = dr["Last_Name"].ToString();
TextBoxMO.Text = dr["Mobile_No"].ToString();
TextBoxE.Text = dr["Email"].ToString();
TextBoxDOB.Text = dr["DOB"].ToString();
TextBoxA.Text = dr["Age"].ToString();
TextBoxEQ.Text = dr["Education"].ToString();
TextBoxOA.Text = dr["Office_Add"].ToString();
TextBoxNA.Text = dr["Native_Add"].ToString();
TextBoxPCN.Text = dr["PAN_Card"].ToString();
TextBoxACN.Text = dr["Aadhar_Card"].ToString();
TextBoxR.Text = dr["Religion"].ToString();
TextBoxNOM.Text = dr["No_Of_Members"].ToString();

dr.Close();
conn.Close();
}

I have two Radio Buttons one for Married and another for unmarried...