Requirement:
I need to create a Stacked Bar Chart in my web application based on 2.0 plateform. I dont want to use any third party tool or chart in VS because I cannot access the chart control when working on 2.0 plateform. It only supports 3.5.
Is there any professional developer present who can help me in this issue.
my Code is as below from which I need to create bar Chart.
OracleConnection dbConn = Conn.getConn();
ExCard_Services obj = new ExCard_Services(Conn.getConn());
protected void Page_Load(object sender, EventArgs e)
{
BindData();
}
private void BindData()
{
string strQuery = "select product, quantity, amount, retail_outlet, to_char(txn_dt,'DD-MON-YYYY') DT, txn_time from(card_trans_detail) where card_no in (select card_no from card_services where emp_code='619') and to_char(bill_month,'MON-YYYY')='" + Request.QueryString.Get("mnyr") + "' order by product";
OracleCommand cmd = new OracleCommand(strQuery);
gvFuelDetail.DataSource = obj.SetData(cmd);
gvFuelDetail.DataBind();
}
From the above code I need to extract the chart of AMOUNT and PRODUCT of the CURRENT MONTH.
Amount has numeric values.
Product has PETROL and CNG.
Thanks..