Transforming from one dataset to another...

[SPG]

Hi,

I have a dataset containing one table with plenty of rows (>5000).
I need to convert these to fit into another set of rows in the quickest
possible way.

I know what fields I will be getting in, and what fields need to be
converted to make the output dataset, but am tryingto find the quickest way
of doing this.

I am toying with the idea of my own DataAdapter, with the Fill method doing
the transform. The only way I can think of doing this is to loop through all
rows doing the conversion on each row and passing that as a new row to my
new dataset.

There has got to be a better way! Surely??

Steve

[William Ryan eMVP]

If the data is the same, just fewer/different rows, why not just create
another adapter and fill your second dataset wtih da2.Fill
"SPG" <st*******************@nopoo.blueyonder.co.uk> wrote in message
news:oC*********************@news-text.cableinet.net...

Hi,

I have a dataset containing one table with plenty of rows (>5000).
I need to convert these to fit into another set of rows in the quickest
possible way.

I know what fields I will be getting in, and what fields need to be
converted to make the output dataset, but am tryingto find the quickest way of doing this.

I am toying with the idea of my own DataAdapter, with the Fill method doing the transform. The only way I can think of doing this is to loop through all rows doing the conversion on each row and passing that as a new row to my
new dataset.

There has got to be a better way! Surely??

Steve

[William Ryan eMVP]

If the data is the same, just fewer/different rows, why not just create
another adapter and fill your second dataset wtih da2.Fill
"SPG" <st*******************@nopoo.blueyonder.co.uk> wrote in message
news:oC*********************@news-text.cableinet.net...

Hi,

I have a dataset containing one table with plenty of rows (>5000).
I need to convert these to fit into another set of rows in the quickest
possible way.

I know what fields I will be getting in, and what fields need to be
converted to make the output dataset, but am tryingto find the quickest way of doing this.

I am toying with the idea of my own DataAdapter, with the Fill method doing the transform. The only way I can think of doing this is to loop through all rows doing the conversion on each row and passing that as a new row to my
new dataset.

There has got to be a better way! Surely??

Steve

[SPG]

William,

I have already made my own dataadapter to do this.
On myAdap.Fill(ds) I simply whizz through all the rows in the origianl
dataset, and make a transformation (IE: some fields are concatenated etc)..

If this is the best way to do this, I am doing it already.. Just a bit slow
when traversing 5000+ rows..

Steve
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

If the data is the same, just fewer/different rows, why not just create
another adapter and fill your second dataset wtih da2.Fill
"SPG" <st*******************@nopoo.blueyonder.co.uk> wrote in message
news:oC*********************@news-text.cableinet.net...

Hi,

I have a dataset containing one table with plenty of rows (>5000).
I need to convert these to fit into another set of rows in the quickest
possible way.

I know what fields I will be getting in, and what fields need to be
converted to make the output dataset, but am tryingto find the quickest

way

of doing this.

I am toying with the idea of my own DataAdapter, with the Fill method

doing

the transform. The only way I can think of doing this is to loop through

all

rows doing the conversion on each row and passing that as a new row to my new dataset.

There has got to be a better way! Surely??

Steve

[SPG]

William,

I have already made my own dataadapter to do this.
On myAdap.Fill(ds) I simply whizz through all the rows in the origianl
dataset, and make a transformation (IE: some fields are concatenated etc)..

If this is the best way to do this, I am doing it already.. Just a bit slow
when traversing 5000+ rows..

Steve
"William Ryan eMVP" <do********@comcast.nospam.net> wrote in message
news:OH**************@TK2MSFTNGP10.phx.gbl...

If the data is the same, just fewer/different rows, why not just create
another adapter and fill your second dataset wtih da2.Fill
"SPG" <st*******************@nopoo.blueyonder.co.uk> wrote in message
news:oC*********************@news-text.cableinet.net...

Hi,

I have a dataset containing one table with plenty of rows (>5000).
I need to convert these to fit into another set of rows in the quickest
possible way.

I know what fields I will be getting in, and what fields need to be
converted to make the output dataset, but am tryingto find the quickest

way

of doing this.

I am toying with the idea of my own DataAdapter, with the Fill method

doing

the transform. The only way I can think of doing this is to loop through

all

rows doing the conversion on each row and passing that as a new row to my new dataset.

There has got to be a better way! Surely??

Steve