How to change the ConnectionString for an auto generated typed dataset in a separate dll ???

microsoft.public.dotnet.framework

16 Mar 2006 12:50 PM

tanguay.mathieu

So here i've made a typed dataset in vs2005 by picking some tables in
the server explorer. It generated a typed dataset with everything
inside it ok. Now i've decided to put this newly created dataset in a
common dll project to share it accross many applications that need the
exact (or almost) set of data.
The problem is if you look into the datatableadapter class created
you'll see something like this:

        Private Sub InitConnection()
            Me._connection = New System.Data.SqlClient.SqlConnection
            Me._connection.ConnectionString =
Global.MyEngine.MySettings.Default.MyConnectionString
        End Sub

My engine dll as no settings or app.conf files. So how can i change
this behavior in order to point to a connection string in the executing

application ?
And is there a way of manually setting this connection string ?
Why is the connection property marked as Friend ?

Thanks in advance
mateo