Hello…

I’ve got MS Access (.mdb) database binding with a form , After doing database search query in vb.net form I want to set specific columns to null value by pressing a button and save these changes to the database table?

I Know the codes for clearing columns in the database table but I’m looking for clearing dataset columns!

Code:
Private Sub Button1_Click(ByVal sender As System.Object, ByVal e As System.EventArgs) Handles Button1.Click

            Dim Del As New OleDb.OleDbCommand
            Del.Connection = con
            Del.CommandType = CommandType.Text

            Del.CommandText = "UPDATE Table1 SET column4 = null , column5= null , column7= null , column21= null "

            con.Open()

            Del.ExecuteReader()

            con.Close()


            Refresh_Dataset2()

End Sub
Any idea PLZ

Regards…