public static TableAdapter WriteDataTable(DataTable dataTable,
TableName tname, Locator locator,
string[] columnNames,
RowChangedHandler rowChangedHandler, ValueChangedHandler columnHandler)
{
if (dataTable == null)
{
return(null);
}
if (locator == null)
{
locator = new Locator(tname);
}
TableAdapter adapter = new TableAdapter(dataTable, tname, locator);
if (rowChangedHandler != null)
{
adapter.DataRowChangedHandler += rowChangedHandler;
}
if (columnHandler != null)
{
adapter.ValueChangedHandler = columnHandler;
}
adapter.AddFields(columnNames);
adapter.Save();
return(adapter);
}
public static TableAdapter WriteDataTable(DataTable dataTable,
TableName tname, Locator locator,
string[] columnNames,
RowChangedHandler rowChangedHandler, ValueChangedHandler columnHandler)
{
if (dataTable == null)
return null;
if (locator == null)
locator = new Locator(tname);
TableAdapter adapter = new TableAdapter(dataTable, tname, locator);
if(rowChangedHandler != null)
adapter.DataRowChangedHandler += rowChangedHandler;
if (columnHandler != null)
adapter.ValueChangedHandler = columnHandler;
adapter.AddFields(columnNames);
adapter.Save();
return adapter;
}
/// <summary>
/// save records into database
/// </summary>
public void Save(DataTable table)
{
TableAdapter.WriteDataTable(table, TableName, this.locator, null, null, null);
}
/// <summary>
/// save records into database
/// </summary>
public void Save()
{
T dpo = new T();
TableAdapter.WriteDataTable(dataTable, dpo.TableName, dpo.Locator, null, null, null);
}
