Configure DataAdapter for DataTable

[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 !!

[One Handed Man [ OHM# ]]

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#

nitromuse wrote:

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 !!

Regards - OHM# On**********@BTInternet.com

[nitromuse]

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.

-----Original Message-----
There is insufficent information here to do this. You have not stated yoursource, or your control type or the nature of the data. Nor have youprovided any code.

Regards - OHM#

nitromuse wrote:

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 !!

Regards - OHM# On**********@BTInternet.com
.

[One Handed Man [ OHM# ]]

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#



nitromuse wrote:

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.

-----Original Message-----
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#

nitromuse wrote:

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 !!

Regards - OHM# On**********@BTInternet.com
.

Regards - OHM# On**********@BTInternet.com

[Cor]

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

[nitromuse]

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,

-----Original Message-----

OK, basically there are the following three things

Connector - Connects to your database source SQL server, Access etcDataAdapter - This is the go between the DataSet/table and the connectorDataSet - 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#



nitromuse wrote:

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.

-----Original Message-----
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#

nitromuse wrote:
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 !!

Regards - OHM# On**********@BTInternet.com
.

Regards - OHM# On**********@BTInternet.com
.