“System.ArgumentException”类型的未经处理的异常，Y 值不能是绑定到字符串对象的数据，具体怎么改

Question

public partial class Form1 : Form
{
public static SQLiteConnection m;
private void button1_Click(object sender, EventArgs e)
{
string dbPath = @"D:\历年高考分数.db";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
string sql = "SELECT para,Volume1, Volume2 FROM 电缆参数";
SQLiteCommand command = new SQLiteCommand(sql, m);
Chart1.DataSource = dbPath;
CreateChart();

    }

    public Form1()
    {
        InitializeComponent();
    }

    private void Form1_Load(object sender, EventArgs e)
    {

    }
    public void CreateChart()
    {
        Series s1 = new Series();
        s1.IsValueShownAsLabel = true;
        s1.ChartType = SeriesChartType.Column;
        Chart1.Series.Add(s1);
        Series s2 = new Series();
        s2.ChartType = SeriesChartType.Column;
        s2.IsValueShownAsLabel = true;
        Chart1.Series.Add(s2);
        Chart1.Series[0].ChartType = SeriesChartType.Column;
        //设置图表Y轴对应项
        Chart1.Series[0].YValueMembers = "Volume1";
        Chart1.Series[1].YValueMembers = "Volume2";
        //设置图表X轴对应项
        Chart1.Series[0].XValueMember = "para";
        //绑定数据
        Chart1.DataBind();

    }

Answer 1

你的数据源是字符串，需要用数字类型。或者你定义一个数组，把原始数据转换成数字再绑定