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()); } }