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

c Why is the application not using my connection string? Stack

C# - How To Get Database Name From Connection String Using Sqlconnectionstringbuilder - Stack Overflow. <add name=localsqlserver connectionstring=data source=.\sqlexpress;integrated</strong> security=sspi;attachdbfilename=|datadirectory|aspnetdb.mdf;user instance=true.</p> The following example shows how to use a connection string to read data from a database.

System.data.sqlclient.sqlconnectionstringbuilder connectionstringbuilder = new system.data.sqlclient.sqlconnectionstringbuilder(constr); Conn.connectionstring = dsn=dsnname; + //replace dsnname with your local db server name uid=username; + //replace usernamewith your local db user name pwd=secret;; Just wonder if i miss anything in my sql script: This will bring up the grid configuration options. Gets or sets the name of the database associated with the connection. Developers needing to create connection strings as part of applications can use the sqlconnectionstringbuilder class to build and modify connection strings. For more information about localdb, see sqlclient support for localdb. For example, sql server connection string properties are different than mysql or oledb connection strings. I'm trying to get the database name from connection string. Var conn = new odbcconnection();

It only works some of the time. Sqlconnection myconnection = new sqlconnection (); Morten wennevik [c# mvp] luigi wrote: Var conn = new odbcconnection(); Private static void changesqldatabase(string connectionstring) { // assumes connectionstring represents a valid connection string // to the adventureworks sample database. 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. Please help me out to complete the code/solution or correct the code and get the result. From these examples you can say that you can define oracle db by data source substring, then tell the difference between mysql and sql server by string uid and user id respectively and so on. 4] select your database from dropdown. Public string initialcatalog { get; ' now use the open connection.