C#

<br />
public class AppDatabaseInterface<br />
{<br />
<br />
// Directory names<br />
private string m_cstrDefaultdbDir = "C:\\";<br />
<br />
// File names<br />
private const string m_cstrDBFileName = "DefaultDatabase.mdb";<br />
<br />
private System.Data.OleDb.OleDbConnection m_dbConn;<br />
<br />
public AppDatabaseInterface()<br />
{<br />
// Determine the App Root directory when this object is constructed<br />
System.Reflection.Assembly assm =<br />
System.Reflection.Assembly.GetAssembly(System.Type.GetType("AppDatabase.AppDatabaseInterface"));<br />
m_cstrDefaultdbDir = System.IO.Path.GetDirectoryName(assm.CodeBase.ToString());<br />
m_cstrDefaultdbDir = m_cstrDefaultdbDir.Remove(0, 6); // Removes the leading file:\ header from the path.<br />
<br />
OpenDatabase();<br />
}<br />
<br />
<br />
private void OpenDatabase()<br />
{<br />
lock (this)<br />
{<br />
// If the database connection hasn't been initialized, create it.<br />
// If it exists and is currently connected, close the connection<br />
// as we are about to establish a new connection.<br />
if (m_dbConn == null)<br />
{<br />
m_dbConn = new OleDbConnection();<br />
}<br />
else<br />
{<br />
if (m_dbConn.State != ConnectionState.Closed)<br />
{<br />
m_dbConn.Close();<br />
}<br />
}<br />
<br />
// Create the new connection string and try and attach to the new database.<br />
try<br />
{<br />
m_dbConn.ConnectionString = string.Format(<br />
@"Provider=Microsoft.Jet.OLEDB.4.0; Data Source={0}\{1};",<br />
m_cstrDefaultdbDir, m_cstrDBFileName);<br />
}<br />
catch<br />
{<br />
Console.WriteLine("Could not open database");<br />
}<br />
m_dbConn.Open();<br />
<br />
}<br />
}<br />

<br />
 public string[] Makes<br />
        {<br />
            get<br />
            {<br />
                OleDbDataReader dbr = null;<br />
                ArrayList Makes = new ArrayList();<br />
<br />
                OleDbCommand cmd = new OleDbCommand(string.Format("SELECT * FROM {0};", "Speakers"), m_dbConn);<br />
                dbr = cmd.ExecuteReader();<br />
<br />
                // Read each record one at a time ...<br />
                while (dbr.Read())<br />
                {<br />
                    // Load our arrays with the Field names<br />
                    // and values.  NOTE: Reloading the field<br />
                    // names over and over again is probably<br />
                    // redundant, but I'm not sure that the order<br />
                    // column names are returned is fixed.<br />
                    for (int it = 0; it < dbr.FieldCount; it++)<br />
                    {<br />
                        string strField = dbr.GetName(it);<br />
                        if (strField == "MAKE")<br />
                        {<br />
                            string make = (string)dbr.GetValue(it);<br />
                            bool found = false;<br />
                            foreach (object o in Makes)<br />
                            {<br />
                                if ((string)o == make)<br />
                                {<br />
                                    found = true;<br />
                                    break;<br />
                                }<br />
                            }<br />
                            if (found)<br />
                                Makes.Add(make);<br />
                            break;<br />
                        }<br />
<br />
                    }<br />
<br />
                }<br />
                string[] strMakes = new string[Makes.Count];<br />
                int i= 0;<br />
                foreach (object o in Makes)<br />
                {<br />
                    strMakes[i++] = (string)o;<br />
                }<br />
                return strMakes;<br />
            }<br />
        }<br />

<br />
public partial class frmAppDatabase: Form<br />
{<br />
AppDatabaseInterface m_database;<br />
<br />
public frmSpeakerDatabase()<br />
{<br />
InitializeComponent();<br />
<br />
m_database = new AppDatabaseInterface();<br />
<br />
string[] strSpeakerMakes = m_database.Makes;<br />
<br />
for (int i = 0; i < strSpeakerMakes.Length; i++)<br />
{<br />
cbSpeakerMakes.Items.Add(strSpeakerMakes[i]);<br />
}<br />
}<br />