Dataset/Table question

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.

Try something like this

Code:

---

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

---

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 ?

yes.

OriginalDataSet.Tables.Add("JimiHendrix")

:)

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.

Yes, I see how that would figure into datasets.

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

Quote:

---

Originally posted by Magiaus
:afrog: 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. :(

yeah no kidding