public class MoveData
    {
    

        private SqlCeConnection conection;
        private SqlCeTransaction trans;
        private SqlCeDataAdapter command;

        public MoveData(String path)
        {
            
            conection = new SqlCeConnection(@"Data Source=D:\MyDataBase.sdf");
            conection.Open();
        }

        public void MovingData()
        {
            
           
            //It's a empty table
	    command = new SqlCeDataAdapter("SELECT * FROM INVOICE", conection);
            DataSet dataSet = new DataSet();

            DataSet dataSet = new DataSet();
            command.Fill(dataSet, "INVOICE");
            DataTable TINVOICE = dataSet.Tables["INVOICE"];
            trans = conection.BeginTransaction();
        

            foreach (DataRow row in TINVOICEotherdatabasetable.Rows)
            {
               
                DataRow row1 = TINVOICE.NewRow();
                foreach(DataColumn column in TINVOICEotherdatabasetable.Columns)
                {
                    row1[column.ColumnName] = row[column.ColumnName];
                   
                }
                TINVOICE.Rows.Add(row1);

            }
           
               SqlCeCommandBuilder commands = new SqlCeCommandBuilder(command);
                command.Update(dataSet,"INVOICE"); //here save me changes in database
                trans.Rollback();// this Rollback doesn't work, Why ??
               
            
        }
    }