添加引用:
1. Microsoft OLE DB Service Component 1.0 Type Library
2. Microsoft ActiveX Data Objects 2.8 Library
编写代码:
string connString = "";
DataLinks dlDlg = new DataLinks();
ADODB.Connection conn = new ADODB.Connection();
try
{
if (connString == "")
{
conn.ConnectionString = @"Provider=SQLOLEDB.1;";
}
object oConn = conn;
if (dlDlg.PromptEdit(ref oConn))
{
txtPortalDBConnString.Text = connString;
}
return true;
}
catch (COMException ex)
{
return false;
}