There's a cool new .net 2.0 feature I didn't know about until I needed to do this a few days ago. If your application has FullTrust, you can use the System.Data.Sql.SqlDataSourceEnumerator to get a list of available SQL servers (2000 and 2005 only). The query returns a DataTable which you can just attach to a combobox or drop down list.
Dim instance As SqlDataSourceEnumerator = SqlDataSourceEnumerator.Instance Dim dt As DataTable = instance.GetDataSources()
Remember, though, this requires the assembly to have full trust. There is not a specific permission you can apply to use this otherwise.
See my speaking schedule for more events
User Group Leader
Hosted by:
Powered by: newtelligence dasBlog 2.0.7226.0
Disclaimer The opinions expressed herein are my own personal opinions and do not represent my employer's view in any way.
© Copyright 2008, Julie Lerman
E-mail