How can set datagrid column header name from a database row

It was a small account. The rows have variable expense criteria(ex. food, transport, phone, water, gas, electricity). In another table(id, date, expenses, summ, comment) these are used as limited static column options for expenses. As a summary I need a table which describes monthly expenses in a selected year. In this table the expense criteria are column names.