public static ExcelDataSet.CellsRow GetDataRow(int cellId)
{
try
{
ExcelDataSet.CellsDataTable table = GetDataTable();
foreach (ExcelDataSet.CellsRow row in table.Select(table.IdColumn.ColumnName + " = " + cellId.ToString()))
{
return(row);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(ExcelDataSet.CellsDataTable table)
{
try
{
CellsTableAdapter tableAdapter = new CellsTableAdapter();
tableAdapter.Update(table);
return(true);
}
catch (OleDbException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public C_CellTable()
{
DataTable = new ExcelDataSet.CellsDataTable();
TableAdapter = new CellsTableAdapter();
}