令a=combox1.text,b=combox2.text,c=combox1.text,下图为三个combox可取的值,怎么把y取那列值与a,b,c三个变量相关联(y=哪该怎么填)
private void button1_Click(object sender, EventArgs e)
{
flag = true;
}
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
flag1= true;
}
private void comboBox2_SelectedValueChanged(object sender, EventArgs e)
{
flag2 = true;
}
private void Form1_Load(object sender, EventArgs e)
{
if (flag == true && flag1 == true && flag2 == true)
{
Creatchart1(a,b,c);
}
}
private void Creatchart1(a,b,c)
{
chart1.Visible = true
string dbPath = @"D:\历年高考分数.db";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select x,y from 表一 where y=", m);
DataSet ds = new DataSet();
mAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
//设置图表的数据源
chart1.DataSource = dt;
chart1.Series[0].IsVisibleInLegend = false;//是否显示图例
chart1.Series["Series1"].ChartType = SeriesChartType.Spline;//形状
chart1.Series[0].XValueMember = "x";//X轴数据成员列
chart1.Series[0].YValueMembers = "y";//Y轴数据成员列
m.Close();
}