SqlCeException
Application:Run+0xf
Form1:Main+=xd
Ma così è corretto? cioè, crea la tabella è inserisce?
codice:
Private Sub cmdCreate_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles cmdCreate.Click
Dim create As String
If (System.IO.File.Exists(db)) Then
System.IO.File.Delete(db)
End If
Try
Dim eng As SqlCeEngine
eng = New SqlCeEngine("Data Source=" + db)
eng.CreateDatabase()
create = "CREATE TABLE UgiUser(Firstname nvarchar(10) PRIMARY KEY not null,Surname nvarchar(20) not null,Age int not null)"
ExecSql(create)
ExecSql("INSERT INTO UgiUser VALUES ('" & Me.txtName.Text & "','" & Me.txtSurname.Text & "','" & Me.txtAge.Text & "')")
MsgBox("Table UgiUser created.")
Catch exc As SqlCeException
MsgBox(exc.Message)
End Try
End Sub