Problem with database access using sql string

[tim_rutter]

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 )

 

[cjard]

"to .NET 1.1"

-- but under your name it says you use .NET 2

Please edit your profile to accurately reflect what .net youre using. I dont want to go and give a load of advice that will be wrong because data access between 1.1 and 2 is very very different!