para是只有一列的列,y1,y2是都有多列的列,
y值需要根据3个combobox所选的值来选表格当中的列(y值列名的命名类型如CHR111009,其中comboBox1.Text=CHR1,comboBox2.Text=1,comboBox3.Text=1009),string wax = comboBox1.Text + comboBox2.Text + comboBox3.Text;string s = comboBox1.Text + comboBox2.Text + comboBox3.Text;
当只用一个y值时这样写SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select " + wax + " from 进度条2", m);没事;当要用2个y值(y1,y2)时 SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select " + wax + "," + s + ",para from 电缆参数, 电缆参数1 ", m);显示ambiguous column name: CHR111009
先用字符串拼接出 SQL 并打印看看是否有相同的列,然后再调整 SQL 语句,应该是拼接列的时候处理不当。