SQL Server 2005 Mobile edition import from XML

i have this XML

HTML Code:

<?xml version="1.0"?> <Aparate> <Aparat Denumire="AF MARINCA SAECO 1P" NumarCitire="156" DataCitire="31.10.2007" ContorGeneralInitial="817" ContorGeneralFinal="" > <Pozitii> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> </Pozitii> </Aparat> <Aparat Denumire="LAVAZZA" NumarCitire="156" DataCitire="31.10.2007" ContorGeneralInitial="817" ContorGeneralFinal=""> <Pozitii> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea espresso" ContorInitial="817" ContorFinal=""/> <Pozitie Produs="Cafea cu lapte" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Cafea dubla" ContorInitial="317" ContorFinal=""/> <Pozitie Produs="Frape" ContorInitial="317" ContorFinal=""/> </Pozitii> </Aparat>

i want to import all data from this XML on SQL Server 2005 Mobile edition
i created a Database Aparat with 2 tables:
1. Aparat with fields:id,Denumire,NumarCitire,DataCitire,ContorGeneralInitial,ContorGeneralFinal
2.Paodaparat with fields:
id,id_aparat,Produs,ContorInitial,ContorFinal
can anyone help me with a function or procedure do import xml on Sql mobile?

Re: SQL Server 2005 Mobile edition import from XML

nonone knows or it can't be done?

Re: SQL Server 2005 Mobile edition import from XML

pls,i need some help

Re: SQL Server 2005 Mobile edition import from XML

I think you may find people will be more willing to post if you show that you are at least trying instead of expecting people to do the work for you... :)

So, using this search, I found this article.

Re: SQL Server 2005 Mobile edition import from XML

i did this friday
here's the code
XmlDbCommand command = new XmlDbCommand("select * from Aparat", conn);
XmlDbDataAdapter da = new XmlDbDataAdapter(command);
DataTable table = new DataTable("Aparate");
da.Fill(table);
SqlCeCommand cmd = Biblio.pCon.CreateCommand();
//iau prodapart
XmlDbCommand command1 = new XmlDbCommand("select * from Pozitie", conn);
XmlDbDataAdapter da1 = new XmlDbDataAdapter(command1);
DataTable table1 = new DataTable("Prodaparat");
da1.Fill(table1);
SqlCeCommand cmd1 = Biblio.pCon.CreateCommand();
foreach (DataRow row in table.Rows)
{
cmd.CommandText = "insert into Aparat(id,NumarCitire,Denumire,ContorGeneralInitial,ContorGeneralFinal) values (" + row["Id"].ToString() + ",'" + row["NumarCitire"].ToString() + "','" + row["Denumire"].ToString() + "','" + row["ContorGeneralInitial"].ToString() + "','" + row["ContorGeneralFinal"].ToString() + "')";
cmd.ExecuteNonQuery();
foreach (DataRow row1 in table1.Rows)
{
if (row1["id_aparat"].ToString() == row["Id"].ToString())
{
cmd1.CommandText = "insert into Prodaparat(id_aparat,ContorInitial,ContorFinal,Produs) Values(" + row1["id_aparat"].ToString() + ",'" + row1["ContorInitial"].ToString() + "','" + row1["ContorFinal"].ToString() + "','" + row1["Produs"].ToString() + "')";
cmd1.ExecuteNonQuery();
}
}
}