How to copy included file programmatically

Question

I have a Visual C# 2008 project. Within my project explorer, I have an SQL CE database (sdf file) so I can work with the database and dataset in the designer. At runtime, the sdf file is copied to the output directory. When the user saves their own database, this sdf file is copied to whatever filename the user chooses and their dataset is saved to the copy. No problem so far.

I'd like to do this a different way if possible. Rather than having the sdf file copied out when the program first runs, I'd like to set it up so that when the user saves their database, THEN it copies out the sdf file using the name of their choosing and saves their dataset to it.

I have read ways to write out the file as binary, which does work but it takes several lines of code that just seems unnecessary. Isn't there a way just to tell the program "hey, go ahead and copy this sdf file out real quick"? After all, the program is able to automatically do it when you first run it.

Answer 1

Add the database file as a resource in your project. Then when you want the file to be appear just write out the byte array to a file.

Example:

File.WriteAllBytes("destination path", Properties.Resources.YourResourceName);

Answer 2

i love to share my knowledge with you stack users you can analyse this code find something can help

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Windows.Forms;

using System.Data.SqlServerCe;

using System.IO;

namespace localdatabaseconnect

{

public partial class Form1 : Form

{
    public Form1()
    {
        InitializeComponent();
    }
    string conString = Properties.Settings.Default.locallyConnectionString;
    private void button1_Click(object sender, EventArgs e)
    {


        // Open the connection using the connection string.
        using (SqlCeConnection con = new SqlCeConnection(conString))
        {
            con.Open();

            // Insert into the SqlCe table. ExecuteNonQuery is best for inserts.
            int id = int.Parse(textBox1.Text);
            string nom = textBox2.Text;
            string prenom = textBox3.Text;
            using (SqlCeCommand com = new SqlCeCommand("INSERT INTO testme (id,nom,prenom) VALUES(@id,@nom,@prenom)", con))
            {
                com.Parameters.AddWithValue("@id", id);
                com.Parameters.AddWithValue("@nom", nom);
                com.Parameters.AddWithValue("@prenom", prenom);
                com.ExecuteNonQuery();
            }
            con.Close();
        }
    }

    private void button2_Click(object sender, EventArgs e)
    {
        using (SqlCeConnection con = new SqlCeConnection(conString))
        {
            con.Open();
            // Read in all values in the table.
            using (SqlCeCommand com = new SqlCeCommand("SELECT * FROM testme", con))
            {
                SqlCeDataReader reader = com.ExecuteReader();
                while (reader.Read())
                {
                    string num = reader[0].ToString();
                    MessageBox.Show("hi"+num);
                }
            }
            con.Close();
        }
    }

    private void button3_Click(object sender, EventArgs e)
    {

        string path = "c:\\ChekatyResources";
     try{

      if (!Directory.Exists(path))
        {

      // Try to create the directory.
          DirectoryInfo di = Directory.CreateDirectory(path);
         MessageBox.Show("file is created");
         }
       else {

          MessageBox.Show("file is exist");

          }
          }
            catch (IOException ioex)
           {
  MessageBox.Show(ioex.Message);
           }

       }

    private void Form1_Load(object sender, EventArgs e)
    {
        //string executable = System.Reflection.Assembly.GetExecutingAssembly().Location;

        //string path = (System.IO.Path.GetDirectoryName(executable));
        //MessageBox.Show(path);
        //File.WriteAllBytes("destination path",);
        string paths = "c:\\";
        AppDomain.CurrentDomain.SetData("DataDirectory", paths);

        string connStr = @"Data Source =c:\ChekatyResources\locally.sdf;";

        if (!File.Exists(@"c:\ChekatyResources\locally.sdf"))
        {

            SqlCeEngine engine = new SqlCeEngine(connStr);
            engine.CreateDatabase();

            SqlCeConnection conn = null;


            try
            {
                conn = new SqlCeConnection(connStr);
                conn.Open();

                SqlCeCommand cmd = conn.CreateCommand();
                cmd.CommandText = "CREATE TABLE testme(id int, prenom ntext,nom ntext)";
                cmd.ExecuteNonQuery();
            }
            catch
            {

            }
            finally
            {
                conn.Close();
            }
        }
        else { MessageBox.Show("it's exist"); }
    }
}

}