how to make checkbox checked

Get the database values using a datareader.
Loop through the returned records and then write code similar to the following -

if (dr["colName"] == "Yes")
{
   ckBox.Checked = true;
}
else
{
   ckBox.Checked = false;
}