output query results in html
<p>i query a database for retreiving all the columns. I will probably have many rows. Im trying to output the query results into an html table. This is what i have so far:</p>

<pre><code>    protected void Page_Load(Object sender, EventArgs E)
    {
        message.Text = "Welcome to your profile: " + CUser.LoginID;
        System.Data.SqlClient.SqlConnection con;
        con = new System.Data.SqlClient.SqlConnection();
        con.ConnectionString = "Data Source=.\\SQLEXPRESS; AttachDbFilename=C:\\Users\\jjj\\Documents\\Visual Studio 2010\\Projects\\App_Data\\data.mdf; Integrated Security = true; Connect Timeout = 30; User Instance = True";
        string id = CUser.LoginID;
        try
        {
            con.Open();

            SqlCommand cmd = new SqlCommand("SELECT * FROM tbl WHERE loginID = 'hussein' ", con);
            SqlDataReader reader =cmd.ExecuteReader();
                if (reader.HasRows) {
                    //reader.Read();
                    while (reader.Read())
                    {


                    } 
                } 
        }

        catch { }

        finally
        {
            con.Close();
        } 
}
</code></pre>

<p>How could i store the many rows and output them using html as soon as i open a page? Im using C#</p>
