Hi all,

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!