Click here to Skip to main content
15,884,298 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more:
I'm Making Report Designer Its generate Report Of all type Of different database Like excel,access,sqlserver, oracle

But Problem Is that I'm Fail Getting All Sql Server Instance Name
My code giving only server name like PC name not Instance name like SQL Express

here My code
C#
public static SqlDataSourceEnumerator Instance = SqlDataSourceEnumerator.Instance; //Get server Names
public static DataTable Table = new DataTable();
Table = Instance.GetDataSources();

But Its Not Giving Instance Name
what wrong With My Code
Any Another Way To Get SQL Server Instance Name
Please............ Help Me Fast


thanks In Advance
Posted
Updated 23-Sep-12 22:32pm
v2

1 solution

Your code looks very similar to the example in MSDN[^].
Have you tried the second part (DisplayData()) as well?
Maybe the instance name is delivered in another column than the one you looked in.
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900