-
Mar 6th, 2011, 04:27 AM
#1
Thread Starter
Member
Dump a dataset into an already created DataTable
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!
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|