调用系统的数据链接属性对话框

先在项目中添加Microsoft OLE DB Service Component 1.0 Type Library和Microsoft ActiveX Data Objects 2.x Library的COM的引用。然后调用下面的函数就可以了。

 public static string PromptDataSource(int hWnd, string connectionString)
  {
   MSDASC.DataLinks dl = new MSDASC.DataLinksClass();
   ConnectionClass conn = new ConnectionClass();
   conn.ConnectionString = connectionString;
   object oConn = conn;
   dl.hWnd = hWnd;
   dl.PromptEdit(ref oConn);
   
   return conn.ConnectionString;
  }