public void FillUSR_LIS_VEN(ValorizzaMagazziniDS ds)
{
string select = @"select * from USR_LIS_VEN";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.USR_LIS_VEN);
}
}
public void FillSALDI_GEN(ValorizzaMagazziniDS ds)
{
string select = @"select * from saldi_gen";
using (DbDataAdapter da = BuildDataAdapter(select))
{
da.Fill(ds.SALDI_GEN);
}
}
public void UpdateMonitorDSTable(string tablename, ValorizzaMagazziniDS 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);
}
}
