|
publicvoid Cargo_Tablaxx()
{
try
{
DataTable dtable = newDataTable();
DataTable dtable2 = newDataTable();
DataSet ds = newDataSet();
SqlCeConnection Cn = newSqlCeConnection();
Cn.ConnectionString = "Data Source =Archivos de programa\\Miprograma\\MiBase.SDF";
Cn.Open();
ds.ReadXml("Archivos de programa\\Miprograma\\tablas\\Tablax1.xml", XmlReadMode.Auto);
dtable = ds.Tables["Tablax1"];
Ca = "SELECT * FROM Tablaxx";
SqlCeDataAdapter Dadap = newSqlCeDataAdapter(Ca, Cn);
Dadap.Fill(ds, "Tablaxx");
dtable2 = ds.Tables["Tablaxx"];
for (int J = 0; J < dtable.Rows.Count; J++)
{
DataRow Dr = dtable.Rows[J];
dtable2.ImportRow(Dr);
}
SqlCeCommandBuilder Cb = newSqlCeCommandBuilder(Dadap);
Dadap.Update(dtable2);
Cn.Close();
}
catch (Exception e)
{
MessageBox.Show("Error en Tablaxx." + e.Message);
}
|