C# - How To Get Database Name From Connection String Using Sqlconnectionstringbuilder - Stack Overflow

c Visual Studio Connection String for SQL Server Database Project

C# - How To Get Database Name From Connection String Using Sqlconnectionstringbuilder - Stack Overflow. I can read the connection strings from the config file, however i need to get the element name that is associated with connection string. The class also makes it easy to manage connection strings stored in an application configuration file.

System.data.sqlclient.sqlconnectionstringbuilder connectionstringbuilder = new system.data.sqlclient.sqlconnectionstringbuilder(constr); Void set (system::string ^ value); To save new connection, you can use connectionstringbuilder with existing connection, change the name of database and save it to app.config. //replace secret with your local db password name conn.open(); 3] under connect to a database, select select or enter a database name. ' now use the open connection. According to the client's requirement, the database connection string need to be stored in system registry.during the connection establishment,we have to read the connection string from system registry. Sqlconnectionstringbuilder builder = new sqlconnectionstringbuilder {connectionstring = configuration.getconnectionstring(defaultconnection)}; It only works some of the time. Morten wennevik [c# mvp] luigi wrote:

Using (sqlcommand cmd = new sqlcommand (select name from sys.databases, con)) {. Please help me out to complete the code/solution or correct the code and get the result. String unprotectedpwd = builder[password] as string; Property that might hold the value you need. Builder(server) = . builder(connect timeout) = 1000 ' the item property is the default for the class, ' and setting the item property adds the value to the ' dictionary, if necessary. Friday, may 21, 2010 9:08 am. In the above code, you can see that we can get the list of database names using sys.databases and the result will be as below. System.data.sqlclient.sqlconnectionstringbuilder connbuilder = new system.data.sqlclient.sqlconnectionstringbuilder(); Sqlconnectionstringbuilder builder = new sqlconnectionstringbuilder {connectionstring = configuration.getconnectionstring(defaultconnection)}; 2] under server name select your database server name (let the list populate if its taking time). Now, with the help of this list, we can validate the database connection string.