How to create an sql query including datetimepicker-values and present in charts C#

I am trying to program and mostly use the User Interface in design-time. So far, all has been well and I have only recently met a problem.

The thing is, that I know how to do this by writing the code and sql queries in the Form. Like i.e :

sqlConnection con = new sqlConnection (conString);
//
// More code
//
for (int i = 1; i <= 12; i++)
{
    foreach (string row in ard.ardcruise)
    {
        bard.bardYear = ard.ardYear;
        bard.bardcruise_id = row.substring(0, row.IndexOf(" "));
    }

    SELECT ("cruise_id, DATEPART(dd, dt) As s_day, AVG(use) AS AVG_use FROM use" +
    "WHERE (cruise_id = " + bard.bardcruise_id + " AND use != 0 " + "AND DATEPART(mm, dt) = " + i.ToString() + " AND DATEPART(yyyy, dt) = " + bard.bardYear + " AND DATEPART(dd, dt) = " + d.ToString() + ") GROUP BY cruise_id, DATEPART(dd, dt) ORDER BY s_day", con);

    dscon.Clear();
    dacon.Fill(dscon, "AVG");

My question is.... How do I do the same in Design-time with User interface? How do I select month, year and day in DATEPART with dateTimePicker ?

In the end I would like to show AVG_use and s_day in a chart where cruise_id is Legend 1 or more depending on user selection.
I would like to write the sql statements in the query builder in visual studio 2010 professional

Thanks

Tags: C#, SQL, DateTime, Chart