Using the Data Link Properties Dialog Box

[ Team LiB ] Recipe 1.13 Using the Data Link Properties Dialog Box Problem You want to display the Data Link Properties dialog box from an application so that users can create their own database connections just as they can from the Server Explorer window in the Visual Studio .NET IDE.
Nội dung trích xuất từ tài liệu:
Using the Data Link Properties Dialog Box [ Team LiB ]Recipe 1.13 Using the Data Link Properties Dialog BoxProblemYou want to display the Data Link Properties dialog box from an application so that userscan create their own database connections just as they can from the Server Explorerwindow in the Visual Studio .NET IDE.SolutionUse COM interop with the OLE DB Service Component to display the Data LinkProperties dialog box.Youll need a reference to the Primary Interop Assembly (PIA) for ADO provided in thefile ADODB.DLL; select adodb from the .NET tab in Visual Studio .NETs AddReference Dialog. Youll also need a reference to the Microsoft OLE DB ServiceComponent 1.0 Type Library from the COM tab in Visual Studio .NETs Add ReferenceDialog.The sample code contains a single event handler:Data Link Dialog Button.Click Creates and displays a Data Link Properties dialog box using the Microsoft OLE DB Service Component through COM interop.The C# code is shown in Example 1-10.Example 1-10. File: DataLinkDialogForm.cs// Namespaces, variables, and constantsusing System;// . . .private void dataLinkDialogButton_Click(object sender, System.EventArgs e){ ADODB.Connection conn = new ADODB.Connection( ); object oConn = (object) conn; MSDASC.DataLinks dlg = new MSDASC.DataLinks( ); dlg.PromptEdit(ref oConn); connectionStringTextBox.Text = conn.ConnectionString;}DiscussionCOM interop can open a Data Link Properties dialog box allowing a user to select anOLE DB provider and set its properties. You can use the results programmatically toconstruct the connection string for an ADO.NET connection object at runtime with a GUI(graphical user interface).[ Team LiB ]