Thursday, February 4, 2010

How to Use Chart Control in Asp.net 3.5?


< asp:Chart ID="RequestStatusChart" runat="server" Height="215px" Width="450px" BackImageTransparentColor="White"
BorderlineDashStyle="Solid">
< BorderSkin BorderColor="Transparent" BorderDashStyle="Solid" BorderWidth="0" PageColor="White"
SkinStyle="Emboss" />
< Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesTotal" Color="#26A3F3" XValueMember="RequestedOn"
YValueMembers="Total" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesApproved" Color="#1B8D01" XValueMember="RequestedOn"
YValueMembers="Approved" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series Name="SeriesPending" Color="#FED43F" XValueMember="RequestedOn" YValueMembers="Pending"
IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesAwaiting" XValueMember="RequestedOn"
YValueMembers="Awaiting" Color="#DF4ADD" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesRejected" XValueMember="RequestedOn"
YValueMembers="Rejected" Color="#F01027" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< asp:Series ChartArea="ChartArea1" Name="SeriesTransferred" Color="#FC8700" XValueMember="RequestedOn"
YValueMembers="Transferred" IsValueShownAsLabel="True" CustomProperties="DrawingStyle=Cylinder">
< /asp:Series>
< /Series>
< ChartAreas>
< asp:ChartArea Name="ChartArea1" BackColor="Transparent">
< /asp:ChartArea>
< /ChartAreas>
< /asp:Chart>


//Call on Page Load
public void BindChart()
{
DataTable dtrptstatus = new DataTable();

RequestStatusChart.DataSource = null;
RequestStatusChart.DataBind();
dtrptstatus = objReport.GetStatusLogReport(Convert.ToDateTime(txtSelectDate.Text));
RequestStatusChart.DataSource = dtrptstatus;
//Set the series to named series and confgiure x and y axes
RequestStatusChart.Series["SeriesTotal"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesTotal"].YValueMembers = "Total";
RequestStatusChart.Series["SeriesAwaiting"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesAwaiting"].YValueMembers = "Awaiting";
RequestStatusChart.Series["SeriesApproved"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesApproved"].YValueMembers = "Approved";
RequestStatusChart.Series["SeriesPending"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesPending"].YValueMembers = "Pending";
RequestStatusChart.Series["SeriesRejected"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesRejected"].YValueMembers = "Rejected";
RequestStatusChart.Series["SeriesTransferred"].XValueMember = "RequestedOn";
RequestStatusChart.Series["SeriesTransferred"].YValueMembers = "Transferred";
RequestStatusChart.DataBind();
RequestStatusChart.Visible = true;
}


public DataTable GetStatusLogReport(DateTime dt)
{
DataTable dtrpt = new DataTable();
if (OpenConnection())
{
Cmd.Parameters.Clear();
Cmd.Connection = Constr;
Cmd.CommandText = "select Total,Awaiting,Approved, Pending , Rejected ,Transferred, Convert(varchar(6),Date,106) as RequestedOn from Tablename order by convert(datetime,Date) desc";
Cmd.CommandType = CommandType.Text;
Adp.SelectCommand = Cmd;
Adp.Fill(dtrpt);
CloseConnection();
}
return dtrpt;
}

Click Here To Download Chart Control

No comments:

 
Feedback Form