using connection stirng

[aradhanathawait]

hi....

How to use the connection string specified in app.config file in a windows form in c#. Please help.

Regards,
Aradhana

[teddarr]

include using System.Configur ation;

Then put your connection string in the web.config file in the connectionStrin gs node.

example:

<add name="nameOfCon String" connectionStrin g="Server=serve rName;Database= DbName;" providerName="S ystem.Data.SqlC lient"/>

After that you will need to add a reference to either Windows.Configu ration or System.Configur ation.

After that add a line in your class to give a global variable, or declare it in each method, or the constuctor...wh ichever you prefer.

The line is:

Dim conn As New SqlConnection(C onfigurationMan ager.Connection Strings("nameOf ConString").Con nectionString)

or

SqlConnection conn = ConfigurationMa nager.Connectio nStrings("nameO fConString").Co nnectionString;

It's a very handy technique that you will find yourself using from here on out.

[Curtis Rutland]

in C# that would be:

SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["name"].ConnectionString;

[teddarr]

see what vb is doing to my brain.

Thanks for the correction. :)