GROUP BY issue in datagridview

[Marek Šíp]

With little help of you I made this two querys. I posted Picture so you can see
that in green squares are empty values which I would like to see and in red
squares are values which I wouldnt like to display. Variable
vyberradek inserts values for subkey This first query does this:

string sQuery = string.Format("SELECT zajsluz.akce,zajsluz.text,klisluz.pocet,klisluz.subkey,zajsluz.ID FROM zajsluz LEFT JOIN klisluz ON zajsluz.ID=klisluz.IDzajsluz WHERE zajsluz.akce= {0} GROUP BY klisluz.subkey,zajsluz.akce,zajsluz.text,klisluz.pocet,zajsluz.ID", sZakce);

this is the second one

string sQuery = string.Format("SELECT zajsluz.akce,zajsluz.text,klisluz.pocet,klisluz.subkey,zajsluz.ID FROM zajsluz LEFT JOIN klisluz ON zajsluz.ID=klisluz.IDzajsluz WHERE zajsluz.akce= {0} and klisluz.subkey =" + vyberradek + " GROUP BY klisluz.subkey,zajsluz.akce,zajsluz.text,klisluz.pocet,zajsluz.ID", sZakce);

So as you can see I would like also to display the empty ones. I think you
might need also the code which checks the checkboxes here it is:

for (int i = 0; i < dtg_ksluzby.Rows.Count; i++)
{
var row = dtg_ksluzby.Rows;
int id = (int)row.Cells["ID"].Value;

using (var novyprikaz3 = new SqlCommand("SELECT * from klisluz WHERE subkey=" + vyberradek + "AND IDzajsluz=" + id, spojeni))
{

spojeni.Open();
SqlDataReader precti3 = novyprikaz3.ExecuteReader();
if (precti3.HasRows)
{
row.Cells[5].Value = true;
}
spojeni.Close();
}
}


Would you guys please suggest me how should the query look like to select
even the non checked values(which arent in table klisluz) and the checked ones?
Thanks so much.

Continue reading...