Dataset/Table question

[venerable bede]

I have a dataset which has 1 table with 10 coloumns and n rows.

I create a new table "newTable" which contains 2 coloumns "A" and "B".

I want to copy the contents of col 7 and col 8 of the original dataset/table into "newTable".

Whats the most efficient way of doing this ?

Coming up with a refined way of doing this is important as I perform this operation often in my application.

[Memnoch1207]

Try something like this

Dim NewTable As DataTable
Dim dsCopy As DataSet

dsCopy = OriginalDataSet.Copy

NewTable = dsCopy.Tables.Add("NewTableName")

With NewTable
  .Columns.Add("Field7", GetType(String))
  .Columns.Add("Field8", GetType(String))
End With

[venerable bede]

Do I have to create a new dataset ?

Can I not just create a new table and copy the details from the old table to the new ?

[Memnoch1207]

yes.

[mendhak]

OriginalDataSet.Tables.Add("JimiHendrix")

[Magiaus]

Is Parksie really dead? I just read the thread in the C\C++ forum... I never really knew him but if he is dead that sucks. He seemed like a good guy.

[mendhak]

Yes, I see how that would figure into datasets.

[Magiaus]

so your a mod now frog man? I was just wondering since you guys are all sporting the 1983 - 2004....

[mendhak]

Originally posted by Magiaus
so your a mod now frog man? I was just wondering since you guys are all sporting the 1983 - 2004....

Nah, I don't earn enough money to become a mod here.

[Magiaus]

yeah no kidding