SqlConnection SourceCon = new SqlConnection("Data Source=********");
            SqlCeConnection destCon = new SqlCeConnection("Data Source=*********");
            SourceCon.Open();
            destCon.Open();
            SqlCommand commandSource = new SqlCommand("SELECT Id, FullName, MacroId, ProdId, Art3Id, Ed_izm FROM Goods "+
                " WHERE MacroId=1  "+
                " Order by id"
                , SourceCon);
            SqlDataReader reader = commandSource.ExecuteReader();
            while (reader.Read()) 
            {
                DataRow row = storeDataSet.Goods.NewRow();
                row["id"] = reader["Id"];
                row["FullName"] = reader["FullName"];
                row["MacroId"] = reader["MacroId"];
                row["ProdId"] = reader["ProdId"];
                row["Art3Id"] = reader["Art3Id"];
                row["Ed_izm"] = reader["Ed_izm"];
                SqlCeDataAdapter ceAdap = new SqlCeDataAdapter();
                int @id = Convert.ToInt32(reader[0]);
                string @FullName = Convert.ToString(reader[1]);
                int @MacroId = Convert.ToInt32(reader[2]);
                int @ProdId = Convert.ToInt32(reader[3]);
                int @Art3Id = Convert.ToInt32(reader[4]);
                string @Ed = Convert.ToString(reader[5]);
                decimal @Price = Convert.ToDecimal(0);
                SqlCeCommand insCe = new SqlCeCommand("INSERT INTO GOODS VALUES ( "
                    + @id + ", " +"'" + @FullName + "'"+ ", " + @MacroId + ", " + @ProdId + ", " + @Art3Id + ", " +
                "'" + @Ed + "'" + " )" , destCon);                
                textBox1.Text = Convert.ToString(insCe);
                insCe.ExecuteNonQuery();
                storeDataSet.EnforceConstraints = true;
                storeDataSet.Goods.Rows.Add(row);
                storeDataSet.AcceptChanges();
            }
            SourceCon.Close();
            destCon.Close();