C#

private void FindKey_Load(object sender, EventArgs e)
       {
           SqlCommand command;
           DataTable dt;
           try
           {
               SqlConnection con = new SqlConnection("Data Source=.\\SQLEXPRESS;AttachDbFilename=|DataDirectory|\\KeyStore.mdf;Integrated Security=True;User Instance=True");
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
           }

           //Open the Connection

           try
           {
               con.Open();
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
           }

           // Query The Database
           try
           {
               command = new SqlCommand("SELECT * FROM Key", con);
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
               command = new SqlCommand("SELECT * FROM Key", con);
           }

           try
           {
               dt = new DataTable();
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
               dt = new DataTable();
           }

           try
           {
               SqlDataAdapter da = new SqlDataAdapter(command);
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
           }

           // Fill the Result In DataTable
           try
           {
               da.Fill(dt);
           }
           catch (Exception ex)
           {
              MessageBox.Show("Error: " + ex);
           }

           //Show it in the list
           try
           {
               for (int i = 0; i < dt.Rows.Count; i++)
               {
                   DataRow dRow = dt.Rows[i];
                   FoundKey newkey = new FoundKey(dRow);
                   lstMatchedKeys.Items.Add(newkey);
               }
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
           }
               //Close the Connection
           try
           {
               con.Close();
           }
           catch (Exception ex)
           {
               MessageBox.Show("Error: " + ex);
           }

       }

string sConnectString = "Driver={QODBC Driver for QuickBooks};DFQ=C:\\Quickbooks\\sample_company_file.qbw;OpenMode=M;OLE DB Services=-2;";
           string sSQL = "SELECT Name FROM Employee";

           OdbcConnection cn;
           OdbcCommand cmd;

           //string MyString;
           //MyString="Select * from Customers";
           //cn = new OdbcConnection("Driver={SQL Server};Server=mySQLServer;UID=sa;PWD=myPassword;Database=Northwind;");

           cn = new OdbcConnection(sConnectString);
           cmd =new OdbcCommand(sSQL,cn);


           //cn.Open();
           //MessageBox.Show("Connected");
           //cn.Close();

           try
              {
                 cn.Open();
               MessageBox.Show("open");
               //odbcconnection1.GetSchema("tables")
               //odbcconnection1.GetSchema("columns")
               //http://www.daniweb.com/forums/thread194354.html
               OdbcDataReader dr = cmd.ExecuteReader();

               dr.GetSchemaTable().
               MessageBox.Show(dr.GetSchemaTable().TableName);





              }
           catch (OdbcException ex)
              {
                 MessageBox.Show(ex.Message);//<BR/>   There should be no <BR/>
              }
           finally
              {
                  cn.Close();
              }