string wax = comboBox1.Text + comboBox2.Text + comboBox3.Text;string s=comboBox1.Text+comboBox2.Text+comboBox3.Text;
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select " + wax + ",para," + s + " from 电缆参数,电缆参数1", m);
chart2.Series[0].YValueMembers = wax;chart2.Series[1].YValueMembers = s;
两组数(wax,s)都需要根据下拉框的值来选择列,启动时显示ambiguous column name: CHR111009(comboBox1.Text=CHR1,comboBox2.Text=1,c
omboBox3.Text=1009)
也试过
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select " + wax + ",para from 电缆参数 union select " + s + ",para from 电缆参数1 ", m);
显示 union前后所取得列数应一样
也试过
string dbPath = @"D:\历年高考分数.db";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select " + wax + ",para from 电缆参数", m);
SQLiteDataAdapter mAdapter1 = new SQLiteDataAdapter("select " + s + " from 电缆参数1", m);
DataSet ds = new DataSet();
DataSet ds1 = new DataSet();
mAdapter.Fill(ds);
mAdapter1.Fill(ds1);
DataTable dt = ds.Tables[0];
DataTable dt1 = ds1.Tables[0];
//设置图表的数据源
chart2.DataSource = dt;
//chart2.DataSource = dt1+dt;
chart2.DataSource = dt1;
启动时会显示找不到名为“para”的列。但表中有“para”列,可能 chart2.DataSource以最后出现的dt1为准。可不可以让wax,s分别是同一列的前20个数,后20个数 如果不行,应该怎么改