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# (E-Mail Removed)
>>
>>
>> .
Regards - OHM#
(E-Mail Removed)