I think I missed this one out. Many of us connect to Microsoft's SQL Server database using controls. I don't usually use this technique because it is quite limiting for me. Here's how to connect to MSSQL Server 2005 database using C#: 1. First, create a database (I'm using MS SQL Server 2005 express edition, so I use the SQL Server Management Studio IDE which can be downloaded here .) 2. To proceed, I'm assuming that you can already connect to your server (or the instance thereof). If the Windows Authentication doesn't work, you might want to try the user 'sa'. The password actually depends on what you specified during its installation. 3. Right click on the "Databases" folder and click "New Database". (Just leave everything default and click ok). 4. Expand the newly created database folder (in my case, it's testDB1), and create a new table with the following attributes: Table Name: TestTable1 Fields: Id:Integer, auto increment, p...