Mar 6th, 2011, 03:27 AM
Dump a dataset into an already created DataTable
wish to open up a dataset via OleDB and dump the data into a datatable i have already created. I dont want to just dump the data into a datatable i have just declared, I want it to go in a datatable i have set up in the code. For example, in vb.net code I have created a datatable 'tblTest' and set 2 fields named TestField1 and Testfield2.
My SQL may be "select name, company from companies" and i want the name field to go in TestField1 and the company field to go in Testfield2.
any syntax would be muh appreciated!
Click Here to Expand Forum to Full Width