Hi

I have configured a data source and strongly types dataset in my winfrom
app. I dragged one of the tables to my form. All I see on my form and in
dataset are tableadapters. Is there a way to use dataadapter via code in
vs2008? A short code example would be much appreciated. The reason I want to
use dataadapter instead of tableadapter is that I need to change the select
command at runtime.

Many Thanks

Regards

The DataAdapter type is still part of the Framework and you can still code
against it with no problems. MS has created a Visual Studio entity called a
TableAdapter, which offers the same kind of functionality as the
DataAdapter, but with more features.

See my response to you other post for links on how to use it.

-Scott

"John" <(E-Mail Removed)> wrote in message
news:%23Z%(E-Mail Removed)...
> Hi
>
> I have configured a data source and strongly types dataset in my winfrom
> app. I dragged one of the tables to my form. All I see on my form and in
> dataset are tableadapters. Is there a way to use dataadapter via code in
> vs2008? A short code example would be much appreciated. The reason I want
> to use dataadapter instead of tableadapter is that I need to change the
> select command at runtime.
>
> Many Thanks
>
> Regards
>
>

"John" <(E-Mail Removed)> wrote in
news:#Z#(E-Mail Removed):

> Hi
>
> I have configured a data source and strongly types dataset in my
> winfrom app. I dragged one of the tables to my form. All I see on my
> form and in dataset are tableadapters. Is there a way to use
> dataadapter via code in vs2008? A short code example would be much
> appreciated. The reason I want to use dataadapter instead of
> tableadapter is that I need to change the select command at runtime.


If the drag and drop goodness is what you want, but you also want
something it does not give you, then code it in. In this case, it should
be as simple as exposing the underlying select query, as a table adapter
sits on top of the DataAdapter class.

http://weblogs.asp.net/dwahlin/archi.../31/Enhancing-
TableAdapters.aspx


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

"Scott M." <s-(E-Mail Removed)> wrote in
news:eqGnBR#(E-Mail Removed):

> The DataAdapter type is still part of the Framework and you can still
> code against it with no problems. MS has created a Visual Studio
> entity called a TableAdapter, which offers the same kind of
> functionality as the DataAdapter, but with more features.


It is a "custom" generated class from the GUI drag and drop the user did on
a DataSet. It is not a Framework class, however (not suggesting you did not
know this, but others read this forum). The framework class is DataAdapter.


--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

Yes, as I said it is a Visual Studio created entity.


"Gregory A. Beamer" <(E-Mail Removed)> wrote in message
news:Xns9C4961944F088gbworld@207.46.248.16...
> "Scott M." <s-(E-Mail Removed)> wrote in
> news:eqGnBR#(E-Mail Removed):
>
>> The DataAdapter type is still part of the Framework and you can still
>> code against it with no problems. MS has created a Visual Studio
>> entity called a TableAdapter, which offers the same kind of
>> functionality as the DataAdapter, but with more features.
>
>
> It is a "custom" generated class from the GUI drag and drop the user did
> on
> a DataSet. It is not a Framework class, however (not suggesting you did
> not
> know this, but others read this forum). The framework class is
> DataAdapter.
>
>
> --
> Gregory A. Beamer
> MVP; MCP: +I, SE, SD, DBA
>
> Twitter: @gbworld
> Blog: http://gregorybeamer.spaces.live.com
>
> *******************************************
> | Think outside the box! |
> *******************************************

John,'

Do you want the sample in F# or in another program language?

Cor

"John" <(E-Mail Removed)> wrote in message
news:%23Z%(E-Mail Removed)...
> Hi
>
> I have configured a data source and strongly types dataset in my winfrom
> app. I dragged one of the tables to my form. All I see on my form and in
> dataset are tableadapters. Is there a way to use dataadapter via code in
> vs2008? A short code example would be much appreciated. The reason I want
> to use dataadapter instead of tableadapter is that I need to change the
> select command at runtime.
>
> Many Thanks
>
> Regards
>
>

"Scott M." <s-(E-Mail Removed)> wrote in
news:u$(E-Mail Removed):

> Yes, as I said it is a Visual Studio created entity.

Reread your post and I guess I was just reading it incorrectly before.
Thanks for the follow up.



--
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

Twitter: @gbworld
Blog: http://gregorybeamer.spaces.live.com

*******************************************
| Think outside the box! |
*******************************************

c# or vb.net would do. unless its sarcasm

Thanks

Regards

"Cor Ligthert[MVP]" <(E-Mail Removed)> wrote in message
news:Ot$(E-Mail Removed)...
> John,'
>
> Do you want the sample in F# or in another program language?
>
> Cor
>
> "John" <(E-Mail Removed)> wrote in message
> news:%23Z%(E-Mail Removed)...
>> Hi
>>
>> I have configured a data source and strongly types dataset in my winfrom
>> app. I dragged one of the tables to my form. All I see on my form and in
>> dataset are tableadapters. Is there a way to use dataadapter via code in
>> vs2008? A short code example would be much appreciated. The reason I want
>> to use dataadapter instead of tableadapter is that I need to change the
>> select command at runtime.
>>
>> Many Thanks
>>
>> Regards
>>
>>
>