public void getOrderID()
{
try
{
//get the last order ID
OleDbCommand cmd = new OleDbCommand();
OleDbDataAdapter oleda = new OleDbDataAdapter();
DataSet ds = new DataSet();
cmd.Connection = oledbConn;
cmd.CommandType = CommandType.Text;
cmd.CommandText = "SELECT TOP 1 [OrderID] FROM [Order Details$] ORDER BY [OrderID] DESC";
oleda = new OleDbDataAdapter(cmd);
oleda.Fill(ds);
oleda.Dispose();
string OrderID = ds.Tables[0].Rows[0]["OrderID"].ToString();
int orID = Convert.ToInt32(OrderID) + 1;
//strring up order ID with the 0 padding
CurrentOrderID = orID.ToString().PadLeft(6, '0');
}
catch (Exception OrderIDs)
{
MessageBox.Show(OrderIDs.ToString());
}
}
