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);
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