I find myself always digging through code and notes to find the syntax for creating a connection to a DB in C#.

There is a good article by Tony Patton about SQL Server connection strings and how use them in .NET (both C# and VB.NET examples).

Educate yourself about .NET SQL Server connection string syntax

ConnectionStrings.Com shows the syntax for just about every type of database (SQL, Access, MySQL, etc)