/// <summary> /// Get SQL Server Instances if possible /// </summary> private static string[] GetSQLServerInstances() { List<string> instances = new List<string>(); try { System.Data.Sql.SqlDataSourceEnumerator instance = SqlDataSourceEnumerator.Instance; System.Data.DataTable table = instance.GetDataSources(); foreach (System.Data.DataRow row in table.Rows) { instances.Add(row[0] + "\\" + row[1]); } } catch (Exception) { } return instances.ToArray(); }
world wide web development problems asp net php html xhtml css javascript jquery w3dproblems
Saturday, June 14, 2014
How to get list of available SQL Servers instances using C#
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment