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