Create .SDF file

Question

How can we create .sdf file for our Database?

Abhineet Srivastava · Answer

i did it with the help of Command prompt. :)

Mukesh Kumar Tiwari · Answer

This is For vs 2008 using System; using System; using System.Linq; using System.Collections.Generic; using System.ComponentModel; using System.Data; using System.Drawing; using System.Text; using System.Windows.Forms; using System.Data.SqlServerCe; using System.IO; namespace Rajkamal_Rto { public partial class Form1 : Form { public SqlCeEngine engine = new SqlCeEngine(Data Source=D:\Rajkamal\Rajkamal.sdf); string ConnStr = Data Source=D:\Rajkamal\Rajkamal.sdf; SqlCeConnection Conn; SqlCeCommand Cmd; SqlCeDataAdapter Adp; public Form1() { InitializeComponent(); } private void Form1_Load(object sender EventArgs e) { create_directory(); create_database(); } public void create_directory() { string name = D:\Rajkamal; if (!Directory.Exists(name)) { Directory.CreateDirectory(name); return; } } public void create_database() { if (!File.Exists(D:\Rajkamal\Rajkamal.sdf)) { try { Conn = new SqlCeConnection(ConnStr); engine.CreateDatabase(); Conn.Open(); string create_table_user_master = Create table user_master(user_id INT IDENTITY (11)user_name NVARCHAR(50)password NVARCHAR(50)); Cmd = new SqlCeCommand(create_table_user_master Conn); Cmd.ExecuteNonQuery(); string create_table_vehicle_master = Create table vehicle_master(vehicle_id INT IDENTITY (11)sr_no NVARCHAR(50)vehicle_no NVARCHAR(50)mobile_no NVARCHAR(50)user_name NVARCHAR(50)c_date datetimeu_user NVARCHAR(50)u_date datetime); Cmd = new SqlCeCommand(create_table_vehicle_master Conn); Cmd.ExecuteNonQuery(); Conn.Close(); ceate_first_user(); } catch (Exception ex) { MessageBox.Show(ex.Message); } } }