VB.Net - Update Data From DataGridView

Update Data From DataGridView - Masih dengan menggunakan database DbCoba dan tabel TabelBarang.

• Bukalah project Visual Studio 2005, klik file, pilih New Project, Visual Basic, Windows Application,Ok.

• Drag n drop DataGridView ke form.

• Double klik form, pada event load, copas code berikut :

cn = New SqlConnection("server=(local)\sqlexpress;database=DbCoba;uid=UserId Anda;pwd=PasswordAnda")
cn.Open()
da = New SqlDataAdapter("select * from TabelBarang", cn)
dt = New DataTable
da.Fill(dt)
DataGridView1.DataSource = dt

• Pada object DataGridView1 dan event CellValueChanged copas code berikut :

           cm = New SqlCommand("Update TabelBarang set Nama='" & 
                    DataGridView1.CurrentRow.Cells(1).Value & "' where Kode='" & 
                    DataGridView1.CurrentRow.Cells(0).Value & "'", cn)
          cm.ExecuteNonQuery()

          MessageBox.Show("Success", "Information", MessageBoxButtons.OK,MessageBoxIcon.Information)

• Selamat Mencoba  

Tweet