public static void LessRentedCars() { Console.Clear(); string conString = "Data Source=DESKTOP-MJA5A7T;Initial Catalog=Car Rent;Integrated Security=True"; SqlConnection con = new SqlConnection(conString); con.Open(); Console.WriteLine("Month:"); int month = int.Parse(Console.ReadLine()); Console.WriteLine("Year"); int year = int.Parse(Console.ReadLine()); Console.Clear(); SqlDataAdapter dataAdapter = new SqlDataAdapter("select r.CarID, Plate from Reservations r join Cars c on r.CarID=c.CarID where MONTH(StartDate)=@month and YEAR(StartDate)=@year", con); dataAdapter.SelectCommand.Parameters.AddWithValue("@month", month); dataAdapter.SelectCommand.Parameters.AddWithValue("@year", year); DataTable dt = new DataTable(); dataAdapter.Fill(dt); DataTable newTable = NewTableWithCountRentsColumn(dt); newTable = OrderBy.OrderByNumberOfRents(newTable); int width = Console.WindowWidth; width = width / 3; Write.WriteProgress("CarID", 1, 1); Write.WriteProgress("Plate", width, 1); Write.WriteProgress("NumberOfRents", 2 * width, 1); int r = 3; foreach (DataRow row in newTable.Rows) { Write.WriteProgress(row["CarID"].ToString(), 1, r); Write.WriteProgress(row["Plate"].ToString(), width, r); Write.WriteProgress(row["NumberOfRents"].ToString(), 2 * width, r); r++; if (r == 26) { break; } } }