SQL Server 2005 Mobile edition import from XML

[King Abadon]

i have this XML

<?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?

[King Abadon]

nonone knows or it can't be done?

[King Abadon]

pls,i need some help

[axion_sa]

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.

[King Abadon]

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();
}
}
}