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(); }