I am writing a program that connects to a webservers db. I have a testing db on my local machine and i add a new dataset to this local db. I have tried to go into the app.config and change the connectionstring to a global variable i created useing the connection information i have stored in the registry. The global variable works when called outside of the dataset. what i am needing is to change the connectionstring for my wizard created dataset.
Any help with this is greatly appreciated.

Thank You

I have solved the problem.

I went into the dataset and changed this line of code:

me._connection = Global.MyAppName.My.MySettings.Default.MyConnString

to this

me.connection = m_connection

m_connection is created at runtime with the users server information stored in the registry.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.