public void UpdateTable(string tablename, FBVDS ds)
{
string query = string.Format(CultureInfo.InvariantCulture, "SELECT * FROM {0}", tablename);
using (DbDataAdapter a = BuildDataAdapter(query))
{
a.ContinueUpdateOnError = false;
DataTable dt = ds.Tables[tablename];
DbCommandBuilder cmd = BuildCommandBuilder(a);
a.UpdateCommand = cmd.GetUpdateCommand();
a.DeleteCommand = cmd.GetDeleteCommand();
a.InsertCommand = cmd.GetInsertCommand();
a.Update(dt);
}
}
public void FillGruppi(FBVDS ds, bool soloNonCancellati)
{
string select = @"SELECT * FROM FBVGRUPPIPROPRIETA ";
if (soloNonCancellati)
{
select += "WHERE CANCELLATO = 'N'";
}
select += "ORDER BY DESCRIZIONE ";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.FBVGRUPPIPROPRIETA);
}
}
public void FillProcessi(FBVDS ds, bool soloNonCancellati)
{
string select = @"SELECT * FROM FBVPROCESSI ";
if (soloNonCancellati)
{
select += "WHERE CANCELLATO = 'N'";
}
select += "ORDER BY DESCRIZIONE ";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.FBVPROCESSI);
}
}
public void UpdateTable(FBVDS ds, string tabella)
{
FbvAdapter a = new FbvAdapter(DbConnection, DbTransaction);
a.UpdateTable(tabella, ds);
}
public void FillGruppi(FBVDS ds, bool soloNonCancellati)
{
FbvAdapter a = new FbvAdapter(DbConnection, DbTransaction);
a.FillGruppi(ds, soloNonCancellati);
}
