Click here to Skip to main content
11,496,146 members (1,097 online)
The site is currently in read-only mode for maintenance. Posting of new items will be available again shortly.
See more: C# VB.NET
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
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 23-Sep-12 23:19pm
Edited 23-Sep-12 23:32pm

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.

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

  Print Answers RSS
0 Dnyaneshwar@Pune 692
1 RyanDev 230
2 CHill60 208
3 Sascha Lefèvre 195
4 Sergey Alexandrovich Kryukov 124
0 Sergey Alexandrovich Kryukov 10,401
1 OriginalGriff 8,910
2 Sascha Lefèvre 3,899
3 Maciej Los 3,422
4 Richard Deeming 2,600

Advertise | Privacy | Mobile
Web04 | 2.8.150520.1 | Last Updated 24 Sep 2012
Copyright © CodeProject, 1999-2015
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100