I have been playing around with it and have this in my code behind..
Dim MyConnection As OdbcConnection
MyConnection = New OdbcConnection() 'declare new connection object
MyConnection.ConnectionString = "" 'database connect string
MyConnection.Open() 'open connection to database
Dim MyCommand As New OdbcCommand() 'declare new command object
MyCommand.Connection = MyConnection
If e.Row.RowType = DataControlRowType.DataRow Then
Dim Chk As CheckBox = e.Row.FindControl("save")
If Chk.Checked = True Then
MyCommand.CommandText = "update support.support set save = 1"
If Chk.Checked = False Then
MyCommand.CommandText = "update support.support set save = 0"
MyCommand = Nothing
but when i run it i get this error....
ExecuteNonQuery: CommandText property has not been initialized