Using VB.net and ASP.net with dynamic checkboxes to check the checked status within a Gridview where created with a placeholder

Please remove Checked="false" code from ASPX page and try to handle it from the code.

The way I have it set up, the check box is not declared until I press the delete button and then its declared for each line in the Grid View. I tried just leaving it out of the aspx but it still returns false every time.

Now the delete button is not actually deleting anything from the database its simpy updating the record with a field that says its deleted and the date it was deleted. This allows me to keep track of the records that where deleted and but when the dataset repopulates it only looks for those records who are false in the deleted field.

so the button declares the check box as a row/cell/find control
then runs the if statement to seeif it isnot nothing and if it is checked or not

this is where it always returns false even if it isnt false

Ok Ive tried moving where I declaired the checkbox and put it in its own sub and also putting it in the load page sub with no luck. I still always end up with the checked property staying false.

Hi,
   
     From the VB code when you are lopping through the grid rows are you able to access other row values from the grid?

Yes I am and I woujld be willing to use the boolean field that the checkbox updates to represent the value if I could get it to show up as a checkbox and not a string that says true or false but either way I need to be able to check the checkbox and then do an action on the row.

For Each tr In GridViewID.Rows
  Dim cb As CheckBox = GridViewID.Rows(RowCounter).Cells(0).FindControl("CheckBoxID") <-- Row counter will increase only if the row is checked.
  If cb IsNot Nothing And cb.Checked = True Then
    'Code to pull data from GridViewID and compare to DB
    'Code to Update MySQL Database
    RowCounter = +1
  End If
next

Why dont you do like this. This should loop through all the rows.

For Each tr In GridViewID.Rows
  Dim cb As CheckBox = tr .Cells(0).FindControl("CheckBoxID")
  If cb IsNot Nothing And cb.Checked = True Then
    'Code to pull data from GridViewID and compare to DB
    'Code to Update MySQL Database
    End If
next

let us know if this is still an issue.

Nope, it is still saying that the checkboxes are false.

I added a messagebox under the for each statement which gives performs simply msgbox(convert.tostrting(cb.checked)) and for each line it returns false wether its checked or not.

I also simplified the equation and tried making the if statement just if cb.checked = true but there was not difference there either.

For some reason its just not reporting the checkboxes checked status

And also shouldn't the find control be like this

