Как я могу получить данные из базы данных в datagridview в нескольких строках, используя один и тот же идентификатор

---

public void fieldsgetdata() //using method to retrive data
       {
           SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ESS"].ConnectionString);//VED_ID=(SELECT max(VED_ID)from Vehicle_Expense_Detail )
           conn.Open();
           SqlDataAdapter da = new SqlDataAdapter("SELECT EXP_EXPENSEHEAD_ID as 'Expense ID',VED_QTY as 'Quantity',VED_RATE as 'Rate',VED_AMOUNT as 'Amount',VED_REMARKS as 'Remarks' ,VED_NARRATION as 'Narration' FROM Vehicle_Expense_Detail WHERE VEM_ID=(SELECT max(VEM_ID)from Vehicle_Expense_Detail); ", conn);
           DataTable dt = new DataTable();
           da.Fill(dt);





           for (int i = 0; i < dataGridView1.Rows.Count -1; i++)
           {

               dataGridView1.Rows[i].Cells[0].Value = dt.Rows[0][0].ToString();
               dataGridView1.Rows[i].Cells[0].Value = dt.Rows[1][0].ToString();






           }

       }

Что я уже пробовал:

<pre> public void fieldsgetdata() //using method to retrive data
        {
            SqlConnection conn = new SqlConnection(ConfigurationManager.ConnectionStrings["ESS"].ConnectionString);//VED_ID=(SELECT max(VED_ID)from Vehicle_Expense_Detail )
            conn.Open();
            SqlDataAdapter da = new SqlDataAdapter("SELECT EXP_EXPENSEHEAD_ID as 'Expense ID',VED_QTY as 'Quantity',VED_RATE as 'Rate',VED_AMOUNT as 'Amount',VED_REMARKS as 'Remarks' ,VED_NARRATION as 'Narration' FROM Vehicle_Expense_Detail WHERE VEM_ID=(SELECT max(VEM_ID)from Vehicle_Expense_Detail); ", conn);
            DataTable dt = new DataTable();
            da.Fill(dt);
           
           



            for (int i = 0; i < dataGridView1.Rows.Count -1; i++)
            {
               
                dataGridView1.Rows[i].Cells[0].Value = dt.Rows[0][0].ToString();
                dataGridView1.Rows[i].Cells[0].Value = dt.Rows[1][0].ToString();






            }

        } 

---