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