help, i'm working on a update function on my aplication program using visual studio ultimate 2012 VB.
after i fixed the error on my coding, i debug the program with f5. but, when i tried to update the data on the datagridview it doesn't change even thought the messagebox "data has been updated" show up.
how do i fix this problem?
here is the coding for update function:
form1:
Private Sub Button1_Click(sender As Object, e As EventArgs) Handles Button1.Click
ClassSiswa.ubahdata(New SqlConnection, (txt_nis.Text), (txt_nisn.Text), (txt_namasiswa.Text), (cmb_kelaminsiswa.Text), (txt_kotalahir.Text), (DTP_siswa.Text), (cmb_agamasiswa.Text), (txt_beratsiswa.Text), (txt_tinggi_badan.Text))
datagridview()
End Sub
Private Sub UpdateDataSiswa()
ClassSiswa.Nis = txt_nis.Text
ClassSiswa.Nisn = txt_nisn.Text
ClassSiswa.Nama_Siswa = txt_namasiswa.Text
ClassSiswa.Tanggal_Lahir = DTP_siswa.Text
ClassSiswa.Jenis_Kelamin = cmb_kelaminsiswa.Text
ClassSiswa.Kota_Lahir = txt_kotalahir.Text
ClassSiswa.Agama = cmb_agamasiswa.Text
ClassSiswa.Tinggi_Badan = txt_tinggi_badan.Text
ClassSiswa.Berat_Badan = txt_beratsiswa.Text
ClassSiswa.Updatesiswa(ClassSiswa.opencon, (txt_nis.Text))
datagridview()
End Sub
classSiswa:
Public Shared Sub ubahdata(ByVal _cn As SqlClient.SqlConnection, ByVal _Nis As String, ByVal _Nisn As String, ByVal _nama_siswa As String, ByVal _jenis_kelamin As String, ByVal _kota_lahir As String, ByVal _tanggal_lahir As String, ByVal _agama As String, ByVal _berat_badan As String, ByVal tinggi_badan As String)
Dim sql As New SqlClient.SqlCommand
sql.Connection = _cn
sql.CommandType = CommandType.Text
sql.CommandText = "update siswa set nis='" & Nis & "',nisn='" & Nisn & "',nama_siswa='" & Nama_Siswa & "',jenis_kelamin='" & Jenis_Kelamin & "' ,kota_lahir='" & Kota_Lahir & "',tanggal_lahir='" & Tanggal_Lahir & "'agama='" & Agama & "'berat_badan='" & Berat_Badan & "',tinggi_badan='" & tinggi_badan & "'"
MessageBox.Show(" Data Telah Diupdate")
ClassSiswa.closecon()
End Sub
Public Shared Sub Updatesiswa(ByVal _Cn As SqlClient.SqlConnection, ByVal _nis As String)
Dim sql As SqlClient.SqlCommand
sql = New SqlClient.SqlCommand
sql.Connection = _Cn
sql.CommandType = CommandType.Text
sql.CommandText = "Update siswa Set nis = '" & Nis & "', nisn = '" & Nisn & "' where nis = '" & _nis & "'"
sql.ExecuteNonQuery()
End Sub
this is the codin for opening connection:
classKoneksi:
Imports System.Data.SqlClient
Imports System.Data.Sql
Imports System.Data
Imports System.Configuration
Public Class ClassKoneksi
Public Shared cmd As SqlClient.SqlCommand
Public Shared CN As SqlClient.SqlConnection
Public Shared _NamaDatabase As String
Public Shared Property namadatabase As String
Get
Return _NamaDatabase
End Get
Set(value As String)
_NamaDatabase = value
End Set
End Property
Public Shared Function opencon() As SqlClient.SqlConnection
CN = New SqlClient.SqlConnection
CN.ConnectionString = "Data Source=RICKY-PC\LENOVOSQL;Initial Catalog=KPIRWAN;Integrated Security=True "
CN.Open()
Return CN
End Function
Public Shared Sub closecon()
CN.Close()
CN.ConnectionString = Nothing
End Sub
End Class
and this is the sql query in sql server:
Create Database KPIRWAN
use KPIRWAN
Create Table siswa
(
Nis int primary key,
Nisn int,
Nama_Siswa varchar(40),
Jenis_Kelamin varchar (10),
Kota_Lahir varchar (10),
Tanggal_Lahir date,
Agama varchar (10),
Berat_Badan int,
Tinggi_Badan int)
Create Table Pengguna (Nama Varchar(40), Sandi Varchar(40))
insert into Pengguna values('123','456')
insert into pengguna values('mdp','123')
select*from siswa
select*from Pengguna