vb.net db connection

Question

1.00/5 (1 vote)

See more:

plz provide me the code for connecting the database to my vb.net forms. i have created my database in Sql server 2005. plz help

Posted 8-Mar-12 22:20pm

Meenu Prasad

Updated 1-Apr-20 15:59pm

Add a Solution

Comments

Member 8327439 15-Mar-12 2:49am

Just a note,
If you are connecting to a free online sql server you may not have the permissions to do that, however you should be able to connect to a Localhost sql server for testing and all that.
It took me a bit to get a vb.net to sql connection string in some of my first projects I was working on.

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

Dnyanesh Wahiley · Answer 1 · 2012-03-08T22:25:00

VB

Dim strConnection As String = "data source=(local);initial catalog=testDB; user id=sa; password=1234;"
Dim objConnection As New SqlConnection(strConnection)

Dim strSQL As String = "SELECT * from tblTest;"
Dim objCommand As New SqlCommand(strSQL, objConnection)

objConnection.Open()

Response.Write("ServerVersion: " & objConnection.ServerVersion & _
vbCrLf & "Datasource: " & objConnection.DataSource & _
vbCrLf & "Database: " & objConnection.Database)

DataGrid1.DataSource = objCommand.ExecuteReader()
DataGrid1.DataBind()
objConnection.Close()

Here is some demo program code which i have mentioned here to clear the concept of sql connectivity with vb.net..!
Regards..!
Dnyanesh

walterhevedeich · Answer 2 · 2012-03-08T22:31:00

What have you tried? I can only provide links, or code snippets to fix the code of the people asking the question, but I don't always provide code. And even if I did, I'm not sure if it helped because I'm not sure you will understand. I suggest you start reading this[^] tutorial. It includes basic code snippets on how to add, update, and delete records on your database using Winforms and VB.Net. MSDN[^] has also good articles regarding the topic. If you need more resources, you can always visit Google[^] and be amazed at the abundance of information that you can get.

Isuru Nanayakkara · Answer 3 · 2012-03-09T00:52:00

Solution 3

all you need to know about ADO.NET is here
To create your connection string check here

Posted 9-Mar-12 0:52am

Isuru Nanayakkara

vb.net db connection

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0