DG
Mon Jun 12 03:02:55 CDT 2006
I have same prblem, my resolution is:
Go to YourDataset.Designer.cs and add a setter for connectionstring (onyl
getter is generated by VS)
set
{
this["MyConnectionString"] = value;
}
Then set connectionstring from application:
Properties.Settings.Default.MyConnectionString = myConnStr;
Of course, bad thing is that every time you re create dataset, you have to
insert setter again
That's why i'm still looking for right solution for this one.
"Cor Ligthert [MVP]" <notmyfirstname@planet.nl> wrote in message
news:O0ZkjD9iGHA.2188@TK2MSFTNGP04.phx.gbl...
> Duane,
>
> I never have worked until now with tableadapters, but they are just
> inheriting dataadapter.
>
> Therefore I assume that you before every use of it. (the first fill) can
> set this to the needed one.
>
> XXXXXTableAdapter.Connection.ConnectionString = myconnectionstring
>
http://www.connectionstrings.com/
>
> (The type of connection should of course be the same)
>
> I hope this helps,
>
> Cor
>
>
>
>
>
>
>
>
>
> "Duane" <Duane@discussions.microsoft.com> schreef in bericht
> news:8B67841A-E7A6-4954-9194-3D633C8F3913@microsoft.com...
>> Hello Cor,
>>
>> Thanks for your reply. I have reviewed the articals but they refer to
>> design time solutions. I need a dynamic runtime solution.
>>
>> Thanks,
>>
>> Duane
>>
>> "Cor Ligthert [MVP]" wrote:
>>
>>> Duane,
>>>
>>> I saw that there are complete articles about your question on MSDN
>>>
>>>
http://msdn2.microsoft.com/en-us/library/ms171889.aspx
>>>
>>> I hope they helps,
>>>
>>> Cor
>>>
>>>
>>> "Duane" <Duane@discussions.microsoft.com> schreef in bericht
>>> news:AF3F6236-57C2-49C9-A8E2-D3B3D7DDA9BA@microsoft.com...
>>> >I created datasets and tableadapters using drag and drop and am using a
>>> >mdb
>>> > that is included in the project for development of a C# application.
>>> > However, the release version of the software must be able to point to
>>> > different datasource locations.
>>> >
>>> > There must be an economical way to do this, however I have not been
>>> > able
>>> > to
>>> > determine the correct procedure.
>>> >
>>> > Is there a way to do this?
>>> >
>>> > Thanks,
>>> >
>>> > Duane
>>>
>>>
>>>
>
>