Not able to display data with label control

Posted 04 April 2012 - 01:54 AM

hi!! i need to display data from database into a label control, but no datais displaying.... i don't know what the problem is

below is the code....

using System;
using System.Collections.Generic;
using System.Linq;
using System.Web;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Data.SqlClient;
using System.Data;
using memberdll;

public partial class account_profile : System.Web.UI.Page
{

    public void Page_Load(object sender, EventArgs e)
    {

        if (!Page.IsPostBack)
        {

            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);
          
            try
            {

                con.Open();

                SqlDataReader reader = cmd.ExecuteReader();


                DataSet ds = new DataSet();

                SqlDataAdapter da = new SqlDataAdapter(cmd);
                da.Fill(ds);



                while (reader.Read())
                {

                    ////Label mem_username = new Label();
                    //Label mem_fname = new Label();
                    //Label mem_lname = new Label();
                    //Label mem_pass = new Label();
                    //Label mem_email_id = new Label();


                    //string u = reader.GetValue(0).ToString();
                    //string fn = reader.GetValue(0).ToString();
                    //string ln = reader.GetValue(0).ToString();
                    //string pass = reader.GetValue(0).ToString();
                    //string email = reader.GetValue(0).ToString();

                    DataTable dt = new DataTable();



                    mem_username.Text = dt.Rows[0]["username"].ToString();
                    mem_lname.Text = dt.Rows[0]["u_fname"].ToString();
                    mem_pass.Text = dt.Rows[0]["u_lname"].ToString();
                    mem_email_id.Text = dt.Rows[0]["u_email_id"].ToString();

                    reader.Close();
                }


            }

            catch (SqlException ex)
            {

                con.Close();

                Label messbox = new Label();

                string a = "Sorry!! an Error Occured : " + ex.Message;
                messbox.Text = a;

            }

            try
            {
                SqlCommand cmd1 = new SqlCommand("SELECT u_sec_qst,u_sec_ans FROM u_security", con);


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


                while (reader1.Read())
                {
                    //Label mem_sec_qst = new Label();
                    //Label mem_sec_ans = new Label();

             
                    SqlDataReader reader = cmd1.ExecuteReader();


                    DataSet ds = new DataSet();

                    SqlDataAdapter da = new SqlDataAdapter(cmd1);
                    da.Fill(ds);



                    DataTable dt = new DataTable();

                    mem_sec_qst.Text = dt.Rows[0]["username"].ToString();
                    mem_sec_ans.Text = dt.Rows[0]["username"].ToString();


                    reader1.Close();
                }
            }

            catch (SqlException ex1)
            {
                Label messbox1 = new Label();


                con.Close();

                string a = "Error : " + ex1.Message;
                messbox1.Text = a;


            }
        }

        else
        {
        
        errorsss.Text = "errors";
        }
    }
}

these data are of member's detail's and i need to display on page load..... but it's not displaying any data

can someone please help me...

Thank's in advance..

This post has been edited by Dormilich: 04 April 2012 - 01:55 AM
Reason for edit:: please use [code] [/code] tags when posting code