title: Giving a SQL query a title in C#
body: <p>I'm building a console application to push out several different reports via email and including the report attached in a .CSV file.</p>
  
  <p>The reports are coming from SQL Server, some are Stored Proc's, others are (lazily) statically typed for now.</p>
  
  <p>However I was wondering if there was a way to give a name / title dynamically to a query table based on what was being returned? Reason being is that the Report Email subject and attachment will be based off of that query and I would like it to dynamically reflect the query the was being run.</p>
  
  <p>I'm aware I could within the Proc's/Query add a column with blank data, name the column the title of the report and then remove the column from the results presented, but this seems a bit hacked together and I wondered if there was a better way?</p>
  
  <p>Thanks!</p>