Passing values in XML file to VB.NET Application

Question

0.00/5 (No votes)

See more:

Hi,

In the application that I have created, I need to pass the connection string value so that I can connect to a remote database server.

I don't want to hard code the values because the application will be permanently bound to a particular server.

I want to specify the connection string values in the XML file, but how should I retrieve it from the application?

Also can I write values from the application into the XML file?

Please help me!
Thank You.

Posted 22-Aug-10 23:39pm

Wanlambok

Updated 23-Aug-10 8:35am

Deeksha Shenoy

v3

Add a Solution

Comments

Dalek Dave 23-Aug-10 5:41am

Edited for Grammar and Syntax.

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wayne Gaylard · Answer 1 · 2010-08-23T00:52:00

Ideally you should store your connection strings in the Application Settings File and retrieve them in your application by using My.Application.Settings.strConnection assuming your connection string is saved as strConnection. To set up your settings file, right click on your project in Solutions Explorer and select Properties. In the properties page that comes up select the Settings tab and you can save your connection string there. Under Type you can select Connection String.
Hope this helps
Happy Coding.

Wayne Gaylard · Answer 2 · 2010-08-23T00:55:00

Ideally you should store your connection strings in the Application Settings File and retrieve them in your application by using My.Application.Settings.strConnection assuming your connection string is saved as strConnection. To set up your settings file, right click on your project in Solutions Explorer and select Properties. In the properties page that comes up select the Settings tab and you can save your connection string there. Under Type you can select Connection String.
Hope this helps
Happy Coding.

Wayne Gaylard · Answer 3 · 2010-08-23T00:56:00

Ideally you should store your connection strings in the Application Settings File and retrieve them in your application by using My.Application.Settings.strConnection assuming your connection string is saved as strConnection . To set up your settings file, right click on your project in Solutions Explorer and select Properties. In the properties page that comes up select the Settings tab and you can save your connection string there. Under Type you can select Connection String.
Hope this helps
Happy Coding.

Christian Graus · Answer 4 · 2010-08-22T23:42:00

Solution 1

What do you know about XML ? XML is just a string. You can read and write XML data quite trivially in VB.NET. You can use the XmlDocument class and the DOM to do that, that's probably the easiest and most widely documented way.

Posted 22-Aug-10 23:42pm

Christian Graus

Passing values in XML file to VB.NET Application

4 solutions

Solution 2

Solution 3

Solution 4

Solution 1

Add your solution here

Preview 0