not able to read data from d/b during pageload using ado.net

See more:

ASP.NET

Javascript

SQL-Server

, +

Hi,

I need to read data from row of two different tables and need to display them in label control during page load.
I have given the SQL DATASOURCE, but it's not happening.

Can someone please suggest me what exactly the problem is. I am new to ADO.NET

Below is the code:

public void Page_Load(object sender, EventArgs e)
{
                SqlConnection con = new SqlConnection("my connectionstring name");
               SqlCommand cmd = new SqlCommand("SELECT username,u_fname,u_lname,u_password,u_email_id FROM users_detail", con);
                SqlCommand cmd1 = new SqlCommand("SELECT u_sec_qst,u_sec_ans FROM u_security", con);

                try
                {
                    con.Open();
                    SqlDataReader reader = cmd.ExecuteReader();

                    while (reader.Read())
                    {
                        mem_username.Text = reader.Read().ToString();
                        mem_fname.Text = reader.Read().ToString();
                        mem_lname.Text = reader.Read().ToString();
                        mem_pass.Text = reader.Read().ToString();
                        mem_email_id.Text = reader.Read().ToString();
                       
                       reader.Close();
                    }
                }

                catch (SqlException ex)
                {
                    string Label2 = "Sorry!! an Error Occured : " + ex.Message;
                }
                finally
                {
                    con.Close();
                }

                try
                {
                    con.Open();
                    SqlDataReader reader1 = cmd1.ExecuteReader();

                    mem_sec_qst.Text = reader1.Read().ToString();
                    mem_sec_ans.Text = reader1.Read().ToString();

                    reader1.Close();
                }
                catch (SqlException ex1)
                {
                    string Label2 = "Sorry!! an Error Occured : " + ex1.Message;
                }
                finally
                {
                    con.Close();
                }
}

Thanks in advance...