internal static ArrayList GetTableNamesAsArrayList(string connectString)
{
ArrayList databaseTables = new ArrayList();
SqlDataReader tableReader = null;
System.Data.SqlClient.SqlConnection conn = new System.Data.SqlClient.SqlConnection();
try
{
conn.ConnectionString = connectString;
conn.Open();
SqlCommand cmdCreateDb = new SqlCommand();
cmdCreateDb.CommandText = "select name from sysobjects where xtype = 'U' and name <> 'dtproperties'";
cmdCreateDb.CommandType = System.Data.CommandType.Text;
cmdCreateDb.Connection = conn;
tableReader = cmdCreateDb.ExecuteReader();
while (tableReader.Read())
{
databaseTables.Add(tableReader.GetString(0));
}
}
catch (Exception ex)
{
throw ex;
}
finally
{
if (tableReader != null)
tableReader.Close();
if (conn != null)
conn.Close();
}
return databaseTables;
}
#endregion