Creating and populating a dataset using VB.NET?

Question

I have the code to connect to a database. I want to know how to create a data adapter and a dataset(I use a sql database). I want to do this by writing the code and not in the design view.
Thanks.

Answer 1

Create a record set object using ADO DC Control.
With that you can run your query like
adodc.execute("Select ....")

Once your query is executed, you can use FirstRecord, NextRecord methods to move in your recordset.

Use adodc.Fields() or adodc.fields("") to retrive the fields.