Вывод записей в datagridview
Здравствуйте пытаюсь вывести записи в datagridview C# я пытался сделать вывод через Listbox чтобы заголовки были. Код ниже:
Database database = new Database();
SqlCommand cmd;
SqlDataReader dr;
public Dashboard()
{
InitializeComponent();
}
private void Dashboard_Load(object sender, EventArgs e)
{
database.openConnection();
cmd = new SqlCommand();
cmd.Connection = database.getConnection();
cmd.CommandText = "SELECT Format(Orders.Date,'yyyy-MM') as Dates FROM Departments INNER JOIN DepartmentLocations ON Departments.ID = DepartmentLocations.DepartmentID INNER JOIN Assets ON DepartmentLocations.ID = Assets.DepartmentLocationID INNER JOIN EmergencyMaintenances ON Assets.ID = EmergencyMaintenances.AssetID INNER JOIN Orders ON EmergencyMaintenances.ID = Orders.EmergencyMaintenancesID INNER JOIN OrderItems ON Orders.ID = OrderItems.OrderID Group By Format(Orders.Date,'yyyy-MM')";
dr = cmd.ExecuteReader();
while (dr.Read())
{
listBox1.Items.Add(dr["Dates"]);
}
database.closeConnection();
loaddata();
}
public void loaddata()
{
DataTable dt = new DataTable();
for (int i = 0; i < listBox1.Items.Count; i++)
{
dt.Columns.Add(listBox1.Items[i].ToString());
}
dgvEMSpending.DataSource = dt;
}

