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; }