Comments by orélle (Top 18 by date)

i have posted the query above. The query runs well if i execute directly on access so it's correct, the issue is while reading data in my application. Thanks

This is the query: I use Access database

string queryC = "SELECT DISTINCT dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_LIEN, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.TAUX_OCCUPATION, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_EQPT_A, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.PORT_A, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_EQPT_B, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.PORT_B, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_SLOT_A, dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_SLOT_B FROM dbo_BOGEDOTXM_OCCUP_LIENS_SDH INNER JOIN ((dbo_EQUIPEMENT INNER JOIN dbo_OSMOSE_SITE_GEOGRAPHIQUE ON dbo_EQUIPEMENT.NUM_SITE_GEO = dbo_OSMOSE_SITE_GEOGRAPHIQUE.NUM_SITE_GEO) INNER JOIN dbo_OSMOSE_OPERATION ON dbo_OSMOSE_SITE_GEOGRAPHIQUE.NUM_SITE_GEO = dbo_OSMOSE_OPERATION.NUM_SITE_GEO) ON dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_EQPT_A = dbo_EQUIPEMENT.NOM_EQUIPEMENT WHERE (( (dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_LIEN) Like '%AT%' Or (dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_LIEN) Like '%BT%' Or (dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_LIEN) Like '%CT%' Or (dbo_BOGEDOTXM_OCCUP_LIENS_SDH.NOM_LIEN) Like '%DT%') AND ((dbo_OSMOSE_OPERATION.REGION_EXPLOITATION)=" + region + "));";

When the size of the data fits, it works. What is the location of the temporary folder?
I have a lot of free space on my disk anyway. If might be possible to increase the defautt value of the database result to more than 2 Go it will overcome the issue.

I throw serializationException in my catch i discover that serialization was not completed successfully. An exception was thrown telling that ShapeClass attribute of my Equipment class "is not marked Serializable". This was the problem!!!
Then i solved the issue by modifying my business object Equipment class(Shapeclass as member it was useless).
It works properly now :)

Thanks for your problem solving skill, i retained that: "Prior to solve a problem try to understand from where its come from ortherwise you may be tried to solve the wrong problem".

The objects that i serialize are not derived.
My differents classes: Equipment, Link and Shape are base classes.

Sometimes the deserialization works pretty well sometimes not. I am confused!!

public void save(object toSave, string path)
{
//On utilise la classe BinaryFormatter dans le namespace System.Runtime.Serialization.Formatters.Binary.
BinaryFormatter formatter = new BinaryFormatter();
//La classe BinaryFormatter ne fonctionne qu'avec un flux, et non pas un TextWriter.
//Nous allons donc utiliser un FileStream. Remarquez que n'importe quel flux est
//compatible.
FileStream flux = null;
try
{
//On ouvre le flux en mode création / écrasement de fichier et on
//donne au flux le droit en écriture seulement.
flux = new FileStream(path, FileMode.Create, FileAccess.Write);
//Et hop ! On sérialise !
formatter.Serialize(flux, toSave);
//On s'assure que le tout soit écrit dans le fichier.
flux.Flush();
}
catch { }
finally
{
//Et on ferme le flux.
if (flux != null)
flux.Close();
}


}

/***************************************************************************************************************************/
public T load<t>(string path)
{
BinaryFormatter formatter = new BinaryFormatter();
FileStream flux = null;
try
{
//On ouvre le fichier en mode lecture seule. De plus, puisqu'on a sélectionné le mode Open,
//si le fichier n'existe pas, une exception sera levée.
flux = new FileStream(path, FileMode.Open);
return (T)formatter.Deserialize(flux);

}
catch (SerializationException e)
{
//On retourne la valeur par défaut du type T.
System.Windows.Forms.MessageBox.Show(" Failed! Raison: "+e.Message);
return default(T);
}
finally
{
if (flux != null)
flux.Close();
}

}


This is how i call them:
designer.save(designer.ListEquips, Path + @"\equips.dat");
designer.save(designer.ListLinks, Path + @"\links.dat");
designer.save(designer.ListConnector, Path + @"\connectors.dat");

List<equipment> equipments = designer.load<List<equipment>>(Path + @"\equips.dat");
List<Link> links = designer.load<List>(Path + @"\links.dat");
List<shape> connectors = designer.load<List<shape>>(Path + @"\connectors.dat");

I have tried them.
Definitively they don't sweet my needs.

There is no event code corresponding to shapeclick.
Thanks for your contribution.

I expect that someone has writen the same method with better performance. It's not impossible...
If someone has a way to connect shape dynamically with better performance than those proposed in the Visio sdk, it will be really appreciated.
Thanks

That looks interesting however using Visio is a requirement in my case. My users are used to and they prefer Visio.
Visio licence is not an issue, in fact i access visio trough a virtualized application. Programmatically, i don't know how to access visio on the virtualized application installed on my computer. That's why, i wanna program visio without having its installed then i will be able to open generated visio files trough the virtualized application

Have you try to run the code using that reference without Visio Soft installed? If not try, an exception will raise telling roughfully that you need to install visio.
Thanks

Thank for your suggestion, but this needs Microsoft Office Visio to be installed on the machine where the c# code is running!
I need to do the same but without Microsoft Visio installed on the server running my code.