- Beranda
- Komunitas
- Tech
- Programmer Forum
Syntax Input data ke database access di vb net 2010 ???
TS
XionAngelo
Syntax Input data ke database access di vb net 2010 ???
Gan ane mau tanya
syntax untuk input data ke data base access pada vb net 2010 itu bener ga gan kayak gini ?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sqltambah As String = "INSERT INTO Siswa values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox14.Text & "'," & ComboBox1.DropDownStyle & "')"
'Dim sqltambah As String = "INSERT INTO Siswa values ('b','d','v','t','y','u','u','z','a','s','q','s','g')"
cmd = New OleDbCommand(sqltambah, conn)
cmd.ExecuteNonQuery()
Call tampilkan()
End Sub
mohon penjelasannya terhadap kesalah syntax ini karena ketika saya jalankan programnya syntaxnya error di cmd.ExecuteNonQuery()
dan erronya tertulis ExecuteNonQuery: Connection property has not been initialized.
maap gan masih newbie jadi ga bisa ngasih pic
mohon bantuannya gan
syntax untuk input data ke data base access pada vb net 2010 itu bener ga gan kayak gini ?
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click
Dim sqltambah As String = "INSERT INTO Siswa values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & TextBox4.Text & "','" & TextBox5.Text & "','" & TextBox6.Text & "','" & TextBox7.Text & "','" & TextBox8.Text & "','" & TextBox9.Text & "','" & TextBox10.Text & "','" & TextBox11.Text & "','" & TextBox12.Text & "','" & TextBox14.Text & "'," & ComboBox1.DropDownStyle & "')"
'Dim sqltambah As String = "INSERT INTO Siswa values ('b','d','v','t','y','u','u','z','a','s','q','s','g')"
cmd = New OleDbCommand(sqltambah, conn)
cmd.ExecuteNonQuery()
Call tampilkan()
End Sub
mohon penjelasannya terhadap kesalah syntax ini karena ketika saya jalankan programnya syntaxnya error di cmd.ExecuteNonQuery()
dan erronya tertulis ExecuteNonQuery: Connection property has not been initialized.
maap gan masih newbie jadi ga bisa ngasih pic
mohon bantuannya gan
0
3.6K
8
Komentar yang asik ya
Urutan
Terbaru
Terlama
Komentar yang asik ya
Komunitas Pilihan