C#

private void Page_Load(object sender, System.EventArgs e)<br />
		{<br />
			// Put user code to initialize the page here<br />
<br />
		}<br />
<br />
		#region Web Form Designer generated code<br />
		override protected void OnInit(EventArgs e)<br />
		{<br />
			//<br />
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.<br />
			//<br />
			InitializeComponent();<br />
			base.OnInit(e);<br />
		}<br />
		<br />
		/// <summary><br />
		/// Required method for Designer support - do not modify<br />
		/// the contents of this method with the code editor.<br />
		/// </summary><br />
		private void InitializeComponent()<br />
		{    <br />
			this.oleDbDataAdapter1 = new System.Data.OleDb.OleDbDataAdapter();<br />
			this.oleDbSelectCommand1 = new System.Data.OleDb.OleDbCommand();<br />
			this.oleDbConnection1 = new System.Data.OleDb.OleDbConnection();<br />
<br />
			this.dbLoginInfo1 = new dbLoginInfo();<br />
			((System.ComponentModel.ISupportInitialize)(this.dbLoginInfo1)).BeginInit();<br />
			this.btnLogin.Click += new System.EventHandler(this.btnLogin_Click);<br />
			this.lblMessageTextBox1.TextChanged += new System.EventHandler(this.lblMessageTextBox1_TextChanged);<br />
			// <br />
			// oleDbDataAdapter1<br />
			// <br />
			this.oleDbDataAdapter1.SelectCommand = this.oleDbSelectCommand1;<br />
			this.oleDbDataAdapter1.TableMappings.AddRange(new System.Data.Common.DataTableMapping[] <br />
			{<br />
				new System.Data.Common.DataTableMapping("Table", "tblEmployee", new System.Data.Common.DataColumnMapping[] <br />
			{<br />
														new System.Data.Common.DataColumnMapping("EmployeeID", "EmployeeID"),<br />
														new System.Data.Common.DataColumnMapping("FName", "FName"),<br />
														new System.Data.Common.DataColumnMapping("LName", "LName"),<br />
														new System.Data.Common.DataColumnMapping("Password", "Password"),<br />
														new System.Data.Common.DataColumnMapping("Username", "Username")<br />
			})});<br />
			// <br />
			// oleDbSelectCommand1<br />
			// <br />
			this.oleDbSelectCommand1.CommandText = "SELECT EmployeeID, FName, LName, [Password], Username FROM tblEmployee";<br />
			this.oleDbSelectCommand1.Connection = this.oleDbConnection1;<br />
			// <br />
			// oleDbConnection1<br />
			// <br />
			this.oleDbConnection1.ConnectionString = @"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=0;Data Source=""D:\MGDevelopment\SIMDAC Viewer\DB\simdac_be.mdb"";Jet OLEDB:Engine Type=5;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;persist security info=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:Encrypt Database=False;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Global Bulk Transactions=1";<br />
			// <br />
			// dbLoginInfo1<br />
			// <br />
			this.dbLoginInfo1.DataSetName = "dbLoginInfo";<br />
			this.dbLoginInfo1.Locale = new System.Globalization.CultureInfo("en-US");<br />
			this.Load += new System.EventHandler(this.Page_Load);<br />
			((System.ComponentModel.ISupportInitialize)(this.dbLoginInfo1)).EndInit();<br />
			// <br />
			//get the data reader<br />
			//<br />
			try <br />
			{<br />
				this.oleDbConnection1.Open();<br />
				// TODO: Use the connection<br />
			}<br />
			catch (OleDbException ex) <br />
			{<br />
				// TODO: Handle the exception<br />
			}<br />
			// <br />
			//get the data reader<br />
			//<br />
			OleDbDataReader OleDbReader = this.oleDbSelectCommand1.ExecuteReader(CommandBehavior.CloseConnection);<br />
			while(OleDbReader.Read())<br />
            {<br />
				string sUserName = OleDbReader["UserName"].ToString();<br />
				string sPassword = OleDbReader["Password"].ToString();<br />
				//int secondCol = rdr.GetSqlInt32(1);<br />
				//Get other columns using the Get methods<br />
				//and take action.<br />
			    <br />
			}<br />
<br />
		}