datagridview 自動填滿、及排序

    // 顯示DataGridview1
    using (SqlDataAdapter da = new SqlDataAdapter("Select Company_Number AS 公司編號  ,Date AS 日期 , " +
        " Case when Path = 1 then '入庫' when Path = 0 then '出庫' END AS 進出庫 , " +
        " Case when Authorize = 1 then '成功' when Authorize = 0 then '失敗' END AS  驗證 , " +
        " Case when State = 1 then '舊品' when State = 0 then '新品' END AS  新舊 " +
        " From DoorPort", conn))
    {
        DataTable sqldt = new DataTable();
        da.Fill(sqldt);
        dataGridView1.DataSource = sqldt;
        // datagridview 以 入庫時間排序 (最新一筆在最上面)
        dataGridView1.Sort(dataGridView1.Columns[1], System.ComponentModel.ListSortDirection.Descending);
        // gridview自動充滿顯示區
        dataGridView1.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.Fill;
    }