DataBase with Extension SDF

Question

Hi friends
i have a database in extention sdf
and now i want to know how i can insert it StoredProcedure?
I create it in Visual Studio 2008 and need to backup it and then restore it in C# language PLZ Help me to do it?
Thank you

Roei Bar · Answer

well, you cant exactly add things to the sdf file but you can interact with it via C# here is a Class i built for that metter using System; using System.Collections.Generic; using System.Text; using System.Data.SqlServerCe; using System.Data; namespace SQL { class SQLCe { #region---Class Members--- SqlCeConnection _Connection; SqlCeCommand _Command; #endregion #region ---Constructor--- internal SQLCe() { _Connection = new SqlCeConnection(); _Command = (SqlCeCommand)this.NewCommand(); } #endregion #region Members public IDbConnection Connection { get { return _Connection; } } public IDbDataAdapter CreateAdapter(string SelectCommand) { return new SqlCeDataAdapter(SelectCommand, (SqlCeConnection)this.Connection); } public string ConnectionString { get { return _Connection.ConnectionString; } set { _Connection.ConnectionString = value; } } public void Connect() { _Connection.Open(); } public void Connect(string ConnectionString) { this.ConnectionString = ConnectionString; _Connection.Open(); } public void Disconnect() { _Connection.Close(); } public void ReConnect() { _Connection.Close(); _Connection.Open(); } public void BeginTran() { NewCommand("begin tran").ExecuteNonQuery(); } public void CommitTran() { NewCommand("commit tran").ExecuteNonQuery(); } public void RollBack() { NewCommand("rollback").ExecuteNonQuery(); } public void PopulateDataTable(DataTable DataTable, string Select) { PopulateDataTable(DataTable, NewCommand(Select)); } public void PopulateDataTable(DataSet DataSet, string Select) { PopulateDataTable(DataSet, NewCommand(Select)); } public void PopulateDataTable(DataSet DataSet, IDbCommand Select) { SqlCeDataAdapter Adp = new SqlCeDataAdapter((SqlCeCommand)Select); Adp.Fill(DataSet); } public void PopulateDataTable(DataTable DataTable, IDbCommand Select) { SqlCeDataAdapter Adp = new SqlCeDataAdapter((SqlCeCommand)Select); Adp.Fill(DataTable); } public IDbCommand NewCommand() { return NewCommand(""); } public IDbCommand NewCommand(string Command) { return new SqlCeCommand(Command, this._Connection); } public int ExecuteNonQuery(IDbCommand Command) { return Command.ExecuteNonQuery(); } public object ExecuteScalar(IDbCommand Command) { return Command.ExecuteScalar(); } public void SetAdaptertInsertCommand(string Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).InsertCommand = (SqlCeCommand)NewCommand(Query); } public void SetAdaptertUpdateCommand(string Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).UpdateCommand = (SqlCeCommand)NewCommand(Query); } public void SetAdaptertDeleteCommand(string Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).DeleteCommand = (SqlCeCommand)NewCommand(Query); } public void SetAdaptertInsertCommand(IDbCommand Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).InsertCommand = (SqlCeCommand)Query; } public void SetAdaptertUpdateCommand(IDbCommand Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).UpdateCommand = (SqlCeCommand)Query; } public void SetAdaptertDeleteCommand(IDbCommand Query, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).DeleteCommand = (SqlCeCommand)Query; } public IDbCommand GenerateInsertCommand(IDataAdapter Adapter) { SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter); return builder.GetInsertCommand(false); } public IDbCommand GenerateUpdateCommand(IDataAdapter Adapter) { SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter); return builder.GetUpdateCommand(false); } public IDbCommand GenerateDeleteCommand(IDataAdapter Adapter) { SqlCeCommandBuilder builder = new SqlCeCommandBuilder((SqlCeDataAdapter)Adapter); return builder.GetDeleteCommand(false); } public void UpdateAdapter(DataTable Table, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).Update(Table); } public void UpdateAdapter(DataSet DataSet, IDataAdapter Adapter) { ((SqlCeDataAdapter)Adapter).Update(DataSet); } #endregion } } on the connection string make sure the format is as following : "DataSource = {0};Encrypt=True ;pwd = {1}"; dont forget to mark this as " Accepted Answer "

Maharaje · Answer

what is the Query forBackup & restore for in VisualStudio? i repeat my db is not in SQLSERVER my mean is there isn't any server and ... for it! i need Query for BackUp & Restore PLZ

Maharaje · Answer

thank you what are these? : "DataSource = {0};Encrypt=True ;pwd = {1}"; and they are for what?

DataBase with Extension SDF

Answers (3)