public override sc2i.common.CResultAErreur ExecuterOperation(IDatabaseConnexion connection, sc2i.common.IIndicateurProgression indicateur) { CResultAErreur result = CResultAErreur.True; CAccess97DatabaseConnexion cnx = connection as CAccess97DatabaseConnexion; if (cnx == null) { return(result); } CAccessDataBaseCreator creator = cnx.GetDataBaseCreator() as CAccessDataBaseCreator; if (creator == null) { return(result); } foreach (Type tp in CContexteDonnee.GetAllTypes()) { CStructureTable structure = CStructureTable.GetStructure(tp); if (structure != null && creator.TableExists(structure.NomTable)) { foreach (CInfoChampTable info in structure.Champs) { if (!info.NullAuthorized && !structure.ChampsId.Contains(info)) { result = creator.SetValeursParDefautAuxDonneesNulles(structure.NomTable, info); if (!result) { return(result); } } } } } return(result); }
static void Main(string[] args) { CAccess97DatabaseConnexion cnx = new CAccess97DatabaseConnexion(0); cnx.ConnexionString = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=\"C:\\Documents and Settings\\GENERIC\\Mes documents\\sites.MDB\""; CAccessDataBaseCreator creator = new CAccessDataBaseCreator(cnx); List <string> lstCols = creator.GetNomColonnes("SITES"); creator.InitialiserDataBase(); List <CInfoRelation> lst = new List <CInfoRelation>(); creator.GetRelationsExistantes("SITES", ref lst); }