private void button1_Click(object sender, EventArgs e)
{
//连接按钮
DataTable databaseTable = MysqlDataIO.DatabasesTable(textBox1.Text, textBox2.Text, textBox3.Text);
int rowNum = databaseTable.Rows.Count;
DataBaseList.Items.Clear();
for (int i = 0; i < rowNum; i++)
{
DataBaseList.Items.Add(databaseTable.Rows[i][0]);
}
}
private void DataBaseList_SelectedIndexChanged(object sender, EventArgs e)
{
//选择的数据库改变时触发
DataTable datatableTable = MysqlDataIO.DatatableTable(textBox1.Text, textBox2.Text, textBox3.Text,
DataBaseList.SelectedItem.ToString());
int rowNum = datatableTable.Rows.Count;
DataTableList.Items.Clear();
for (int i = 0; i < rowNum; i++)
{
DataTableList.Items.Add(datatableTable.Rows[i][0]);
}
}
private void button2_Click(object sender, EventArgs e)
{
//确定按钮，选择数据库
if (DataBaseList.SelectedItem == null || DataTableList.SelectedItem == null)
{
return;
}
m_dataSource = MysqlDataIO.ReadMysqlData(textBox1.Text, textBox2.Text, textBox3.Text,
DataBaseList.SelectedItem.ToString(), DataTableList.SelectedItem.ToString());
//获取数据库配置，存入变量内
serverName = textBox1.Text;
uid = textBox2.Text;
pwd = textBox3.Text;
databaseName = DataBaseList.SelectedItem.ToString();
datatableName = DataTableList.SelectedItem.ToString();
this.Close();
}
private void button2_Click(object sender, EventArgs e)
{
//刷新数据按钮
if (!m_isMysql)
{
try
{
m_dataCenter = FileIO.ReadFile(openFileDialog1.FileName);
m_dataCenter = new DataCenter(m_dataCenter.crimeDataPointList,
m_dataCenter.pointInfoList);//构造出dataCenter类
dataGridView1.DataSource = Report.InitTable(m_dataCenter.crimeDataPointList);
////设置组距，便于画图
//int groupD = (int)(1 + 3.322 * Math.Log10(m_dataCenter.dminArray.Length * 1.0));
//List<double> dminList = new List<double>(m_dataCenter.dminArray);
//m_D = ((int)(dminList.Max() / (double)groupD * 100)) / 100.0;
//m_t = (int)(1 / m_D) + 1;
m_isMysql = false;
toolStripStatusLabel1.Text = "数据源：" + openFileDialog1.FileName;
GenerateComboboxItem();
}
catch (Exception)
{
MessageBox.Show("重新导入数据失败！");
}
}
else
{
dataGridView1.DataSource = MysqlDataIO.ReadMysqlData(m_mysqlForm.serverName, m_mysqlForm.uid,
m_mysqlForm.pwd, m_mysqlForm.databaseName, m_mysqlForm.datatableName);
m_isMysql = true;
}
GenerateComboboxItem();
m_ifCooorTranFlag = false;
m_ifCalculate = false;
}
