public ClassSqlServerTable(string n, string dsn, ClassSqlServerDatabase d)
{
Name=n;
Dsn = dsn;
Db = d;
ListField = new List<ClassField>();
}
public override int LoadFromDb()
{
string sql = "EXEC sp_databases";
int cpt=0;
using (OdbcDataAdapter dataAdapterParam = new OdbcDataAdapter(sql, Dsn))
{
DataTable table = new DataTable();
table.Locale = System.Globalization.CultureInfo.InvariantCulture;
dataAdapterParam.Fill(table);
foreach (DataRow rowParam in table.Rows)
{
cpt++;
ClassDatabase db = new ClassSqlServerDatabase(rowParam["DATABASE_NAME"].ToString(), Dsn, this);
Databases.Add(db);
}
}
return cpt;
}
