<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
<script type="text/javascript">
</script><script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
怎么实现这个功能大家肯定早都知道了,放上来是给自己留个备份使用:
private void button1_Click_1(object sender, System.EventArgs e)...{ string[] servers = DBGrep.SqlLocator.GetServers(); foreach ( string s in servers ) ...{ this.listBox1.Items.Add(s); }}类的代码
using System;using System.Text;using System.Windows.Forms;using System.Runtime.InteropServices;namespace DBGrep...{ public class SqlLocator ...{ [DllImport("odbc32.dll")] private static extern short SqlAllocHandle(short hType, IntPtr inputHandle, out IntPtr outputHandle); [DllImport("odbc32.dll")] private static extern short SqlSetEnvAttr(IntPtr henv, int attribute, IntPtr valuePtr, int strLength); [DllImport("odbc32.dll")] private static extern short SqlFreeHandle(short hType, IntPtr handle); [DllImport("odbc32.dll",CharSet=CharSet.Ansi)] private static extern short SqlBrowseConnect(IntPtr hconn, StringBuilder inString, short inStringLength, StringBuilder outString, short outStringLength, out short outLengthNeeded); private const short Sql_HANDLE_ENV = 1; private const short Sql_HANDLE_DBC = 2; private const int Sql_ATTR_ODBC_VERSION = 200; private const int Sql_OV_ODBC3 = 3; private const short Sql_SUCCESS = 0; private const short Sql_NEED_DATA = 99; private const short DEFAULT_RESULT_SIZE = 1024; private const string Sql_DRIVER_STR = "DRIVER=Sql SERVER"; private SqlLocator()...{} public static string[] GetServers() ...{ string[] retval = null; string txt = string.Empty; IntPtr henv = IntPtr.Zero; IntPtr hconn = IntPtr.Zero; StringBuilder inString = new StringBuilder(Sql_DRIVER_STR); StringBuilder outString = new StringBuilder(DEFAULT_RESULT_SIZE); short inStringLength = (short) inString.Length; short lenNeeded =