Tr.findcontrol("checkboxid"$

And also shouldn't the find control be like this

Tr.findcontrol("checkboxid")

I changed it but it still returns false on every line.

Here is the actual code for the top of the sub. Ignore all of the commented out stuff, its from past failed attempts.

    Sub DeleteOffice()
        ' Dim dt As DataTable 'requires  system.data to be imported
        Dim SomethingToDelete As Boolean = False
        Dim TestString As String = ""
        Dim tr As TableRow
        For Each tr In GVShowData.Rows
            '    cb = GVShowData.Rows(RowCounter).Cells(0).FindControl("chkDeleteOffice")
            Dim cb As CheckBox = tr.FindControl("chkDeleteOffice")

            'cb.AutoPostBack = True
            ' AddHandler cb.CheckedChanged, AddressOf cb_CheckedChanged
            ' Me.Form.Controls.Add(cb)

            'cb.ID = "chkOfficeDeleted"
            'cb.EnableViewState = True
            ' AddHandler cb.Checked, AddressOf cb_Checked
            ' cb.Attributes(ViewState(Checked))
            MsgBox("About to perform If Statement: cb.cheked=" & Convert.ToString(cb.Checked))
            'If cb IsNot Nothing And cb.Checked = True Then
            If cb.Checked = True Then
                MsgBox(Convert.ToString(cb.Checked))



Here is the actual code of the gridview in the aspx file.
The two databoud items are there for testing purposes
   
                <asp:GridView ID="GVShowData" runat="server">
                    <Columns>
                       <asp:TemplateField HeaderText="Delete Office">
                        <ItemTemplate>                    
                                 <asp:CheckBox ID="chkDeleteOffice" runat="server" enabled="true" />                                                
                        </ItemTemplate>

                       </asp:TemplateField>
                       
                       <asp:BoundField DataField="Date" DataFormatString="{0:d}" HtmlEncode="false" />
                       <asp:BoundField DataField="WorkDone" />
                       
                       
                    </Columns>
                </asp:GridView>

Try tr As GridViewRow instead of TableRow

Unfortunately that didn't work either. I'm going to have to hire someone who will let me pull their hair out soon because I don't know if I'm going to have any left soon.

I think I tried that once before but Im not sure.

That's how I normally do. May be there is something I am missing out.

Ill post the entire project for the time being at http:www.cristinarush.com/SS.rar
Ill take it down before I close this issue out.

Cristy

woops
http://www.cristinarush.com/SS.rar

Ok I deleted the link and rewrote the code in a new project and Im having the same issue.
The vb code and aspx code are in two different code snippets bellow. This is the full code of the test project. Its very small and easy to look at.

<%@ Page Language="VB" AutoEventWireup="false" CodeFile="Default.aspx.vb" Inherits="_Default" %>

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">

<html xmlns="http://www.w3.org/1999/xhtml">
<head runat="server">
    <title>GridViewWithCheckBoxesTestSite</title>
</head>
<body>
    <form id="form1" runat="server">
    <div>    
        <asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false">
            <Columns>
                <asp:TemplateField HeaderText="Checked?">
                    <ItemTemplate>
                        <asp:CheckBox ID="chkChecked" runat="server" enabled="true" />
                    </ItemTemplate>
                </asp:TemplateField>     
                
                <asp:BoundField DataField="Date" HeaderText="Date" DataFormatString="{0:d}" HtmlEncode="false" />
                <asp:BoundField DataField="Name" HeaderText="Name" HtmlEncode="false" />
                         
            </Columns>
        </asp:GridView>
    </div>
    <asp:Button ID="btnDelete" runat="server" Text="Delete and Update" />
    </form>
</body>
</html>

Select allOpen in new window

Imports MySql.Data.MySqlClient
Imports System.Data.SqlClient
Imports System.IO
Imports System.Data
Partial Class _Default
    Inherits System.Web.UI.Page
    Dim con As New MySqlConnection
    Dim ds As New Data.DataSet



    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        GetData()
        MsgBox("test")
    End Sub

    Sub DBConnect()
        con.ConnectionString = "data source=server1 ; database=status; uid=root; Password=UndisclosedPassword;"
        con.Open()
    End Sub

    Sub DBClose()
        con.Close()
        con.Dispose()
    End Sub

    Sub GetData()
        GridView1.DataSource = ""
        ds.Clear()
        DBConnect()
        Dim GetDataDataAdapter As New MySqlDataAdapter("Select Date, Name From transaction", con)
        GetDataDataAdapter.Fill(ds, "transaction")
        GridView1.DataSource = ds.Tables("transaction")
        GridView1.DataBind()
        DBClose()
    End Sub

    Sub CheckForCheckMark()
        Dim RowCounter As Integer = 0
        Dim tr As GridViewRow
        For Each tr In GridView1.Rows
            Dim cb As CheckBox = tr.FindControl("chkChecked")
            ' MsgBox(Convert.ToString(cb.Checked))
            If cb.Checked = True Then
                MsgBox("Row " & RowCounter & "is checked!")
            Else
                MsgBox("Row " & RowCounter & "is not checked!")
            End If
            RowCounter = RowCounter + 1
        Next
        RowCounter = 0
    End Sub

    Protected Sub btnDelete_Click(ByVal sender As Object, ByVal e As System.EventArgs) Handles btnDelete.Click
        CheckForCheckMark()
    End Sub
End Class

Select allOpen in new window

Thank you soooooooo much. I knew it was something stupid simple I was missing and I didnt even think about the page reloading when the button was clicked and it re-retrieving the data.

Just a note I also had to add the getdata() to the end of the deleteoffice sub to refresh the datagrid after it was deleted, before I was relying on the one in the page_load. Thats actually why it was there in page_load