Configure DataAdapter for DataTable

  • Thread starter Thread starter nitromuse
  • Start date Start date
N

nitromuse

Can you please tell me how to configure the adapter (DATA
SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now
accessing it isn't.
YOUR HELP IS APPRECIATED !!
 
There is insufficent information here to do this. You have not stated your
source, or your control type or the nature of the data. Nor have you
provided any code.

Regards - OHM#
Can you please tell me how to configure the adapter (DATA
SOURCE AND PROVIDER) for a data table that I generated
myself as a DataTable. It was easy to create it but now
accessing it isn't.
YOUR HELP IS APPRECIATED !!
Click to expand...

Regards - OHM# (e-mail address removed)
 
I was trying to do via the data adapter wizard rather
than code but I need to know how to refer to the data
source and provider for a datatable in order to do so.
Anything you can add is appreciated.
 
Hi

Nitromuse, did you do a rightclick on the dataadapter on your form,
with that you can configure it and after that make the dataset.

I hope that was what you where looking for?

Cor
 
OK, basically there are the following three things

Connector - Connects to your database source SQL server, Access etc
DataAdapter - This is the go between the DataSet/table and the connector
DataSet - this contains the DataTables and Relations , constraints etc.

Your wizard will have set up something like OLEDBDATACONNECTOR1,
OLEDBDATADAPTOR1 and you may or may not have generated a DataSet so far.

In the form load event you need to fill your custom table or dataset.

'If the control is a data grid for example

YourControl.DataSource = yourTable

OLEDBDATADAPTOR1.Fill( yourTable )

OHM#






I was trying to do via the data adapter wizard rather
than code but I need to know how to refer to the data
source and provider for a datatable in order to do so.
Anything you can add is appreciated.
Click to expand...

Regards - OHM# (e-mail address removed)
 
My problem is that I don't get anywhere with the Wizard
because I can't tell it the proper data source for my
self created datatable. If it were an outside database
it would be easy. I got all you had to say about the
connector, etc, I just need to know how to declare the
provider and source for a datatable, not a database.
Thanks again,
 
Back
Top