I'm trying to interrogate a database to display on a Datagrid. I am using a simple sql string to do this but am having problems.

The string I'm using is along the lines of

SELECT Database.Column1 AS ["Name1"], ... FROM Database

The trouble is one of the columns in the database is called "Section". When I try to use this is gives me an error:

SELECT Database.Column1 AS ["Name1"], Database.Section, ... FROM Database

If I rename the column it works. Trouble is I can't do this as the database is already in use by customers...

Please help!

(addition: I have just upgraded this code from vb6 where it worked fine to .net 1.1 )