PC Review


Reply
Thread Tools Rate Thread

Configure DataAdapter for DataTable

 
 
nitromuse
Guest
Posts: n/a
 
      11th Dec 2003
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 !!
 
Reply With Quote
 
 
 
 
One Handed Man [ OHM# ]
Guest
Posts: n/a
 
      11th Dec 2003
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)


 
Reply With Quote
 
nitromuse
Guest
Posts: n/a
 
      11th Dec 2003
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)
>
>
>.
>

 
Reply With Quote
 
Cor
Guest
Posts: n/a
 
      11th Dec 2003
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



 
Reply With Quote
 
One Handed Man [ OHM# ]
Guest
Posts: n/a
 
      11th Dec 2003

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)


 
Reply With Quote
 
nitromuse
Guest
Posts: n/a
 
      11th Dec 2003
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 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)
>
>
>.
>

 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
dataset, datatable, dataadapter DaveP Microsoft C# .NET 4 15th Sep 2007 12:25 AM
performance of DataAdapter and DataTable =?Utf-8?B?RGF2aWQgSGFycmlz?= Microsoft Dot NET 0 1st Feb 2006 08:05 PM
Re: Update datatable in memory without dataadapter Adrian Moore Microsoft ADO .NET 0 15th May 2005 03:52 PM
DataTable before DataAdapter possible? randy Microsoft Dot NET 5 10th May 2004 08:58 PM
Re:DataAdapter, DataTable & primary key srinivas moorthy Microsoft ADO .NET 0 28th Jul 2003 01:11 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 09:41 AM.