pickSets

 private void pickSets()
        {
                cnn = new SqlConnection(connectionString);

                using (cnn)
                {

                    try
                    {
                        cnn.Open();
                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Hiba az adatbázis megnyitása közben: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                        return;
                    }

                    SqlDataReader dr;



                    try
                    {

                        string sortQuery;
                        SqlCommand cmd;

                        if (sorting)
                        {
                            sortQuery = "SELECT Start_Work, End_Work FROM Report_tbl WHERE Machine = @machinee AND Error_Short = @errorshortt AND Worker_Number = " + workerNumber + " AND Start_Work = " + StartPicker + " AND End_Work = " + StopPicker + " AND Modify_Record BETWEEN @start_datee AND @end_datee";

                            cmd = new SqlCommand(sortQuery, cnn);

                            cmd.Parameters.AddWithValue("@machinee", machineCombo.Text);

                            cmd.Parameters.AddWithValue("@errorshortt", errorCombo.Text);

                            cmd.Parameters.AddWithValue("@start_datee", monthCalendar1.SelectionRange.Start);

                            cmd.Parameters.AddWithValue("@end_datee", monthCalendar1.SelectionRange.End.AddDays(1));

                        }
                        else
                        {
                            sortQuery = "SELECT Start_Work, End_Work FROM Report_tbl WHERE Machine = @machinee AND Error_Short = @errorshortt AND Worker_Number = " + workerNumber + " AND Start_Work = " + StartPicker + " AND End_Work = " + StopPicker + " ";

                            cmd = new SqlCommand(sortQuery, cnn);


                            cmd.Parameters.AddWithValue("@machinee", machineCombo.Text);

                            cmd.Parameters.AddWithValue("@errorshortt", errorCombo.Text);


                        }

                        dr = cmd.ExecuteReader();

                        workerNumber = 0;



                        while (dr.HasRows)
                        {
                            while (dr.Read())
                            {
                                StartPicker.Value = dr.GetDateTime(0);
                                StopPicker.Value = dr.GetDateTime(1);
                            }
                            dr.NextResult();
                        }
                        dr.Close();



                    }
                    catch (Exception ex)
                    {
                        MessageBox.Show("Hiba a lekérdezés közben: " + ex.Message, "Error", MessageBoxButtons.OK, MessageBoxIcon.Stop);
                    }
                    cnn.Close();

                }
        }