asp.net checkbox

Question

Hey I have gridView with a checkbox and I bind it to a dataset. In database is a column called Assigned and it contains 0 or 1. When I tried to bound it I got error .(cast error) [ ' /> ]

Crish · Answer

hi there may be possible some values are null in this checkboxes. so please check your database for that. Then after track one by one recods values of checkboxes in RowDatabound of gridview

Shankey · Answer

set the chcked=' QStatus ) %>' then make sure that your datasource returns a valid true or false in the field QStatus . You can do this in the select statement by doing a Select IsNull( QStatus 0) as QStatus From MyTable

PankaJ D · Answer

How I can check this. And can same methos is use?

Krishna Garad · Answer

Your Database column is bit datatype and checkbox behaviour lise on true/false based before binding the dataset to grid you have to check that column is either 0 or 1 and then only set the checkbox.checked true/false.

Shankey · Answer

hi pankaj dhake You can do one thing that on rowbound event of the grid you can set the status of the check box to true or false based on your value.

PankaJ D · Answer

Specified cast is not valid. the above error is occered