c# - 如何从数据网格中绘制过滤值？

Question

很清楚如何绘制我们在原始表中的值，但是如何绘制过滤后的值，这就是问题所在

这些代码行帮助我们在数据网格中显示我们的 sql 表并绘制值而不被过滤

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace graphic
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {

            this.values1TableAdapter.Fill(this.dataGraphicDataSet.values1);

        }

        private void TextBox1_TextChanged(object sender, EventArgs e)
        {
            BindingSource bs = new BindingSource();
            bs.DataSource = dataGridView1.DataSource;
            bs.Filter = "Convert(ederpou , 'System.String') LIKE '" + textBox1.Text + "%'";
            dataGridView1.DataSource = bs;
        }

        private void Button1_Click(object sender, EventArgs e)
        {
            chart1.Series["Series1"].XValueMember = "date";
            chart1.Series["Series1"].YValueMembers = "money";

            chart1.DataSource = dataGraphicDataSet.values1;
            chart1.DataBind();
        }
    }
}    

单击加载按钮后，我们得到这个

但是如何获得例如在“ederpou”= 323232 上有过滤器的那些值的图？

标签： c#sqlchartswindows-forms-designer