How to connect an existing strongly-typed data set to a different server at run time?

Posted by Kiril on Stack Overflow See other posts from Stack Overflow or by Kiril
Published on 2010-04-07T09:52:57Z Indexed on 2010/04/08 2:43 UTC
Read the original article Hit count: 333

Filed under:
|
|
|

I am coding a simple space empire management game in Visual C# 2008, which relies on connecting to a remote SQL server database to get/store data.

I would like the user to be able to connect to a user-specified SQL server from the login screen(he specifies IP address, port, database name, ID, password and presses "connect" button). However, I found out that the Dataset connection string property is read only and cannot be changed. Is there any way to guide the wizard-generated DataSet to a user-specified server at run time?

© Stack Overflow or respective owner

Related posts about c#

Related posts about dataset