ConnectionString with .mdf file

[pencil151]

Hello I'm trying to create a connection string to a AddressBook.mdf file. This file only has 1 table which is "Addresses." This file is located in the root of C:\ Here's what I have:

public Form1()
{
InitializeComponent();
string conn = @"Provider=Microsoft.Jet.OLEDB.4.0;Data Source=C:\AddressBook.mdf";
OleDbConnection myConn = new OleDbConnection();
myConn.ConnectionString = conn;
OleDbDataAdapter daAddress = new OleDbDataAdapter("SELECT * FROM Addresses", myConn);
DataSet dsAddress = new DataSet();
daAddress.Fill(dsAddress, "Addresses");
}


I get an error on daAddress.Fill(dsAddress, "Addresses"); it says "unrecognized database format 'c:\AddressBook.mdf'.

This connection string works on .mdb files, but how do I create a connection string to a .mdf file?

 

[misterstick]

and the reason you're not connecting via sql server is...

mr s. <

 

[pencil151]

Oh I'm just practicing with C# books "Deitel C# for programmers." In this exercise it has an .mdf. I drop the tables into the "form" but when I do this it automatically creates the adapter, binding, and dataGrid. For learning purposes I wanted to create those items manually but I'm already stuck. =\