Populating Dataset from DataAdapter error-Collection of common programming errors

Top is a reserved keyword on Transact-SQL. When you want to use it in your sql command, you have to use it with square brackets like [TOP].

SqlDataAdapter da = new SqlDataAdapter(@"SELECT * FROM [Top]", conn);

That’s why you are getting

Incorrect syntax near the keyword ‘Top’