How to Get Server name and instance name in c# and show in combobox

by

If you are interested in Sql Server you can use something like this:

using System.Data;
using System.Data.Sql;

var instances = SqlDataSourceEnumerator.Instance.GetDataSources();
foreach (DataRow instance in instances.AsEnumerable())
{
    Console.WriteLine($"ServerName: {instance["ServerName"]}; "+
       " Instance: {instance["InstanceName"]}");
}

More information about the SqlDataSourceEnumerator class you can find on MSDN.

Note:

This class will look into the local network for servers, if your network is large then there might be a delay in acquiring the response. Also for the empty string instance name, that should be the default instance for that SQL Server.

You can get this information using the SMO too, if you want.

More Related Contents:

  1. How To Access Two Databases in a Single connection String in C#?
  2. import csv file to sql database in c# window application without header row [duplicate]
  3. Unable to cast object of type ‘System.DBNull’ to type ‘System.String`
  4. Entity Framework .Remove() vs. .DeleteObject()
  5. Bulk-deleting in LINQ to Entities
  6. How do I connect to an .mdf (Microsoft SQL Server Database File) in a simple web project?
  7. How to disable cascade delete for link tables in EF code-first?
  8. c# working with Entity Framework in a multi threaded server
  9. Local database, I need some examples
  10. Use the dynamic keyword/.NET 4.6 feature in Unity
  11. How can I update a cell value in a dB table, using SQL Server CE and C# (Visual Studio 2010)
  12. Received an invalid column length from the bcp client for colid 6
  13. How to use TransactionScope in C#?
  14. Invalid column name sql error
  15. Bulk copy a DataTable into MySQL (similar to System.Data.SqlClient.SqlBulkCopy)
  16. How to create an Access database at runtime in C#?
  17. How to use textbox to search data in data grid view?
  18. How to COUNT rows within EntityFramework without loading contents?
  19. How do I test database-related code with NUnit?
  20. Best way to save a ordered List to the Database while keeping the ordering
  21. Check if list contains item from other list in EntityFramework
  22. Entity Framework core – Contains is case sensitive or case insensitive?
  23. Can I commit changes to actual database while debugging C# in Visual Studio?
  24. Will a using block close a database connection?
  25. How to use String property as primary key in Entity Framework
  26. What is the fastest way to read data from a DbDataReader?
  27. Could not load file or assembly ‘MySql.Data, Version=6.2.2.0
  28. Populate TreeView from DataBase
  29. Is it possible to perform joins across different databases using LINQ?
  30. Databind a dropdownlist

Leave a Comment