Connecting to SQL Compact Edition using Visual Studio 2008

Hi Everybody,

I am new to VB.NET. I have googled around for the connection string to connect with Sql Compact edition database. but i really have no idea how to do that. furthermore i dont know how to connect a form's fields to that database. please give me a very simple example of doing this which can really clear the concepts. i will be very grateful to you.

thank you.

and please tell me if i wana use ms sql server 2005 and dotn wana use sql compact edition then what i have to do?

thanx

re: Connecting to SQL Compact Edition using Visual Studio 2008

For your connectionstring, have a look here. Form fields can be connected to database fields using Data Binding. If you want to use SQL Server 2005, just do so... I don't see what the problem is :-)

Steven