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
Survey posted by VBForums.