Click here to Skip to main content
13,047,567 members (59,267 online)
Rate this:
Please Sign up or sign in to vote.
See more:
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);
    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

Posted 21-Mar-13 1:17am
Updated 21-Mar-13 1:45am
Maciej Los 21-Mar-13 13:16pm
If you want to do it on sql serer side, provide example data.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

  Print Answers RSS
Top Experts
Last 24hrsThis month

Advertise | Privacy | Mobile
Web02 | 2.8.170713.1 | Last Updated 21 Mar 2013
Copyright © CodeProject, 1999-2017
All Rights Reserved. Terms of Service
Layout: fixed | fluid

CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100