How to use SQL Server CE in an ASP.NET application

I want to create a new application using SQ开发者_开发问答L Server CE in asp.net but I don't know how it is started properly please anybody guide me how can I use this.

please help me....

Read Scott Guthrie's excellent intro blog post on the topic:

New Embedded Database Support with ASP.NET

He talks about how to use the new SQL Server Compact v4 edition that's specifically tailored to be used with ASP.NET applications.

Because CE is an embedded file-based DB, there is nothing really to start - you just specify the file in the connection string (see MSDN).

EDIT: CE is not supported on web apps until CE 4

However, watch out - while it is easy to deploy, CE might not be the best option for a highly threaded environment like a web-server (it is targetted at clients, really - although server usage is supported). See here for the TSQL differences, transaction differences, etc