Hi can anyone please tell me how to save contents of a datagrid into an sql lite database. for clarity assume that the datagrid has three columns with the following data
column one header="book name" content = " titles of books"
column two header=" book description" content=" description of the books"
column three header="listPrice" content=" prices of the listed books"
The datagrid gets it content from an XML file with the following structure
What i want is when a user clicks on a button, it executes a function that saves the datagrid content into the sqllite browser with the following structure
bookID index primary key auto incriment
Any help will be kindly appreciated. thanks!
If you want to save all rows of the DataGrid just parse the dataProvider and formulate SQL INSERT statements as necessary.
Here is how to package data as JSON and send it to MySql via PHP.
If this post answers your question or helps, please mark it as such.
Greg Lafrance - Flex 2 and 3 ACE certified
Flex / AIR Development, Training, and Support Services
Sorry for the loooooooooooooong delay in replying.
I was interested in your first statement where you have mentioned "If you want to save all rows of the DataGrid just parse the dataProvider and formulate SQL INSERT statements as necessary."
I am really not an expert in flex/actionscript so a bit of code to demonstrate what you have mentioned in your statement will be much appreciated. I forgot to add that i have basic knowledge of coldfusion and No experience in PHP so i cant really understand the php demo's you have linked. Please just give me a coded example in relation to the above statement i have quoted