[android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
On Sep 14, 8:49 am, Bishan tvbis...@gmail.com wrote: 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 ?  Client.xml 18KViewDownload See

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
thanx skink. i'll try this. :) On Wed, Sep 14, 2011 at 12:33 PM, skink psk...@gmail.com wrote: On Sep 14, 8:49 am, Bishan tvbis...@gmail.com wrote: 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

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
any other answers ? On 9/14/11, Bishan tvbis...@gmail.com wrote: thanx skink. i'll try this. :) On Wed, Sep 14, 2011 at 12:33 PM, skink psk...@gmail.com wrote: On Sep 14, 8:49 am, Bishan tvbis...@gmail.com wrote: i have a xml file.(pls see attachement). and i need insert data in my xml

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
On Sep 14, 9:31 am, Bishan tvbis...@gmail.com wrote: any other answers ? On 9/14/11, Bishan tvbis...@gmail.com wrote: thanx skink. i'll try this. :) On Wed, Sep 14, 2011 at 12:33 PM, skink psk...@gmail.com wrote: On Sep 14, 8:49 am, Bishan tvbis...@gmail.com wrote: i have a xml

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
k. i got it skink. i know how to read XML. but the problem is how could i insert the data in XML to the my sqlite database table after reading the XML. that's the point whats wrong with me. On 9/14/11, skink psk...@gmail.com wrote: On Sep 14, 9:31 am, Bishan tvbis...@gmail.com wrote: any

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
Bishan wrote: k. i got it skink. i know how to read XML. but the problem is how could i insert the data in XML to the my sqlite database table after reading the XML. that's the point whats wrong with me. On 9/14/11, skink psk...@gmail.com wrote: On Sep 14, 9:31 am, Bishan

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
Bishan wrote: k. i got it skink. i know how to read XML. but the problem is how could i insert the data in XML to the my sqlite database table after reading the XML. that's the point whats wrong with me. On 9/14/11, skink psk...@gmail.com wrote: On Sep 14, 9:31 am, Bishan

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Monzurul Islam Shamim
Bishan, you can google 'android sqlite example'...you'll get many working example codesmight help you. Thanks. -Shamim On Wed, Sep 14, 2011 at 3:03 PM, skink psk...@gmail.com wrote: Bishan wrote: k. i got it skink. i know how to read XML. but the problem is how could i insert

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
currently i'm reading XML file and put data into a Vector Object. but i don't know how could i insert the data in that Vector Object into sqlite database. this is the point where i stuck. On 9/14/11, skink psk...@gmail.com wrote: Bishan wrote: k. i got it skink. i know how to read XML. but

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
thanx Shamim :) On 9/14/11, Bishan tvbis...@gmail.com wrote: currently i'm reading XML file and put data into a Vector Object. but i don't know how could i insert the data in that Vector Object into sqlite database. this is the point where i stuck. On 9/14/11, skink psk...@gmail.com wrote:

[android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
On Sep 14, 11:29 am, Bishan tvbis...@gmail.com wrote: currently i'm reading XML file and put data into a Vector Object. but i don't know how could i insert the data in that Vector Object into sqlite database. this is the point where i stuck. On 9/14/11, skink psk...@gmail.com wrote:

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
VectorEgCommon vClient = new VectorEgCommon(); for (int temp = 0; temp getNodes().getLength(); temp++) { Node nNode = getNodes().item(temp); if (nNode.getNodeType() == Node.ELEMENT_NODE) {

[android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
On Sep 14, 12:15 pm, Bishan tvbis...@gmail.com wrote:                 VectorEgCommon vClient = new VectorEgCommon();                 for (int temp = 0; temp getNodes().getLength(); temp++) {                         Node nNode = getNodes().item(temp);                         if

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
SQLiteDatabase db = openOrCreateDatabase(TestDB, MODE_PRIVATE, null); db.execSQL(CREATE TABLE IF NOT EXISTS Client (clientID INT, + clientName VARCHAR, + routeName VARCHAR, +

[android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread skink
On Sep 14, 1:07 pm, Bishan tvbis...@gmail.com wrote:                 SQLiteDatabase db = openOrCreateDatabase(TestDB, MODE_PRIVATE, null);                 db.execSQL(CREATE TABLE IF NOT EXISTS Client (clientID INT, +                                 clientName VARCHAR, +                

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Cristhian Flores
Hi Bishan I hope is helpful private var sqlc:SQLConnection = new SQLConnection(); // sqlc is an SQLStatment which we need to execute our sql commands private var sqls:SQLStatement = new SQLStatement(); // ArrayCollection used as a data provider for the datagrid. It has to be bindable so that

Re: [android-developers] Re: XML files and SQLITE Database

2011-09-14 Thread Bishan
thanx Cristhian. i'll check this. On 9/15/11, Cristhian Flores cif...@gmail.com wrote: Hi Bishan I hope is helpful private var sqlc:SQLConnection = new SQLConnection(); // sqlc is an SQLStatment which we need to execute our sql commands private var sqls:SQLStatement = new SQLStatement();