public partial class Form1 : Form
{
private SQLiteConnection m;
public object 四川 { get; private set; }
public object 江苏 { get; private set; }
public object 直辖市 { get; private set; }
public object 广州 { get; private set; }
public bool flag { get; private set; }
public Form1()
{
InitializeComponent();
}
private void button1_Click(object sender, EventArgs e)
{
flag = true;
}
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 province from combox1值", m);
DataSet ds = new DataSet();
mAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
comboBox1.DataSource = dt;
comboBox1.ValueMember = "province";
//comboBox1.SelectedIndex = 0;
m.Close();
}
private void comboBox1_SelectedValueChanged(object sender, EventArgs e)
{
if (comboBox1.SelectedItem == 四川)
{
if (flag == true)//如果按钮被点击
{
textBox1.Text="我";
}
}
else if (comboBox1.SelectedItem == 江苏)
{
if (flag == true)//如果按钮被点击
{
textBox2.Text = "你";
}
}
else if (comboBox1.SelectedItem == 广州)
{
if (flag == true)//如果按钮被点击
{
textBox3.Text = "他";
}
}
else if (comboBox1.SelectedItem == 直辖市)
{
if (flag == true)//如果按钮被点击
{
Creatchart4();
}
}
}
private void Creatchart4()
{
string dbPath = @"D:\历年高考分数.db";
string sq = @"Data Source=" + dbPath;
m = new SQLiteConnection(sq);
m.Open();
SQLiteDataAdapter mAdapter = new SQLiteDataAdapter("select Volume1,Volume2 from 饼形图2", m);
DataSet ds = new DataSet();
mAdapter.Fill(ds);
DataTable dt = ds.Tables[0];
//设置图表的数据
chart1.DataSource = dt;
//chart1.Series.Clear();
chart1.Series[0].XValueMember = "Volume1";//图例数据成员列
chart1.Series[0].YValueMembers = "Volume2";//饼形图上数据成员列
chart1.Series[0].IsValueShownAsLabel = true;//显示标签
chart1.DataBind();
m.Close();
}
}
