VB.net Query results

Question

I'm a bit confused on how to grab query results. With VBA i would open a record set and have the results of the query written to that recordset. IN VB.net how can I grab the query result and throw each column into specfic arrays?

dim ssql as string
ssql = " Select * from table "

Now how would I force it to query my DB? I have a connection established already.

After the query how can i play with the columnes and place them into arrays?

Answer 1

This is actually a pretty big topic...you might want to get an overview before you start. http://msdn.microsoft.com/en-us/library/h0y4a0f6(v=vs.80).aspx

To answer your question: If you have a database connection you can use a DataAdapter to fill a local dataTable or dataSet.

connectionString = "Data Source=servername; Initial Catalog=databasename; " + _
    "User ID=userid; Password=password"
cnn = New SqlConnection(connectionString)
cnn.Open()
sqlAdp = New SqlDataAdapter("select * from users", cnn)
sqlAdp.Fill(ds)

EDIT: This is just a sample, you'll want to close the connection and declare a dataSet 'ds'.

Answer 2

You should take a few minutes to read this