public static void Main()
{
     OleDbConnection m_cnADONetConnection = new OleDbConnection();

     m_cnADONetConnection.ConnectionString="Provider=Microsoft.Jet.OLEDB.4.0; Data Source= c:\\test.mdb"; 
     m_cnADONetConnection.Open();
     string sql="Select * from TestTable";
     OleDbCommand  com=new OleDbCommand(sql,m_cnADONetConnection );
     OleDataAdapter m_daDataAdapter =new OleDbDataAdapter(com);
     DataTable m_dtContacts =new DataTable();
     m_daDataAdapter.Fill(m_dtContacts);
     m_cnADONetConnection .Close();
// Additional processing such as displaying the records

}

using System;
using System.Collections.Generic;
using System.Drawing;
using System.Windows.Forms;
using System.Data.OleDb;

namespace Database_Example
{
	/// <summary>
	/// Description of MainForm.
	/// </summary>
	public partial class fclsMain : Form
	{
		OleDbConnection m_cnADONetConnection =new OleDbConnection();
		DataTable m_dtContacts =new DataTable();
		int m_rowPosition = 0;
		
		public fclsMain()
		{
			//
			// The InitializeComponent() call is required for Windows Forms designer support.
			//
			InitializeComponent();
			
			//
			// TODO: Add constructor code after the InitializeComponent() call.
			//
		}
		
		void FclsMainLoad(object sender, EventArgs e)
		{
			m_cnADONetConnection.ConnectionString =
			@"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\Documents and Settings\Charlynne Guay\My Documents\Guild Items.xls";
			OleDbDataAdapter m_daDataAdapter = new OleDbDataAdapter();
			m_daDataAdapter = new OleDbDataAdapter("Select * From Contacts",m_cnADONetConnection);
			OleDbCommandBuilder m_cbCommandBuilder = new OleDbCommandBuilder(m_daDataAdapter);
			m_daDataAdapter.Fill(m_dtContacts);
		}
			
		void FclsMainFormClosed(object sender, FormClosedEventArgs e)
		{
			m_cnADONetConnection.Close();
		}
		}
		}

DataTable m_dtContacts = new DataTable();

int m_rowPosition = 0;

m_daDataAdapter.Fill(m_dtContacts);

using System.Data;