object result;//用来装查询结果
public Access()
{
con = MyDB.GetAccessConnection(DirPath + @"\Northwind.mdb");
cmd.Connection = con;
adapter = new OleDbDataAdapter(cmd);
//con.Dispose();//此操作将清空Connection的数据源和连接字符串，之后不能再用.Open()打开数据库。
Query();
//Operate();
}
public DataView()
{
InitializeComponent();
FM = new MyWinForm(this);
FM.SetDefaultStyle("数据");
conA = MyDB.GetAccessConnection(AccessPath);
conS = MyDB.GetSqlServerConnection("127.0.0.1", "111", "Northwind");
Catalog();
}
void doLogin()
{
AccessPath = INI.Root + @"\" + INI.GetDBName() + ".mdb";
Password = textBox1.Text;
Global.con = MyDB.GetAccessConnection(AccessPath, Password);
if (Global.con != null)
{
new CentralControl(this).Show();
this.Hide();
}
Recover();
}
public BindBox()
{
InitializeComponent();
FM = new MyWinForm(this);
FM.SetDefaultStyle("选择");
conA = MyDB.GetAccessConnection(AccessPath);
conS = MyDB.GetSqlServerConnection("127.0.0.1", "111", "Northwind");
CBB = new MyComboBox(comboBox1, "select CustomerID,ContactName from Customers", "ContactName", "CustomerID", conA);
LB = new MyListBox(listBox1, "select CustomerID,ContactName from Customers", "CustomerID", "ContactName", conA);
CLB = new MyCheckedListBox(checkedListBox1, "select CustomerID,ContactName from Customers", "ContactName", "CustomerID", conA);
//checkedListBox1.Items.Add("selection1", true);//添加选中状态的项
}
public Form1()
{
InitializeComponent();
FM = new MyWinForm(this);
FM.SetDefaultStyle("Test");
con = MyDB.GetAccessConnection(AccessPath);
cmd.Connection = con;
cmd.CommandText = "select EmployeeID as ID,LastName+FirstName as 姓名,TitleOfCourtesy as 尊称 from Employees";
adapter = new OleDbDataAdapter(cmd);
adapter.Fill(dataset, "Tab");
table = dataset.Tables["Tab"];
BindDataToGVX();
BindDataToComboX();
}
private void button2_Click(object sender, EventArgs e)//确认新建数据库
{
DBName = textBox3.Text.Trim();
if (DBName == "")
{
MyDialog.Msg("请输入数据库名。", 2);
textBox3.Focus();
return;
}
foreach (FileInfo file in new DirectoryInfo(INI.Root).GetFiles())
{
if (file.Name.ToLower() == DBName.ToLower() + ".mdb")
{
MyDialog.Msg("根目录存在同名数据库。", 2);
textBox3.Focus();
return;
}
}
File.Copy(INI.Root + @"\Backup\New.mdb", INI.Root + @"\" + DBName + ".mdb");
MyModel.GetNewInstance(MyDB.GetAccessConnection(INI.Root + @"\" + DBName + ".mdb")).CreateTables();
MyDialog.Msg("创建完成！", 1);
textBox3.Clear();
textBox3.Focus();
}