Hi, I am using a gridview with a templatefield containing a checkbox.
I want to update the database with a 1 or 0 depending on if a checkbox is checked or unchecked (then use the 1 or 0 later on another page)..i have been google around and found this....

If e.Row.RowType = DataControlRowType.DataRow Then

Dim Chk As CheckBox = e.Row.FindControl("CheckBox1")

just dont know what to do next...Any ideas?

__________________
www.nursery-net.com

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"

            End If

            If Chk.Checked = False Then
                MyCommand.CommandText = "update support.support set save = 0"

            End If

        End If

        MyCommand.ExecuteNonQuery()

        MyConnection.Close()

        MyCommand = Nothing

but when i run it i get this error....

ExecuteNonQuery: CommandText property has not been initialized

www.nursery-net.com