Incorrect syntax near the keyword 'ORDER' in function two

using System;
using System.Data;
using System.Data.SqlClient;
using System.Windows.Forms;
using Microsoft.VisualBasic;

namespace Northwind_Sql_Data_Extraction
{
    public partial class Form1 : Form
    {
        public Form1()
        {
            InitializeComponent();
        }

        private void Form1_Load(object sender, EventArgs e)
        {
            // TODO: This line of code loads data into the 'northwindDataSet.Customers' table. You can move, or remove it, as needed.
            this.customersTableAdapter.Fill(this.northwindDataSet.Customers);
            // TODO: This line of code loads data into the 'northwindDataSet.Order_Details' table. You can move, or remove it, as needed.
            this.order_DetailsTableAdapter.Fill(this.northwindDataSet.Order_Details);
            // TODO: This line of code loads data into the 'northwindDataSet.Orders' table. You can move, or remove it, as needed.
            this.ordersTableAdapter.Fill(this.northwindDataSet.Orders);        
        }

        private void FunctionOne()
        {
            using (SqlConnection con = new SqlConnection("Data Source=LAPTOP-CI6IN3IA\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"))
            {
                string str = "SELECT Orders.OrderID, Orders.OrderDate, Customers.CompanyName, Customers.ContactName FROM Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID WHERE(((Orders.OrderID) = 10255))";
                SqlCommand cmd = new SqlCommand(str, con);
                SqlDataAdapter adapter = new SqlDataAdapter(cmd);
                DataTable dt = new DataTable();
                adapter.Fill(dt);
                dataGridView1.DataSource = new BindingSource(dt, null);
            }
        }

        private void FunctionTwo()
        {
            using (SqlConnection con = new SqlConnection("Data Source=LAPTOP-CI6IN3IA\\SQLEXPRESS;Initial Catalog=Northwind;Integrated Security=True"))
            {
                string str2 = "SELECT Customers.CompanyName, Orders.OrderID, Orders.OrderDate, Order Details.ProductID, Order Details.Quantity, Order Details.UnitPrice FROM (Customers RIGHT JOIN Orders ON Customers.CustomerID = Orders.CustomerID) LEFT JOIN Order Details ON Orders.OrderID = Order Details.OrderID WHERE(((Orders.OrderID) = 10255))";
                SqlCommand cmd2 = new SqlCommand(str2, con);
                SqlDataAdapter adapter1 = new SqlDataAdapter(cmd2);
                DataTable dt2 = new DataTable();
                adapter1.Fill(dt2);
                dataGridView1.DataSource = new BindingSource(dt2, null);
            }
        }

        private void Button1_Click(object sender, EventArgs e)
        {
            switch (comboBox1.SelectedItem.ToString())
            {
                case "Task 1":
                    FunctionOne();
                    break;
                case "Task 2":
                    FunctionTwo();
                    break;
                case "Task 3":
                    FunctionTwo();
                    break;
                case "Task 4":
                    FunctionTwo();
                    break;
                case "Task 5":
                    FunctionTwo();
                    break;
                default:
                    MessageBox.Show("Please select a value between 1 and 5");
                    break;
            }
        }
    }
}