namespace WindowsFormsApplication1
{
public partial class Form1 : Form
{
private SQLiteConnection m;
private bool flag;
public Form1()
{
InitializeComponent();
}
private void Form1_Load(object sender, EventArgs e)
{
string dbPath = @"D:\历年高考分数.db";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select para1,para2,para3 from 下拉框1", m);
DataSet ds = new DataSet();
mAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
comboBox1.DataSource = dt;
comboBox1.ValueMember = "para1";
comboBox1.DisplayMember = "para1";
comboBox2.DataSource = dt;
comboBox2.ValueMember = "para2";
comboBox2.DisplayMember = "para2";
comboBox3.DataSource = dt;
comboBox3.ValueMember = "para3";
comboBox3.DisplayMember = "para3";
//comboBox1.SelectedIndex = 0;
m.Close();
}
private void button1_Click(object sender, EventArgs e)
{
flag = true;
}
private void comboBox3_SelectedValueChanged(object sender, EventArgs e)
{
if (flag == true)//如果按钮被点击
{
if (comboBox1.Text == "CHR1" && comboBox2.Text == "1" && comboBox3.Text == "我")
{
Creatchart1();
}
else if (comboBox1.Text == "CHR2" && comboBox2.Text == "1" && comboBox3.Text == "我")
{
Creatchart2();
}
else if (comboBox1.Text == "CHR1" && comboBox2.Text == "2" && comboBox3.Text == "我")
{
Creatchart3();
}
else if (comboBox1.Text == "CHR2" && comboBox2.Text == "2" && comboBox3.Text == "我")
{
Creatchart4();
}
else if (comboBox1.Text == "CHR1" && comboBox2.Text == "1" && comboBox3.Text == "你")
{
Creatchart5();
}
else if (comboBox1.Text == "CHR2" && comboBox2.Text == "1" && comboBox3.Text == "你")
{
Creatchart6();
}
else if (comboBox1.Text == "CHR1" && comboBox2.Text == "2" && comboBox3.Text == "你")
{
Creatchart7();
}
else if (comboBox1.Text == "CHR2" && comboBox2.Text == "2" && comboBox3.Text == "你")
{
Creatchart8();
}
}
}
}
}
说明:combox1可选CHR1,CHR2; combox2可选1,2; combox3可选我,你(combox的值是由连接sqlite数据库得到的
值。每个 Creatchartx()代表出一个图(柱形图或饼形图或曲线图),之间没有规律。
错误1:一个combox的值单选完CHR2或2或你后,自动选上(CHR2,2,你);单一个combox的值选完CHR1或1或我后,自动选上(CHR1,1,我);且3个combox的值仅能选这2种组合。
错误2:应该是3个combox的值选(CHR1,1,你)后出现 Creatchart5();然而在3个combox的值选(CHR2,2,你)后出现t Creatchart8();之后再3个combox的值选(CHR2,2,你)后出现 Creatchart8()。
想要实现效果:3个combox值应能选8种组合。我想3个全选完后,再出图,而不是点完按钮后只要combox3变了,就出图;各位大神我该怎么改