SqlException was unhandled

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

I am coding for a form which will send the value of the textboxes to the sql local database that i created. but an error occured (runtime) in the connection.open() part. What is the problem with my code:

VB

Imports System.Data.SqlClient

Public Class Form1
    Dim Connection As New SqlConnection("Data Source=C:\Users\user\AppData\Local\Temporary Projects\WindowsApplication1\Example.sdf")
    Dim Command As New SqlCommand
    Dim DataReader As SqlDataReader

    Private Sub Form1_Load(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles MyBase.Load
        Command.Connection = Connection
    End Sub

    Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
        Connection.Open()
        Command.CommandText = "INSERT INTO ExampleTable (FirstName, LastName) VALUES ('" & TextBox1.Text & "','" & TextBox2.Text & "')"
        Command.ExecuteNonQuery()
        Connection.Close()
    End Sub
End Class

Posted 11-May-13 9:03am

Emerson Tumibay

Add a Solution

Comments

Ron Beyer 11-May-13 15:21pm

What kind of database is it? Take a look at this site (http://www.connectionstrings.com/) for proper connection strings, but SqlConnection only connects to MS SQL databases.

[no name] 11-May-13 15:48pm

The error message would be a big clue as to what your problem is....

RedDk 11-May-13 17:21pm

An .sdf file ... ok. Here's what I'd do. Open THAT file in smsse just to make sure THAT'LL happen. Then work from the VBNET app side and see if its possible to create a connection string that'll match the instance just tapped manually.

Pay particular attention to how ssmse displays info about that new database. Much different than an .mdf.

1 solution

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)

OriginalGriff · Answer 1 · 2013-05-11T21:14:00

You don't open SDF files using SQL server - you use SqlCeConnection and SqlCeCommand objects instead:

VB

Using con As New SqlCeConnection("Data Source=C:\Users\griff\Documents\AA Backed Up\My Databases\StandardReplies.sdf")
	Using cmd As New SqlCeCommand("SELECT * FROM Replies", con)
                ...
	End Using
End Using