c# - SqlDataReader check checkbox if item is in table -

im wondering how make checkboxes in column[3]in dtg_ksluzby checked when value in db.

klisluz(table data from) contains columns, id, subkey(which = vyberradek), text, pocet code inserting db.

  foreach (datagridviewrow row in dtg_ksluzby.rows)             {                  if (convert.toboolean(row.cells[3].value) == true)                  {                     sqlcommand prikaz2 = new sqlcommand("insert klisluz(text,pocet,akce,subkey) values(@val1,@val2,@val3,@val4) ", spojeni);                     prikaz2.parameters.addwithvalue("@val1", row.cells["text"].value);                     prikaz2.parameters.addwithvalue("@val2", row.cells["pocet"].value);                     prikaz2.parameters.addwithvalue("@val3", row.cells["akce"].value);                     prikaz2.parameters.addwithvalue("@val4", max + 1);                     spojeni.open();                     prikaz2.executenonquery();                     spojeni.close();                 }             } 

now check checkbox when item inserted in db. propose me clue please?

i think can algorithm isssue, have no idea how can turn code thought can somehoe :

 sqlcommand novyprikaz3 = new sqlcommand("select * klient id_k=" + vyberradek, spojeni); //vyberradek selects row id             spojeni.open();             sqldatareader precti = novyprikaz.executereader();              if (precti.read())             {                 if text in (row id_k=number comes vyberradek) in dtg_ksluzby check checkbox in same row   } 

i use user know columns did selected before when editing thank in advance.

 (int = 0; < dtg_ksluzby.rows.count; i++)         {             var row = dtg_ksluzby.rows[i];             using(var novyprikaz2 = new sqlcommand("select * klient id_k=" + vyberradek, spojeni))             {                 spojeni.open();                 sqldatareader precti2 = novyprikaz2.executereader();                 if (precti2.hasrows)                 {                     row.cells[3].value = true;                 }             }         } 

you have change vyberradek accordingly row content.