Thursday 9 February 2017

how to get dbname, servername, user, password etc from connection string using asp.net c#

//    Connection string

<add name="DBConnection" providerName="System.Data.SqlClient" connectionString="server=127.0.0.1;database=DBName;user=UserID;password=Pwd/>


//     Method 1-


public static string MainDBName()
    {
        string conName = "";
        using (SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["DBConnection"].ToString()))
        {
          conName=  conn.Database.ToString();
          conName = conn.DataSource.ToString();
        }
        return conName;

    }



//     Method 2-

public static SqlConnectionStringBuilder SSB = new SqlConnectionStringBuilder(ConfigurationManager.ConnectionStrings["DBConnection"].ToString());
    public static string server = Convert.ToString(SSB["server"]);
    public static string database = Convert.ToString(SSB["database"]);
    public static string UserID = Convert.ToString(SSB["user"]);
    public static string password = Convert.ToString(SSB["password"]);

No comments:

Post a Comment

Excel Sort values in ascending order using function TEXTJOIN

 Excel ::  Text ::  1,3,5,2,9,5,11 Result :: 1,2,3,5,5,9,11 Formula ::     TEXTJOIN ( ",",1,SORT(MID(SUBSTITUTE( A1 ,","...