First, you never ever connect to a database file (*.mdf) directly. You connect to the database, which knows where it's files are and handles them.
I didn't have a good (simple) example how to connect to the SQL Server. So I'll give you few links to get started. First you'll need to get familiar with
System.Data.SqlClient namespace. Second thing to learn are
connection strings.
Objects that you need to make a basic SQL Server connection and get the basic "functionality" are Connection and Command from the System.Data.SqlClient namespace. I also assume you're familiar with SQL. If you're not, try to google some SQL tutorial.
Reputation Points: 218
Solved Threads: 201
Veteran Poster
Offline 1,024 posts
since Aug 2008
Unsolved 
