Member Avatar for jackiejoe

I can insert into my table by the bindingnavigator and dragging textboxes straight from the DataSet entering them and saving. But I want to insert into the DataBase via code and in order to do this I have used the below code to connect. I use this code to test the connection and cannot get it to connect. Just get the error to say the DB cannot be found.
No username or password on the DB
Any ideas or am I missing something? Thanks,

Private Sub btnDB_Click_1(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles btnDB.Click
        Dim connString As String = "Data Source=C:\Visual Studio 2008\Projects\CollegeBetfair\BetfairDB.sdf"
        Dim myDB As New SqlConnection(connString)
        Try
            myDB.Open()
        Catch ex As Exception
            MessageBox.Show(ex.Message)
        End Try
        If myDB.State = 1 Then
            MessageBox.Show("Connected")
        End If
    End Sub
Edited by jackiejoe because: n/a
  • 2 Contributors
  • 1 Reply
  • 93 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by samir_ibrahim
Member Avatar for samir_ibrahim

I believe that you had used SQLClient() and you should use
SqlServerCe.SqlCeConnection

Try that.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.