Well, it'd be good if you store both the value in one column only. Because it'd be easy to insert & retrieve.
Make sure you have field of type-of
bit
for stoing the checkbox values in DB.
string chk;
SqlCommand cmd = null;
for (int i = 0; ChkBoxMarkPr.Items.Count; i++)
{
cmd = new SqlCommand("INSERT INTO [TABLE_NAME] (COLUMN_NAME) VALUES ("+ ChkBoxMarkPr.Items[i].Selected + ")", yourSqlConnectionObject);
cmd.ExecuteNonQuery();
}
And yeah, agree with what Tadit said (Solution #1) as well. You can go that way too. Then you have to allow the
null
values for column. :)
-KR