private void UpdateWaitingList()
{
waitingList = new List <WaitingList>();
OleDbConnection cn = new OleDbConnection(); //Connection
OleDbCommand cmd = new OleDbCommand(); //Command
OleDbDataReader dr;
String path = Assembly.GetExecutingAssembly().Location;
path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb");
String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path);
cn.ConnectionString = @connectionString;
cmd.Connection = cn;
try
{
cmd.CommandText = "SELECT * FROM WaitingList";
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
WaitingList wl = new WaitingList(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[6].ToString());
waitingList.Add(wl);
}
}
cn.Close();
}
catch
{
// empty
}
}
private void UpdateWaitingList()
{
waitingList = new List<WaitingList>();
OleDbConnection cn = new OleDbConnection(); //Connection
OleDbCommand cmd = new OleDbCommand(); //Command
OleDbDataReader dr;
String path = Assembly.GetExecutingAssembly().Location;
path = path.Replace("bin\\Debug\\ICTProjectPOS.exe", "RestaurantDB.accdb");
String connectionString = String.Format("Provider=Microsoft.ACE.OLEDB.12.0;Data Source={0}", path);
cn.ConnectionString = @connectionString;
cmd.Connection = cn;
try
{
cmd.CommandText = "SELECT * FROM WaitingList";
cn.Open();
dr = cmd.ExecuteReader();
if (dr.HasRows)
{
while (dr.Read())
{
WaitingList wl = new WaitingList(dr[0].ToString(), dr[1].ToString(), dr[2].ToString(), dr[6].ToString());
waitingList.Add(wl);
}
}
cn.Close();
}
catch
{
// empty
}
}