CheckBoxField in GridView

ramuis78 · July 6th, 2006, 05:13 PM

Here is my gridview code:

    <asp:GridView HorizontalAlign=left Width="98%" ID="GVAIns" AllowSorting="False" runat="server" AutoGenerateColumns="False">
      <Columns>
        <asp:BoundField HeaderText="Institution_ID" DataField="Institution_ID" SortExpression="Institution_ID" Visible=false />
        <asp:BoundField HeaderStyle-HorizontalAlign=center HeaderText="Institution Name" DataField="Institution_Name" SortExpression="Institution_Name" />
        <asp:CheckBoxField ReadOnly="false" ItemStyle-HorizontalAlign=Center DataField="Day_Event_Exists" />
      </Columns>
    </asp:GridView>

i think by default checkboxes are disabled. I want to enable all checkbox items, so that user can check or uncheck. How can i do that and how can i retrieve these values?

Any help greatly appreciated.
Thanks

jbenson001 · July 7th, 2006, 10:52 PM

set the checked property to true for the checkbox.

To get the values, you need to use the RowDataBound event and get a reference to the checkbox and get it's checked state(True or False)

ramuis78 · July 8th, 2006, 02:45 PM

Thank you for your quick reply. it works

jbenson001 · July 8th, 2006, 02:49 PM

Glad to help :)
JIm

mike7510uk · December 12th, 2006, 05:34 AM

can i please see your working code for this?

ramuis78 · December 12th, 2006, 11:23 AM

Sorry. We have modified our code and no longer we are using checkboxes and hence i don't have working code for this. Please tell here your problem, so that we can figure it out.

Thanks

Rams

mike7510uk · December 12th, 2006, 11:27 AM

i have a gridview with several columns and a templatefield containing a checkbox. when the user clicks the checkbox i want to update the database with a 1 (if checked) or a 0 (if unchecked). also, it must only update the row that was checked and not the entire thing

www.nursery-net.com

ramuis78 · December 12th, 2006, 11:54 AM

you can find that checkbox using gridview item. find method for each row and use .checked method whether its checked or not.. and update your database.

Thanks
Rama

Rams

mike7510uk · December 12th, 2006, 11:57 AM

i tried that already and cant get it to work...here is code i have so far...

Code:

Protected Sub GridView1_RowDataBound(ByVal sender As Object, ByVal e As System.Web.UI.WebControls.GridViewRowEventArgs) Handles GridView1.RowDataBound

        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.Cells(5).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


            MyCommand.ExecuteNonQuery()

            MyConnection.Close()

            MyCommand = Nothing



            'MsgBox(Chk.Checked) 



        End If

    End Sub

www.nursery-net.com

gbianchi · December 12th, 2006, 12:03 PM

hi there.. you only want to update the DB only when the user click any of the checkboxes?

b/c you are using the wrong event if that is the case..

HTH

Gonzalo