i have a xml file.(pls see attachement). and i need insert data in my
xml file to a sqlite database in my android project.
hw can i do this ?
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers+unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
<?xml version="1.0" encoding="UTF-8"?>
<clientDetails xmlns:xs="http://www.w3.org/2001/XMLSchema"; xmlns:es="http://www.elephantgreen.com/Interface";>
<client>
<clientID>1072</clientID>
<clientName>LASANTHA STORES</clientName>
<routeName>R1</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>1000</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>4</creditPeriodDays>
<streetNumber>1</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments>test</comments>
<active>Y</active>
</client>
<client>
<clientID>1073</clientID>
<clientName>GAYATHRI STORES</clientName>
<routeName>R1</routeName>
<visitingFrequency>4</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>4</creditPeriodDays>
<streetNumber>2</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1074</clientID>
<clientName>MITHUL'S </clientName>
<routeName>R1</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>4</creditPeriodDays>
<streetNumber>3</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1075</clientID>
<clientName>CHAMI</clientName>
<routeName>R1</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>5000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>4</creditPeriodDays>
<streetNumber>4</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1076</clientID>
<clientName>NILU</clientName>
<routeName>R1</routeName>
<visitingFrequency>7</visitingFrequency>
<creditLimit>20000</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>GOLD</shopGrade>
<creditPeriodDays>7</creditPeriodDays>
<streetNumber>5</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1077</clientID>
<clientName>CHAMITHU</clientName>
<routeName>R1</routeName>
<visitingFrequency>1</visitingFrequency>
<creditLimit>14000</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>GOLD</shopGrade>
<creditPeriodDays>1</creditPeriodDays>
<streetNumber>6</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1078</clientID>
<clientName>AMAYA</clientName>
<routeName>R2</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>12000</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>GOLD</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>2</streetNumber>
<streetName>ATHURUGIRIYA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1079</clientID>
<clientName>COOL ZONE</clientName>
<routeName>R2</routeName>
<visitingFrequency>14</visitingFrequency>
<creditLimit>4000</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>14</creditPeriodDays>
<streetNumber>5</streetNumber>
<streetName>ATHURUGIRIYA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1080</clientID>
<clientName>BON BON </clientName>
<routeName>R2</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>3000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>7</streetNumber>
<streetName>ATHURUGIRIYA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1081</clientID>
<clientName>PANORAMA</clientName>
<routeName>R3</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>1</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1082</clientID>
<clientName>NALINDA</clientName>
<routeName>R3</routeName>
<visitingFrequency>5</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>1</creditPeriodDays>
<streetNumber>2</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1083</clientID>
<clientName>UPUL</clientName>
<routeName>R3</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>7</creditPeriodDays>
<streetNumber>3</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1084</clientID>
<clientName>DILINI</clientName>
<routeName>R3</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>3000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>4</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1085</clientID>
<clientName>BUZZ BUN</clientName>
<routeName>R3</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>3000</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>7</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1086</clientID>
<clientName>V</clientName>
<routeName>R3</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>3000</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>8</streetNumber>
<streetName>MALABE ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1087</clientID>
<clientName>VENUS</clientName>
<routeName>R5</routeName>
<visitingFrequency>4</visitingFrequency>
<creditLimit>5000</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>5</creditPeriodDays>
<streetNumber>1</streetNumber>
<streetName>KOTTAW ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1088</clientID>
<clientName>POL ATHU BATH KADE</clientName>
<routeName>R5</routeName>
<visitingFrequency>1</visitingFrequency>
<creditLimit>1000</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>2</creditPeriodDays>
<streetNumber>4</streetNumber>
<streetName>KOTTAW ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1089</clientID>
<clientName>POL KADE</clientName>
<routeName>R5</routeName>
<visitingFrequency>1</visitingFrequency>
<creditLimit>2400</creditLimit>
<outletType>RESTAURANT</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>1</creditPeriodDays>
<streetNumber>6</streetNumber>
<streetName>KOTTAW ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1090</clientID>
<clientName>CO OP CITY</clientName>
<routeName>R6</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>2500</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>1</creditPeriodDays>
<streetNumber>7</streetNumber>
<streetName>PILIYANADALA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1091</clientID>
<clientName>NT TRADE</clientName>
<routeName>R6</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>4</creditPeriodDays>
<streetNumber>67</streetNumber>
<streetName>PILIYANADALA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1092</clientID>
<clientName>LASANTHA HOTEL</clientName>
<routeName>R7</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>5</creditPeriodDays>
<streetNumber>78</streetNumber>
<streetName>PILIYANADALA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1093</clientID>
<clientName>LASANTHA TRADERS</clientName>
<routeName>R1</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>5</creditPeriodDays>
<streetNumber>45</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>MAHARAGAMA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1094</clientID>
<clientName>LASANTHA PANNIPITIYA</clientName>
<routeName>R6</routeName>
<visitingFrequency>7</visitingFrequency>
<creditLimit>0</creditLimit>
<outletType>GROCERY</outletType>
<shopGrade>BRONZ</shopGrade>
<creditPeriodDays>7</creditPeriodDays>
<streetNumber>23</streetNumber>
<streetName>PILIYANADALA ROAD</streetName>
<city>KOTTAWA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1095</clientID>
<clientName>TRADE MARKS</clientName>
<routeName>R8</routeName>
<visitingFrequency>7</visitingFrequency>
<creditLimit>10000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>GOLD</shopGrade>
<creditPeriodDays>7</creditPeriodDays>
<streetNumber>34</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1103</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1096</clientID>
<clientName>GLEN</clientName>
<routeName>R8</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>5000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>3</creditPeriodDays>
<streetNumber>45</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1101</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1097</clientID>
<clientName>TARAGO</clientName>
<routeName>R8</routeName>
<visitingFrequency>3</visitingFrequency>
<creditLimit>5000</creditLimit>
<outletType>HOTEL</outletType>
<shopGrade>SILVER</shopGrade>
<creditPeriodDays>7</creditPeriodDays>
<streetNumber>56</streetNumber>
<streetName>HIGHL LEVEL ROAD</streetName>
<city>PANNIPITIYA</city>
<district>COLOMBO</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
<client>
<clientID>1111</clientID>
<clientName>Tets</clientName>
<routeName>Ga</routeName>
<visitingFrequency>2</visitingFrequency>
<creditLimit>10000</creditLimit>
<outletType></outletType>
<shopGrade>BRONZE</shopGrade>
<creditPeriodDays></creditPeriodDays>
<streetNumber></streetNumber>
<streetName></streetName>
<city></city>
<district>Galle</district>
<csrId>1102</csrId>
<comments></comments>
<active>Y</active>
</client>
</clientDetails>
