using System;
using System.Collections;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Web;
using System.Web.SessionState;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.HtmlControls;
using System.Data.OleDb;

namespace HoangYuh
{

    public class _Default : System.Web.UI.Page
    {
        protected System.Web.UI.WebControls.Label lblNotice;
        protected System.Web.UI.WebControls.Label lblName;
        protected System.Web.UI.WebControls.Label lblNameList;
        protected System.Web.UI.WebControls.Label lblPostCount;
        protected System.Web.UI.WebControls.Label Label1;
        protected System.Web.UI.WebControls.Button btnForum;

        private void Page_Load(object sender, System.EventArgs e)
        {
            OleDbConnection conForum;
            OleDbCommand cmdRead;
            OleDbDataReader dtrRead;
            conForum = new OleDbConnection(@"PROVIDER=Microsoft.Jet.OLEDB.4.0 ;DATA Source=myForum\db\FORUM.mdb");
            cmdRead = new OleDbCommand("SELECT UserName,PostsCount FROM Users",conForum);
            conForum.Open();
            dtrRead = cmdRead.ExecuteReader();

            while(dtrRead.Read())
            {
                lblName.Text = "<LI type=1>" + dtrRead["UserName"] + "</LI>";
                lblPostCount.Text = dtrRead["PostsCount"] + "<BR>";
            }
            dtrRead.Close();
            conForum.Close();


            }

        #region Web Form Designer generated code
        override protected void OnInit(EventArgs e)
        {
            //
            // CODEGEN: This call is required by the ASP.NET Web Form Designer.
            //
            InitializeComponent();
            base.OnInit(e);
        }

        /// <summary>
        /// Required method for Designer support - do not modify
        /// the contents of this method with the code editor.
        /// </summary>
        private void InitializeComponent()
        {
            this.btnForum.Click += new System.EventHandler(this.btnForum_Click);
            this.Load += new System.EventHandler(this.Page_Load);

        }
        #endregion

        private void btnForum_Click(object sender, System.EventArgs e)
        {
            Response.Redirect(@"myForum\Default.aspx");
        }

    }
}
---------------------------------------------------------------------
Here is the source code. I am unable to display the file at label. Is it the problem of path?(I am not sure).

Any help would appreciated.



Goh Hoang Yuh
- C# Beginner in ASP.NET

Hello,

Did you test to see if the problem is that no records are being returned? Is the page loading ok, just nothing being assigned to the label? Also, I think when piecing the fields to the string, you need the ToString(): dr["field"].ToString() to get the string. And, for the label, you have to do +=, not =:
lblName.Text += dr["field"].ToString()

The last value currently overwrites all the text, which the last field could be blank and that is why you are having a problem.

Brian

Oh thanks, but at last i recover that the main problem is the code
<%@ Page language="c#" Codebehind="Default.aspx.cs" AutoEventWireup="false" Inherits="HoangYuh._Default" %>
is missing on my Default.aspx, i think this is the main problem to make all my database read nothing and button doesn't redirect.
Thanks anyway.

Goh Hoang Yuh
- C# Beginner in ASP.NET

That would be a problem, yes.

Brian