public SQLDBConnectLite() { OleDbConnectionStringBuilder bldr = new OleDbConnectionStringBuilder(); bldr.DataSource = IVRShared.GetDBPath(); bldr.Provider = DataProvider; // ”казываем провайдера bldr.Add("Jet OLEDB:Database Password", "ivr32a"); OleDbCon = new OleDbConnection(bldr.ConnectionString); }
private void backgroundWorker1_DoWork(object sender, DoWorkEventArgs e) { backgroundWorker.ReportProgress(0, "Загрузка данных..."); newDBcon = new MainDBConnect(IVRShared.GetDBPath()); IsPresentView = new DataView(newDBcon.GetDataTable("spec")); IsPresentView.RowFilter = "is_present = true"; backgroundWorker.ReportProgress(100, "Загрузка завершена!"); }
//public SQLDBConnect(String tableName, String stringSQL) public SQLDBConnect() { OleDbConnectionStringBuilder bldr = new OleDbConnectionStringBuilder(); bldr.DataSource = IVRShared.GetDBPath(); bldr.Provider = DataProvider; // Указываем провайдера bldr.Add("Jet OLEDB:Database Password", "ivr32a"); OleDbCon = new OleDbConnection(bldr.ConnectionString); //dataAdapter = new OleDbDataAdapter(); da = new Dictionary <string, OleDbDataAdapter>(); sprSet = new DataSet(); }