Read SDF file in Desktop

Dear all,

I Need to read the Data from the SDF file in the Desktop. I have SQL Server 2005 in my System.

i know this is possible. but i dont know how it is ....

regards,

Tamil

You must install SQL Server Compact Edition 3.1 on your desktop in order to open SDF files.|||

Thank you Paulo. It is very useful..

Now i can manipulate the datas in the SDF files in VS 2005 environment.

Can i access those data using C# coding in Web Application or WS?

To connect this SDF file which provider i have to use?

Thanks & Regards,

|||

Yes i got it !!!

Now I can Read the SDF file data by importing System.Data.SqlServerCe; from the below Location

$Program Files$\Microsoft Visual Studio 8\Common7\IDE\PublicAssemblies\System.Data.SqlServerCe.dll

See the below Link

http://www.codeproject.com/cs/database/StartSqlServerEW.asp?df=100&forumid=321708&exp=0&select=1584032

Thanks And Regards