This like a fairly rudimentary problem. You mentioned that you got a syntax error. What exactly was the error? Generally, the error output will be clear enough to explain the problem. Posting that you got an error with the line of code doesn't do us much good without the detail of the error message.
Have you looked at any tutorials on connecting to a database? This is a basic process that many many articles contain. You should be able to find some walk through that could help you.
One thing to note: the "ConfigurationSettings" class has been deprecated. It has been replaced with the ConfigurationManager class. This shouldn't cause a problem, just compiler warnings.