public static bool Update(ExcelDataSet.WorkbooksDataTable table)
{
try
{
Table.TableAdapter.Update(table);
return(true);
}
catch (OleDbException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public static ExcelDataSet.WorkbooksRow GetDataRow(long workbookId)
{
try
{
ExcelDataSet.WorkbooksDataTable table = GetDataTable();
foreach (ExcelDataSet.WorkbooksRow row in table.Select(table.IdColumn.ColumnName + " = " + workbookId.ToString()))
{
return(row);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public C_WorkbookTable()
{
DataTable = new ExcelDataSet.WorkbooksDataTable();
TableAdapter = new WorkbooksTableAdapter();
}
