<div>
read this article <br />
<br />
<a href="http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcedbcreate.aspx" rel="ugc">http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcedbcreate.aspx</a>
</div>


read this article

http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcedbcreate.aspx [http://samples.gotdotnet.com/quickstart/CompactFramework/doc/sqlcedbcreate.aspx]

<div>
aneeshattingal my friend... you are a star! That worked a treat, just had to change C:\ to a valid Pocket PC path, ie \\Program Files\\TestApp\\, etc<br />
<br />
And just to add for anyone else who looks for this, to password protect the database:<br />
<br />
SqlCeEngine engine = new SqlCeEngine(&quot;Data Source='\\Program Files\\TestApp\\test.sdf';<wbr /> Password='password'&quot;);<br />
engine.CreateDatabase();<br />
<br />
Cheers<br />
<br />
Andrew
</div>


aneeshattingal my friend... you are a star! That worked a treat, just had to change C:\ to a valid Pocket PC path, ie \\Program Files\\TestApp\\, etc

And just to add for anyone else who looks for this, to password protect the database:

SqlCeEngine engine = new SqlCeEngine("Data Source='\\Program Files\\TestApp\\test.sdf'; Password='password'");
engine.CreateDatabase();

Cheers

Andrew

<div>
Ok.. Now you can close the Question ...
</div>


<div>
<div class="content wysiwyg-content">
Hello,<br />
<br />
Can anyone point me to a way to programatically create a SQL Server CE 2000 database (.sdf file) using C#.<br />
<br />
Cheers<br />
<br />
Andrew
</div>
</div>


Hello,

Can anyone point me to a way to programatically create a SQL Server CE 2000 database (.sdf file) using C#.

Cheers

Andrew

Programatically create SQL Server CE 2000 database in C#

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.