Datagird checkbox populating

[Paulson]

        Dim i As Integer
        Dim dr As SqlDataReader
        Dim objDataAccess As New DataAccess.DataAccess
        dr = objDataAccess.getThirdLevelPrevileges(CInt(ddlUserGroup.SelectedValue))
        clearCheckedListBox()
 
        While dr.Read()
 
            If dr.Item("Status") = True Then
                chkLevel3.Items.Add(dr.Item("Level3"), True)
            Else
                chkLevel3.Items.Add(dr.Item("Level3"))
            End If
 
        End While
 
 

I am bringing value from data base and trying to bind in the above shown way.
Some check boxes are not checked as per the database.
Can anyone help me please?


paulson

[nateraaaa]

You need to loop through your datagrid and use the FindControl method to find the checkbox control in each row.

 DataTable dataTable = dataset.Tables[0]; 
for(int i = 0; i < dataGrid1.Items.Count; i ++)
{
DataRow row = dataTable.Rows[i];
bool checkBoxChecked = Convert.ToBoolean(row["checkBoxValue"]);
CheckBox chk = (CheckBox)dataGrid1.Items[i].FindControl("CheckBox1");
if(checkBoxChecked)
{
chk.Checked = true;
}
else
{
chk.Checked = false;
}
}
 

Give this a try.

Nathan