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 (1,1),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 (1,1),sr_no NVARCHAR(50),vehicle_no NVARCHAR(50),mobile_no NVARCHAR(50),user_name NVARCHAR(50),c_date datetime,u_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); } } }

Create .SDF file

Answers (2)