Visual Studio 2003: Insert Connection String Macro

In order to have a handy connection string creator added to your VS.NET for figuring out and inserting a string just where you need it in your code. I'm supplying this handy macro.

First....

Access the Visual Studio Macro Explorer and create a module.











Insert the following code in the module.

Imports EnvDTE
Imports System.Diagnostics

Public Module Module1
Public Sub InsertConnectionString()
Dim links As Object = CreateObject("DataLinks")
Dim cn As Object = CreateObject("ADODB.Connection")

links.PromptEdit(cn)
If cn.connectionstring = "" Then Exit Sub
Dim sel As TextSelection = ActiveDocument().Selection
sel.Text() = cn.connectionstring
End Sub
End Module

Then Save the macro.

When you are in a place during your coding that you wish to enter a connection string.

Execute the macro and it brings up the DataLink dialog box. which everyone using VS.NET should know how to use.


















Upon hitting ok

Your connection string will be entered from the clip board into the code where your cursor location waas prior to executing the macro.

Which in this example was in between two quotes after the strConnnectionString assignment.





Enjoy!

The Ron