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