Hi everybody,
i've a question for this group: i've  developed a windows service that
every x minutes count records present in a sql table and if those
records are bigger than a fixed threshold start with clean operations.

Workflow is this:

1)  Load records in a DataSet:
DataSet    ds = new DataSet();
cmd = "SELECT * FROM " + TableName;
.........
adapter.Fill( ds );

2)Generate a DataView form table inside dataset and order it (i must
order. I tryed to order before load table in DataSet, but table is very
big and often i had timeout)

DataView dv = new DataView(ds.Tables[0]);
string order = GetTimeFieldName ( Table ) + " ASC";
dv.Sort = order;

3) Now i need convert data to XML, but not only one XML file, N XML
file of 10000 records. To do this i generate N DataTable from DataView,
add each DataTable to a New DataSet and call
WriteXML method N time.

The workflow working fine, but i think is not optimal solution (load
dataset, copy to dataview, order dataview, copy again ....... ) ,
someone have a better idea, or some suggestion to gave me?

Matt,

If you are using version 2005 than you can use the

Dataview.totable(overloaded function which uses columns)

Otherwise you will have to do it yourself using looping
http://www.vb-tips.com/default.aspx?ID=655b418e-8e9d-4303-8be7-d6ad9bebf57f

I hope this helps,

Cor

<matteoales***@libero.it> wrote in message
Show quoteHide quote--I'm not sure I follow you here.  The Timeout is related to the database
right, not the dataset itself?
--  I agree.  One solution would be to pull the data from the DB ordered as
you like, but this adds coupling to your business logic that you probably
don't want. In short, i think XSLT is probably a better way to handle this
problem. This way, you can take any given XML file and have it look however
you need it to. You may even be able to use one file and just apply
different translations to it to get whatever output you need.  One thing
though, I may not understand all of the nuance here. I see the loading  of
the dataset, I see the creation of the View, but where does the copy come n?
Show quoteHide quote

SqlTransaction problems
click event handler executed twice
What causes SqlCommandBuilder to not build commands?
date/time fields
VB.NET - How do I return an AutoNumber from an Insert Statement using the DataGridView