Retrieve sqlserver instances Problem

[pampam110]

I have two instance name for SqlServer. I write this code :

SqlDataSourceEnumerator sqlserver = SqlDataSourceEnumerator.Instance;
DataTable dt = sqlserver.GetDataSources();
GridView1.DataSource = dt;
GridView1.DataBind();

but when i run it , i couldn't see the result! What Should i Do?

[]D @ []v[] []D @ []v[]

modified on Thursday, May 7, 2009 8:23 PM

[Abhijit Jana]

pampam110 wrote:

but when i run it , i couldn't see the result! What Should i Do?

Did you debug your code? What dt returns ?

cheers, Abhijit CodeProject MVP Web Site:abhijitjana.net

[pampam110]

thanks for reply :thumbsup: i named my datatable as dt, and put all sqlserver instance name in that. and then try to fill it in gridview! yeah, i debug it! but it didn't show any result. any idea?

[]D @ []v[] []D @ []v[]