How to simplify this code?

string [] TablesGeometriesMDB = new string[]
        {
            "chain",
            "link",
            "link_coords",
            "node",
            "point",
            "simple_area",
            "simple_area_coords",
            "simple_chain",
            "simple_chain_coords",
            "simple_point",
            "text"
        };

string [] TablesDesignObjectsMDB = new string[]{"drawings", "projects"};
void GetData(string strSelectedMDB)
{
  switch(strSelectedMDB) {
	case "geometries":
          GetDataFromDB(TablesGeometriesMDB);
	  break;
	case "objects":
          GetDataFromDB(TablesDesignObjectsMDB);
	  break;
  }
}
void GetDataFromDB(string[] tables)
{
  OleDbConnection con = new OleDbConnection(...):
  con.Open();
  foreach (string table in tables)
        {
          strSQL = string.Format("SELECT COUNT(*) FROM [{0}]", table);
          OleDbCommand cmd = new OleDbCommand(strSQL, con);
          int cnt = Convert.ToInt32(cmd.ExecuteScalar());
          lstOutput.Items.Add(string.Format("{0}: ", table, cnt);
          ICountMDBObjects += cnt;
	}
  lstOutput.ScrollIntoView(lstOutput.Items.GetItemAtlstOutput.Items.Count - 1));
  con.Close();
  con.Dispose();
}

List<string> enumValues = new List<string>();
switch(strSelectedMDB) 
{
	case "geometries": DoGeoMetries(); break;
	case "objects": DoObjects(); break;
	default: break;
}	
AddToDataBase(enumValues); 
}
private void DoGeoMetries()
{
	enumValues = new List<string>();
	foreach (TablesGeometriesMDB table in Enum.GetValues(typeof(TablesGeometriesMDB)))
	{
		enumValues.Add(table.ToString());
	}
}
private void DoObjects()
{	
	enumValues = new List<string>();
	foreach (TablesDesignObjectsMDB table in Enum.GetValues(typeof(TablesDesignObjectsMDB)))
	{
		enumValues.Add(table.ToString());
	}
}
private void AddToDataBase(List<string> enumValues)
{
	foreach (string enumValue in enumValues)
	{
		OleDbConnection con = new OleDbConnection(...):
		string strSql = string.Format("SELECT COUNT(*) FROM [{0}]", enumValue);
		OleDbCommand cmd = new OleDbCommand(strSQL, con);
		try
		{
			con.Open();
			using (OleDbDataReader dr = cmd.ExecuteReader())
			{
				while (dr.Read())
				{
					 lstOutput.Items.Add(table + ": " + dr[0].ToString());
					 lstOutput.ScrollIntoView(lstOutput.Items.GetItemAtlstOutput.Items.Count - 1));
					 ICountMDBObjects += Convert.ToInt32(dr[0]);
				}
				dr.Close();
			}
		}
		catch(Exception)
		{
		}
		finally
		{
			if (con != null && con.State == ConnectionState.Open)
				con.Close();	
		}
	}
}

StringBuilder query = new StringBuilder();
query.AppendLine("SELECT [Fields] FROM table1 ");
query.AppendLine("SELECT [Fields] FROM table2 ");
query.AppendLine("SELECT [Fields] FROM table3 ");

string[] tableNames = new string[]{"Table1", "Table2", "Table3"};

DataSet ds = new DataSet();
using(SqlConnection conn = new SqlConnection(...))
{
  using(SqlCommand cmd = new SqlCommand(query.ToString(), conn))
  {
    conn.Open();
    ds.Load(cmd.ExecuteReader(), LoadOption.OverrightChanges, tableNames);
  }
}

foreach(DataTaable dt in ds.Tables)
{
  foreach(DataRow row in dt.Rows)
  {
    ....
  }
}