c# - C# 如何制作实时条形图(Livecharts 库)
问题描述
我正在将数值数据传输到笛卡尔图中的图表。但是,从数据库中提取数据名称时出现问题。名称不出现。我希望我的数据在笛卡尔图旁边显示为饼图。我想将“GelirAdi”列中的数据与图表相匹配。总之,“GelirAdi”列将是名称,“GelirMiktari”将是笛卡尔图中的数值,但我该怎么做?
private void btn_gider_bilgi_getir_Click(object sender, EventArgs e)
{
string veritabaniyolu = "Data source=veritabani.db";
bunifuDataGridView1.DataSource = null;
SQLiteConnection baglanti = new SQLiteConnection(veritabaniyolu);
baglanti.Open();
string sql_tarih_sorgula = "SELECT * FROM Gelirler";
SQLiteDataAdapter da = new SQLiteDataAdapter(sql_tarih_sorgula, baglanti);
DataTable dt = new DataTable();
da.Fill(dt);
bunifuDataGridView1.DataSource = dt;
baglanti.Close();
ColumnSeries series2 = new ColumnSeries()
{
DataLabels = true,
Values = new ChartValues<int>(),
LabelPoint = point => point.Y.ToString()
};
Axis axisX = new Axis() {
Separator = new Separator() { Step = 1, IsEnabled = false },
Labels=new List<string>()
};
Axis axisY = new Axis()
{
LabelFormatter=y=>y.ToString(),
Separator=new Separator()
};
cartesianChart1.Series.Add(series2);
cartesianChart1.AxisX.Add(axisX);
cartesianChart1.AxisY.Add(axisY);
foreach (DataGridViewRow item in bunifuDataGridView1.Rows) {
int a = Convert.ToInt32(item.Cells["GelirMiktari"].Value);
series2.Values.Add(a);
axisX.Labels.Add(item.Cells["GelirAdi"].Value.ToString());
}
}
解决方案
根据我的测试,您可以使用 linq 动态设置标签点的工具提示。
您可以尝试以下代码来实现它。
private void Form1_Load(object sender, EventArgs e)
{
SQLiteConnection m_dbConnection = new SQLiteConnection("Data Source=MyDatabase.sqlite");
m_dbConnection.Open();
SQLiteDataAdapter da = new SQLiteDataAdapter("select * from Product", m_dbConnection);
DataTable dt = new DataTable();
da.Fill(dt);
dataGridView1.DataSource = dt;
dataGridView1.AllowUserToAddRows = false;
}
private void button1_Click(object sender, EventArgs e)
{
ColumnSeries series2 = new ColumnSeries()
{
DataLabels = true,
Values = new ChartValues<int>(),
LabelPoint = point => dataGridView1.Rows.Cast<DataGridViewRow>().Where(i => Convert.ToDouble(i.Cells["number"].Value) == point.Y).Select(i => i.Cells["name"].Value.ToString()).First(),
Title = "" //Here you added to remove "Series" text
};
Axis axisX = new Axis()
{
Separator = new Separator() { Step = 1, IsEnabled = false },
Labels = new List<string>()
};
Axis axisY = new Axis()
{
LabelFormatter = y => y.ToString(),
Separator = new Separator()
};
cartesianChart1.Series.Add(series2);
cartesianChart1.AxisX.Add(axisX);
cartesianChart1.AxisY.Add(axisY);
foreach (DataGridViewRow item in dataGridView1.Rows)
{
int a = Convert.ToInt32(item.Cells["number"].Value);
series2.Values.Add(a);
}
}
结果:
推荐阅读
- sql - SQL case 两者或其中之一
- http-error - 显示来自服务器 HTTP 错误消息的通知
- kotlin - 当 flatMap 内部完成时,使原始 Observable 完成
- sas - 如何从表中分配宏变量值并在 SAS 中附加宏输出的数据
- javascript - 在 JavaScript 中解析 JSON 字符串的问题
- database - 创建phoenix表单并提交时出错
- c# - 如何装饰 MediatR 处理程序
- mongodb - 当转储达到 101 条记录时,mongoexport / mongodump 停止
- python - Stripe API - 过滤争议请求
- google-workspace - Admin SDK 的 G Suite 频道停止功能不起作用