User1391648435 posted
DataTable dt = new DataTable();
using (MySqlConnection con = new MySqlConnection("server=localhost;user id=root;password=root;database=impgarden;"))
{
con.Open();
MySqlCommand cmd = new MySqlCommand("SELECT Id,Temperature,ReadDateTime FROM smartterranium WHERE ReadDateTime BETWEEN @ViewDateFrom and @ViewDateTo group by ReadDateTime ", con);
cmd.Parameters.AddWithValue("@ViewDateFrom", tbViewDateFrom.Text);
cmd.Parameters.AddWithValue("@ViewDateTo", tbViewDateTo.Text);
MySqlDataAdapter da = new MySqlDataAdapter(cmd);
da.Fill(dt);
con.Close();
object[,] chartValues = new object[dt.Rows.Count,2];
for (int i = 0; i < dt.Rows.Count; i++)
{
//category = category + "," + dt.Rows[i]["ReadDateTime"].ToString();
//chartValues[i] = Convert.ToDecimal(dt.Rows[i]["Temperature"]);
//chartValues[i, 0] = dt.Rows[i]["ReadDateTime"];
chartValues[i, 0] = dt.Rows[i]["ReadDateTime"].ToString();
chartValues[i, 1] = dt.Rows[i]["Temperature"];
}
DotNet.Highcharts.Highcharts chart = new DotNet.Highcharts.Highcharts("chart").InitChart(new Chart { DefaultSeriesType = ChartTypes.Line })
.SetTitle(new Title
{
Text = "Temperature",
X = -20
})
.SetXAxis(new[]
{
new XAxis
{
Type = AxisTypes.Datetime,
},
})
I having problems trying in to parse in the date i want from my database, the format is eg, 23/03/2017. My database name for date is ReadDateTime.
Is there a way to do it?