public override DataSet UpdateCategory(string q)
{
category.Tables.Clear();
using (Access10 db = new Access10(datafile))
category = db.Delete(Context.CategoryName, q, UpdateCategoryAdapter, UpdateCategoryFillOperation);
return(category);
}
public override DataSet Update(string q)
{
data.Tables.Clear();
using (Access10 db = new Access10(datafile))
data = db.Update(Context.TableName, q, AdapterUpdate, FillUpdate);
return(data);
}
static public DataSet GetSchemas(AccessDataContext info)
{
DataSet ds = new DataSet(ole_ace12);
using (Access10 acedb = new Access10(info.source))
{
bool failedConnecting = false;
using (OleDbConnection c = acedb.Connection)
{
try { c.Open(); c.Close(); } catch { failedConnecting = true; }
}
if (failedConnecting)
{
ErrorMessage.Show("Couldn't do it");
return(null);
}
using (OleDbConnection c = acedb.Connection)
using (OleDbDataAdapter a = new OleDbDataAdapter())
{
c.Open();
try {
Tds(c, ds);
} catch (Exception) {
throw;
};
c.Close();
}
}
return(ds);
}
public override DataSet SelectCategory(string q)
{
category.Tables.Clear();
category.Tables.Add(Context.CategoryName);
using (Access10 db = new Access10(datafile))
category = db.Select(Context.CategoryName, q, SelectCategoryAdapter, SelectCategoryFillOperation);
return(category);
}
public override DataSet Insert(string q)
{
data.Tables.Clear();
using (Access10 db = new Access10(datafile))
{
data = db.Insert(Context.TableName, q, AdapterInsert, FillInsert);
}
return(data);
}
public override DataSet Select(string q)
{
if (data == null)
{
data = new DataSet();
}
data.Tables.Clear();
using (Access10 db = new Access10(datafile))
data = db.Select(Context.TableName, q, AdapterSelect, FillSelect);
return(data);
}
public override void Create(string filename)
{
this.DataContext = new AccessDataContext(filename, null);
Database = new Access10(filename);
}
