Not sure, but you can add the file, let it add conn string and then open the
C# file for the DataSet and change to the first connection string.
I have done table adapters in the past and I believe I had it on a single
conn string, without the magic above, but it has been since VS 2005 beta
timeframe, so my memory has faded on how I did it. Apologies.

Signature
Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA
***************************
Think Outside the Box!
***************************
> Hi all,
>
[quoted text clipped - 18 lines]
>
> Simon
Simon Harvey - 16 Mar 2007 10:33 GMT
Hi there,
Thanks for your help.
I've actually tried to do this, but it really seems to piss the designer
off when I try it. Part of the problem is that it adds numerous
references to the dataset code and the xsd file - not to mention the
settings file and the application config file that its taken to adding
to my data access project.
Stupid arse thing. I know I'm prbably doing something wrong - but I
don't think I'm completely thick - so I dont think its self evident why
what I'm doing isn't working.
I'm giving up cos this is really getting on my tits now.
Thanks again for your suggestion though
Simon