c# - SqlDataReader filling column in datagridview -

i have been wondering quiet long time how can set sqldatareader fill column "pocet" in datagridview "dtg_ksluzby". thought code should this:

 sqlcommand novyprikaz2 = new sqlcommand("select pocet klisluz id='"+vyberradek+"'",spojeni); // have column "pocet" in table klisluz, vyberradek string selectrs id number             spojeni.open();             sqldatareader precti2 = novyprikaz2.executereader();             if (precti2.read())             {                 dtg_ksluzby.columns["pocet"]; // part need improve fill             } 

would please me improve code? in advance.

edit trippino:

1. in "klisluz" in table includes columns (id,akce,subkey,text,pocet). need to:
   1. select * klisluz subkey = '"+vyberradek+"'
   2. take column pocet , fill dtg_ksluzby find text similar in column "text" in dtg_ksluzby

i hope description understandabla, sorry weak english.

use this:

        (int = 0; < dtg_ksluzby.rows.count; i++)         {             var row = dtg_ksluzby.rows[i];             using(var novyprikaz2 = new sqlcommand("select pocet klisluz text @t , subkey=@s", spojeni))             {                 novyprikaz2.parameters.addwithvalue("@t", row.cells["text"].value.tostring());                 novyprikaz2.parameters.addwithvalue("@s", vyberradek);                 spojeni.open();                 sqldatareader precti2 = novyprikaz2.executereader();                 if (precti2.read())                 {                     row.cells["pocet"].value = precti2["pocet"];                 }             }         }