Retrieve tabledata from sqllite database and must display in html page in visualstudio

Hi,
Create html form.And place asp label controls.
   
   
       
           
       
       
           
       
       
           
       
       
           
       
   



ANd retrieve the values from database Like this:

   string selectquery = "";
        selectquery = "select RID, UserName, Email_Id, CONVERT(varchar, DOB, 103) AS DOB, CONVERT(varchar, DOJ, 103) AS DOJ, State, Pin_Code FROM  Registration where RID=" + hdnvalue;
        SqlConnection sqlcon = new SqlConnection(ConfigurationManager.AppSettings["SqlServer"]);

        SqlCommand sqlcomm = new SqlCommand();
        sqlcomm = sqlcon.CreateCommand();
        sqlcomm.CommandType = CommandType.Text;
        sqlcomm.CommandText = selectquery;
        sqlcon.Open();
        SqlDataReader sqlred = null;
        sqlred = sqlcomm.ExecuteReader();

        if (sqlred.Read())
        {
            if (sqlred["UserName"] != null)
            {
                Label1.Text = sqlred["UserName"].ToString();
            }
            if (sqlred["Email_Id"] != null)
            {
                Label2.Text = sqlred["Email_Id"].ToString();
            }
            if (sqlred["DOB"] != null)
            {
                Label3.Text = sqlred["DOB"].ToString();
            }
            if (sqlred["DOJ"] != null)
            {
                Label4.Text = sqlred["DOJ"].ToString();
            }
        }
        sqlcomm.Dispose();
        sqlcon.Close();


finally redirect to this html form page...

server.transfer("htmlcontent.aspx");

I hope it help you......