/// <summary> ///Gets the database instance name for the specified IP address for all databases. /// </summary> /// <param name= "IP" >the specified IP address. </param> /// <param name= "username" >the user name of the login database. </param> /// <param name= "password" >the password for the login database. </param> /// <returns>Returns a list that contains the data instance name. </returns> PrivateArrayList Getalldatabase (stringIpstringUsernamestringpassword) {ArrayList dbnamelist=NewArrayList (); SqlConnection Connection=NewSqlConnection (String.Format ("Data source={0};initial Catalog = master; User ID = {1}; PWD = {2}", IP, username, password)); DataTable dbnametable=NewDataTable (); SqlDataAdapter Adapter=NewSqlDataAdapter ("select name from Master. sysdatabases", Connection); Lock(Adapter) {Adapter.fill (dbnametable); } foreach(DataRow rowinchdbnametable.rows) {dbnamelist.add (row["name"]); } connection.close (); returndbnamelist; }
C # gets all DB instance names for the specified IP address database