Two simple database questions

[s986]

What method of OleDbDataAdapter do you use to retrieve records into a dataset? Can you give an example of the syntax?


What database object specifies which tables to use in the database?

 

[quwiltw]

Create a OleDbCommand object with the select statement as the commandtext and assign it to the SelectCommand property of the dataadapter. Look under Data and ADO.NET on this page for an example:
http://samples.gotdotnet.com/quickstart/howto/

 

[hemenkap]

you can do the following

1. ) creat a oledbConnection
2. ) Open that connection.
3. ) Create an OledbCommand Object
4.) Creat a OleadDataAdapter
5. ) Create a Dataset

then do as follows :

OledbCommand = OledbConnection.CreateCommand
OledbCommand.CommandText = " Select ......."
OledbDataAdapter.SelectCommand = OledbCommand
DledbDataAdapter.Fill(Dataset,"TableName")

Over That will fill the dataset with data