private const string m_strConnection=@"Jet OLEDB:Global Partial Bulk Ops=2;Jet OLEDB:Registry Path=;Jet OLEDB:Database Locking Mode=1;Jet OLEDB:Database Password=;Data Source=""F:/源码/Study/TestTwoCombo/bin/Debug/data.mdb"";Password=;Jet OLEDB:Engine Type=5;Jet OLEDB:Global Bulk Transactions=1;Provider=""Microsoft.Jet.OLEDB.4.0"";Jet OLEDB:System database=;Jet OLEDB:SFP=False;Extended Properties=;Mode=Share Deny None;Jet OLEDB:New Database Password=;Jet OLEDB:Create System Database=False;Jet OLEDB:Don't Copy Locale on Compact=False;Jet OLEDB:Compact Without Replica Repair=False;User ID=Admin;Jet OLEDB:Encrypt Database=False";
private OleDbConnection cn=new OleDbConnection();
private OleDbDataAdapter da;
private DataTable dtbDept=new DataTable();
private DataTable dtbEmp=new DataTable();
private void Form1_Load(object sender, System.EventArgs e)
{
m_ConnectToDB();
da=new OleDbDataAdapter(@"SELECT * FROM 部门",cn);
da.Fill(dtbDept);
da.SelectCommand.CommandText=@"SELECT * FROM 员工";
da.Fill(dtbEmp);
m_CloseConnection();
m_LoadDept();
}
/// <summary>
/// 连接数据库
/// </summary>
private void m_ConnectToDB()
{
cn.ConnectionString=m_strConnection;
if(cn.State==ConnectionState.Closed)
{
cn.Open();
}
}
/// <summary>
/// 关闭数据库连接
/// </summary>
private void m_CloseConnection()
{
if(cn.State==ConnectionState.Open)
{
cn.Close();
}
}
/// <summary>
/// 加载部门信息
/// </summary>
private void m_LoadDept()
{
if(dtbDept.Rows.Count>0)
{
cmbDept.DataSource=dtbDept;
cmbDept.DisplayMember="部门名称";
}
}
private void m_LoadEmp()
{
if(cmbDept.SelectedIndex>=0)
{
dtbEmp.DefaultView.RowFilter="部门ID='"+dtbDept.Rows[cmbDept.SelectedIndex]["部门ID"].ToString().Trim()+"'";
cmbEmp.DataSource=dtbEmp.DefaultView;
cmbEmp.DisplayMember="姓名";
}
}
private void cmbDept_SelectedIndexChanged(object sender, System.EventArgs e)
{
m_LoadEmp();
}