public static ExcelDataSet.WorksheetsRow GetDataRow(long worksheetId)
{
try
{
ExcelDataSet.WorksheetsDataTable table = GetDataTable();
foreach (ExcelDataSet.WorksheetsRow row in table.Select(table.IdColumn.ColumnName + " = " + worksheetId.ToString()))
{
return(row);
}
return(null);
}
catch (Exception ex)
{
throw ex;
}
}
public static bool Update(ExcelDataSet.WorksheetsDataTable table)
{
try
{
WorksheetsTableAdapter tableAdapter = new WorksheetsTableAdapter();
tableAdapter.Update(table);
return(true);
}
catch (OleDbException ex)
{
throw ex;
}
catch (Exception ex)
{
throw ex;
}
}
public C_WorksheetTable()
{
DataTable = new ExcelDataSet.WorksheetsDataTable();
TableAdapter = new WorksheetsTableAdapter();
}
