[HELP]Insert data pake VB.NET ke SQLServerCe

[Permenkaret]

gan minta bantuannya gan...

Ane mao tanya cara inser data pake VB.NET ke SqlServerCe...



ni ada potongan source code yang ane pake :



If con.State = ConnectionState.Closed Then con.Open()

cmd = New SqlServerCe.SqlCeCommand

cmd.Connection = con

cmd.CommandType = CommandType.Text

cmd.CommandText = "insert into [user] values('" & txtId.Text & "','" & txtName.Text & "','" & txtUsername.Text & "','" & txtPassword.Text & "')"

cmd.ExecuteNonQuery()

cmd.Dispose()

con.Close()



tapi kok g bisa masuk ke database ya gan???

ada yang tau kenapa?ato gimana cara bikin yg bener..

Minta pencerahannya gan...

Matur Nuwun