Gallery
Data Grid Dash
<%@ Page Language="C#" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Threading" %>
<script runat="server">
void Page_Load(Object sender, EventArgs e)
{
// Demonstrates using MicroCharts inside DataGrids using a GetImage method.
GridView1.DataSource = getDataSet();
GridView1.DataBind();
}
protected string GetChartImageTag(object dataItem)
{
int val = Int32.Parse(DataBinder.Eval(dataItem, "Population").ToString());
Chart c = new Chart();
c.TempDirectory = "temp";
c.Margin = "0";
c.ObjectChart = new dotnetCHARTING.Label("<Chart:Bullet max='10000000' values='" + val + ",5000000,2000000,5000000'> ");
return "<img src='" + c.FileManager.SaveImage() + "'>"; ;
}
DataSet getDataSet()
{
string strAccessConn = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" + Server.MapPath(ConfigurationManager.AppSettings["DNCConnectionString"]);
OleDbConnection myAccessConn = new OleDbConnection(strAccessConn);
myAccessConn.Open();
DataSet myDataSet = new DataSet();
new OleDbDataAdapter(new OleDbCommand(@"SELECT City,Population FROM Cities", myAccessConn)).Fill(myDataSet, "Cities");
myAccessConn.Close();
return myDataSet;
}
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align:center;margin:0 auto;width:400px;">
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField HeaderText="Chart" >
<ItemTemplate>
<%# GetChartImageTag(Container.DataItem) %>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
<%@ Page Language="vb" Description="dotnetCHARTING Component" %>
<%@ Register TagPrefix="dotnet" Namespace="dotnetCHARTING" Assembly="dotnetCHARTING" %>
<%@ Import Namespace="System.Drawing" %>
<%@ Import Namespace="System.Drawing.Drawing2D" %>
<%@ Import Namespace="dotnetCHARTING.Mapping" %>
<%@ Import Namespace="System.Data" %>
<%@ Import Namespace="System.Data.OleDb" %>
<%@ Import Namespace="System.Threading" %>
<script runat="server">
Sub Page_Load(ByVal sender As Object, ByVal e As EventArgs)
' Demonstrates using MicroCharts inside DataGrids using a GetImage method.
GridView1.DataSource = getDataSet()
GridView1.DataBind()
End Sub
Protected Function GetChartImageTag(ByVal dataItem As Object) As String
Dim val As Integer = Int32.Parse(DataBinder.Eval(dataItem, "Population").ToString())
Dim c As Chart = New Chart()
c.TempDirectory = "temp"
c.Margin = "0"
c.ObjectChart = New dotnetCHARTING.Label("<Chart:Bullet max='10000000' values='" & val & ",5000000,2000000,5000000'> ")
Return "<img src='" & c.FileManager.SaveImage() & "'>"
End Function
Function getDataSet() As DataSet
Dim strAccessConn As String = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=" & Server.MapPath(ConfigurationManager.AppSettings("DNCConnectionString"))
Dim myAccessConn As OleDbConnection = New OleDbConnection(strAccessConn)
myAccessConn.Open()
Dim myDataSet As DataSet = New DataSet()
CType(New OleDbDataAdapter(New OleDbCommand("SELECT City,Population FROM Cities", myAccessConn)), OleDbDataAdapter).Fill(myDataSet, "Cities")
myAccessConn.Close()
Return myDataSet
End Function
</script>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<title>.netCHARTING Sample</title>
</head>
<body>
<form id="form1" runat="server">
<div style="text-align:center;margin:0 auto;width:400px;">
<asp:GridView ID="GridView1" runat="server">
<Columns>
<asp:TemplateField HeaderText="Chart" >
<ItemTemplate>
<%#GetChartImageTag(Container.DataItem)%>
</ItemTemplate>
</asp:TemplateField>
</Columns>
</asp:GridView>
</div>
</form>
</body>
</html>
- Sample FilenameDataGridDash.aspx
- Version5.2
- Uses DatabaseYes