using System;
using System.Windows.Forms;
using System.Drawing;
using System.Data.SqlClient;

class ex : Form
{
    Label lb1 = new Label();
    Label lb2 = new Label();
    Label lb3 = new Label();
    TextBox tb1 = new TextBox();
    TextBox tb2 = new TextBox();
    TextBox tb3 = new TextBox();

    Button b1 = new Button();
    DataGridView dgv = new DataGridView();
    int rw = 0;

    ex()
    {
        Width = 500;
        Text = "Customer Orders";
        lb1.Text = "CustomerID:";
        lb2.Text = "First Name:";
        lb3.Text = "Last Name:";
        lb2.Location = new Point(0, 25);
        lb3.Location = new Point(0, 50);
        Controls.Add(lb1);
        Controls.Add(lb2);
        Controls.Add(lb3);
        tb1.Location = new Point(100, 0);
        tb2.Location = new Point(100, 25);
        tb3.Location = new Point(100, 50);
        Controls.Add(tb1);
        Controls.Add(tb2);
        Controls.Add(tb3);

        b1.Text = "Return";
        b1.Click += new EventHandler(button_b1_click);
        b1.Location = new Point(200, 0);
        dgv.Location = new Point(0, 75);
        dgv.Height = 400;
        dgv.Width = 500;
        dgv.ReadOnly = true;
        dgv.AllowUserToAddRows = false;

        dgv.BackgroundColor = Color.White;
        dgv.GridColor = Color.FromArgb(230, 230, 230);
        dgv.ColumnCount = 4;
        dgv.RowHeadersDefaultCellStyle.BackColor = Color.FromArgb(251, 251, 251);
        dgv.RowHeadersBorderStyle = DataGridViewHeaderBorderStyle.Single;
        dgv.RowTemplate.Height = 18;

        dgv.Columns[0].Name = "OrderID";
        dgv.Columns[1].Name = "OrderDate";
        dgv.Columns[2].Name = "DeliveryMethod";
        dgv.Columns[3].Name = "DeliveryDate";

        Controls.Add(dgv);
        Controls.Add(b1);
    }

    void button_b1_click(object sender, EventArgs e)
    {
        SqlConnection conn = new SqlConnection("Data Source = (localdb)\\sql;" +
                                  "User id= sample_user;" +
                                  "Password = 'abc'; " +
                                  "Database = ex;");

        conn.Open();
        SqlCommand command = new SqlCommand(
                                  "select FirstName, LastName " +
                                  "from Customers " +
                                  "where CustomerID = @0", conn);
        command.Parameters.Add(new SqlParameter("0", tb1.Text));
        SqlDataReader reader = command.ExecuteReader();
        if (reader.Read())
        {
            tb2.Text = reader[0].ToString();
            tb3.Text = reader[1].ToString();
        }
        else
        {
            tb2.Text = "";
            tb3.Text = "";
        }
        reader.Close();

        dgv.Rows.Clear();
        rw = 0;
        command = new SqlCommand(
                                  "select o.OrderID, OrderDate, DeliveryMethod, DeliveryDate " +
                                  "from Orders o " +
                                  "join CustomerOrder co on o.OrderID = co.OrderID " +
                                  "join Customers c on co.CustomerID = c.CustomerID " +
                                  "where c.CustomerID = @0", conn);
        command.Parameters.Add(new SqlParameter("0", tb1.Text));
        reader = command.ExecuteReader();
        while (reader.Read())
        {
            dgv.Rows.Add();
            dgv.Rows[rw].HeaderCell.Value = (rw + 1).ToString();
            dgv.Rows[rw].Cells[0].Value = reader[0];
            dgv.Rows[rw].Cells[1].Value = reader[1];
            dgv.Rows[rw].Cells[2].Value = reader[2];
            dgv.Rows[rw].Cells[3].Value = reader[3];
            rw = rw + 1;
        }
        conn.Close();
    }

    [STAThread]
    static public void Main()
    {
        Application.Run(new ex());
    }
}