01.
private
void
button1_Click(
object
sender, EventArgs e)
02.
{
03.
04.
clsVariables.conn =
new
MySqlConnection(clsVariables.strConn);
05.
clsVariables.conn.Open();
06.
07.
clsVariables.com =
new
MySqlCommand(
"SELECT MONTH(reciept_date)As mont, sum(sale_quant)As Total FROM c_sale GROUP BY MONTH(reciept_date);"
, clsVariables.conn);
08.
clsVariables.com.ExecuteNonQuery();
09.
clsVariables.dr = clsVariables.com.ExecuteReader();
10.
11.
while
(clsVariables.dr.Read())
12.
{
13.
14.
this
.chart1.Series[
"ยอดขาย"
].Points.AddXY(clsVariables.dr[
"mont"
].ToString(), clsVariables.dr[
"Total"
].ToString());
15.
}
16.
17.
clsVariables.conn.Dispose();
18.
19.
}