I would like to know a way to use the DataSet in a memory cache into a C# application.

I only found examples in ASP.NET applications that they are not accepted in the C# application.

I am needing to improve the performance of my application and would like to know as to store in cache the content of a DataSet.

Thanks...

Hi there,

IMO, the cache is only useful for ASP.NET applications, to save the data between page calls.

In a desktop application, there is no need to cache. Just define a DataSet in your application somewhere (in the form's code, or in some business layer), feed it the data you have and that's it. The DataSet will be available through the life of the application.

Is this what you're after? Or do you have different requirements?

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.

Hi Imar;

Thanks for your reply;

I use one LOOP FOR to cover all the registers of a table that they are in one DATASET.

Inside of this LOOP FOR I use a method that consults another table and returns the values for a STRING that to the end is added to a RICHTEXTBOX.

Do you have some suggestion to improve the performance of this code.

My code below:

for (int i = 0; i <thisDataSetNumerosDeRegistro.Tables ["coleta"].Rows.Count; i++) {
                                thisDataSetTodosDadosTabela = ptcol.capturaTodosDadosTabelaColeta (thisDataSetNumerosDeRegistro.Tables ["coleta"].Rows [i]["NUMERODECAMPO"].ToString ());
                                    TodosDadosAchados += this.preparaDadosFormularioColeta (thisDataSetTodosDadosTabela); }//final do FOR

                                    ptconfere.rtfTextGeral.Text = TodosDadosAchados;

Thanks....

One way to optimize this is to use a StringBuilder instead of concatenating strings, which is pretty slow. Look here for more info:
http://msdn.microsoft.com/library/de...classtopic.asp

I am off now. Watching the Netherlands play football against Germany.....


Cheers,

Imar
---------------------------------------
Imar Spaanjaars
Everyone is unique, except for me.