|
DataTable table = new DataTable();
DataColumn colcreatedby = table.Columns.Add("Created By", typeof(string));
DataColumn colmodifiedby = table.Columns.Add("Modified By", typeof(string));
DataColumn colitem = table.Columns.Add("Item", typeof(string));
DataColumn colparameter = table.Columns.Add("Parameter", typeof(string));
table.Rows.Add("Mark", "Zed", "Apple", "Red");
table.Rows.Add("Mark", "Zed", "Apple", "Red");
table.Rows.Add("Joesph", "Claire", "Orange", "Orange");
table.Rows.Add("Luck", "Mark", "Graps", "Green");
data = table;
sfDataGrid.DataSource = data; |
|
ChartSeries series = new ChartSeries("Line Series", ChartSeriesType.Pie);
foreach(var item in data)
{
object[] record = ((item as RecordEntry).Data as DataRowView).Row.ItemArray;
string createdby = record[0] as string; // Createdby is first column
var pointsCount = series.Points.Count;
if (series.Points.Count == 0)
{
series.Points.Add(createdby, 1);
}
else
{
bool isDataPointupdate = false;
for (int i = 0; i < pointsCount; i++)
{
if (series.Points[i].Category == createdby)
{
series.Points[i].YValues[0] += 1;
isDataPointupdate = true;
}
}
if(!isDataPointupdate)
{
series.Points.Add(createdby, 1);
}
}
}
this.chart1.Series.Add(series); |
|
table = new DataTable();
DataColumn colid = table.Columns.Add("Id", typeof(int));
|
|
var SortedDataList = dataTable.AsEnumerable()
.GroupBy(x => x.Field<int>("Id"))
.Select(y => y.First())
.ToList();
foreach (var item in SortedDataList)
{
series.Points.Add(item.ItemArray[1] as string, 1);
}
this.chart1.Series.Add(series); |
| Ids | Created By |
| 155137 | Luke |
| 155137 | Luke |
| 155156 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155200 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155376 | Luke |
| 155376 | Luke |
| 155402 | Luke |
| 155402 | Luke |
| 155431 | Mark |
| 155474 | Luke |
| 155474 | Luke |
| 155474 | Luke |
| 166071 | Luke |
| 166071 | Luke |
| 166071 | Luke |
| 166108 | Luke |
| 166108 | Luke |
| 166108 | Luke |
| 166271 | John |
| 166309 | John |
| Ids | Created By |
| 155137 | Luke |
| 155137 | Luke |
| 155156 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155179 | Luke |
| 155200 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155216 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155325 | Luke |
| 155376 | Luke |
| 155376 | Luke |
| 155402 | Luke |
| 155402 | Luke |
| 155431 | Mark |
| 155474 | Luke |
| 155474 | Luke |
| 155474 | Luke |
| 166071 | Luke |
| 166071 | Luke |
| 166071 | Luke |
| 166108 | Luke |
| 166108 | Luke |
| 166108 | Luke |
| 166271 | John |
| 166309 | John |
|
public LiveChart(RecordsList data, DataTable dataTable)
{
InitializeComponent();
this.chart1.Series.Clear();
. . .
} |