Save & Retrieve data from SQL without define connection string

Question

2.00/5 (1 vote)

See more:

Hi.. friends is that possible in vb.net that we can save or retrieve data from sql without define the connection string only in single table if it is possible then tell me how, please I need the help of you.

Thanks in advance

Parveen Rathi

Posted 20-Sep-11 0:02am

Parveen Rathi

Add a Solution

Comments

nagendrathecoder 20-Sep-11 6:05am

What do your mean by "only in single table"??

Parveen Rathi 20-Sep-11 6:30am

I want a table to store data which not use the sql connection string, because it can be changed

Prerak Patel 20-Sep-11 6:06am

No, you can't.

2 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)

Toniyo Jackson · Answer 1 · 2011-09-20T00:07:00

No. Not possible. Without using connection string your program will not identify the server, database, table.

If you don't want to define the connection string in web.config file, you can directly use the connection string in the SqlConnection object.

SQL

Dim sqlCon as New SqlConnection("server='servername';Initial Catalog='databasename';user id='username';password='password'")

Mehdi Gholam · Answer 2 · 2011-09-20T00:12:00

Solution 2

You can broadcast a UDP request and get back your connection string from a server at runtime, circumventing the need for a client side connection string.

Posted 20-Sep-11 0:12am

Mehdi Gholam

Comments

Herman<T>.Instance 20-Sep-11 6:13am

any resources to show to have this work?

Mehdi Gholam 20-Sep-11 6:55am

You have to create a windows service that listens to UDP request and sends a config file in return, great idea, I'm working on it.