public static bool AddExpenseUnitToSelection(string item)
{
if (!ExpenseUnitsSelection.Contains(item))
{
ExpenseUnitsSelection.Add(item);
return(true);
}
else
{
return(false);
}
}
public static void GetExpenseUnitsSelection()
{
string sql = "Select Distinct Unit from tblFishingExpenseItems";
using (var con = new OleDbConnection(global.ConnectionString))
{
using (var dt = new DataTable())
{
con.Open();
var adapter = new OleDbDataAdapter(sql, con);
adapter.Fill(dt);
foreach (DataRow dr in dt.Rows)
{
ExpenseUnitsSelection.Add(dr["Unit"].ToString());
}
}
}
}
