ZedGraph

Another free Chart Library for .Net !

Excellent!

http://sourceforge.net/projects/zedgraph/

http://www.codeproject.com/csharp/zedgraph.asp

Mirror Download


My Sample Code:

Code inside aspx

<%@ Page Language="C#" AutoEventWireup="true" <%@ Register TagPrefix="zgw" Namespace="ZedGraph.Web" Assembly="ZedGraph.Web" %>


Code inside aspx.cs

protected void Page_Load(object sender, EventArgs e)
{
this.ZedGraphWeb1.RenderGraph += new ZedGraph.Web.ZedGraphWebControlEventHandler(this.OnRenderGraph);
}

private void OnRenderGraph(System.Drawing.Graphics g, ZedGraph.MasterPane masterPane)
{
try
{
// STEP 1: Get the data from the database by stored procedure
SqlConnection cn = new SqlConnection(MyConstant.connectionString);
SqlCommand cmd = new SqlCommand("prc_industry_report_details", cn);
SqlDataReader dReader;

cn.Open();
cmd.CommandType = CommandType.StoredProcedure;

// input pass in parameter
cmd.Parameters.Add("@INDUSTRY_CATEGORY", SqlDbType.VarChar, 50).Value = INDUSTRY_CATEGORY_ID.Text;
cmd.Parameters.Add("@FROM_DATE", SqlDbType.VarChar, 20).Value = FROM_DATE.Text.ToString();
cmd.Parameters.Add("@TO_DATE", SqlDbType.VarChar, 20).Value = TO_DATE.Text.ToString();

dReader = cmd.ExecuteReader(CommandBehavior.CloseConnection);


// STEP 2: Create the chart object

// Get the GraphPane so we can work with it
GraphPane myPane = masterPane[0];

myPane.Title.Text = "My Title";
myPane.XAxis.Title.Text = "Spend ($)";
myPane.YAxis.Title.Text = "Date";

//read the ouput data into the grapic
PointPairList list = new PointPairList();
ArrayList labels_list = new ArrayList();
int i = 0;
while (dReader.Read())
{
list.Add((double)i++, double.Parse(dReader["Total Spend"].ToString()));
labels_list.Add(dReader["Month"].ToString() + "/" + dReader["Year"].ToString());
}
string[] labels = (string[])labels_list.ToArray(typeof(string));

BarItem myCurve = myPane.AddBar("Industry Report", list, Color.Blue);
myCurve.Label.IsVisible = false;
myCurve.Bar.Fill = new Fill(Color.Blue, Color.White, Color.Blue);

// Draw the X tics between the labels instead of at the labels
myPane.XAxis.MajorTic.IsBetweenLabels = true;

//string[] labels = { "Africa", "Americas", "Asia", "Europe", "Australia" };
myPane.XAxis.Scale.TextLabels = labels;
myPane.XAxis.Type = AxisType.Text;
myPane.XAxis.Scale.FontSpec.Border.IsVisible = false;
myPane.XAxis.Scale.FontSpec.Angle = 270f;
myPane.YAxis.Scale.FontSpec.Border.IsVisible = false;

// Fill the Axis and Pane backgrounds
//myPane.Chart.Fill = new Fill(Color.White, Color.FromArgb(255, 255, 166), 90F);
//myPane.Fill = new Fill(Color.FromArgb(250, 250, 255));
myPane.Fill = new Fill(Color.White, Color.FromArgb(200, 200, 255), 45.0f);
myPane.Chart.Fill = new Fill(Color.White, Color.LightGoldenrodYellow, 45.0f);

masterPane.AxisChange(g);

dReader.Close();
cn.Close();
}
catch (Exception e)
{ }
}