| Welcome to WebmasterWorld Guest from 126.96.36.199 |
register, login, search, subscribe, help, library, PubCon, announcements, recent posts, open posts,
|Subscribe to WebmasterWorld|
|Connect to sdf file with vb|
| 8:50 pm on Nov 8, 2011 (gmt 0)|
I've done a lot with regular (mdf) sql databases but never anything with sdf files. When I run this code, I get no error, but if I check the database, nothing get's inserted. Any ideas?
Dim connStr As New SqlCeConnection("Data Source=" & Application.StartupPath & "\Database1.sdf;")
'the sql syntax
Dim sql = "INSERT INTO Cowboys(CowboyLastName, CowboyFirstName, ContactInfo, Headers, Heelers) " & _
"Values('" & lastName & "', '" & firstName & "', '" & contactInfo & "', '" & header & "', '" & heeler & "')"
Dim cmd_All_Data As New SqlCeCommand(sql, connStr)
Catch ex As Exception
success = False
output.Text = ex.ToString
All trademarks and copyrights held by respective owners. Member comments are owned by the poster.
WebmasterWorld ® and PubCon ® are a Registered Trademarks of Pubcon Inc.
© Pubcon Inc. 1996-2012 all rights reserved