Here's one more for XML integration, but this time using more components offered in Flash CS3.  This article will focus on the how easy Flash components integrate with XML.  This way uses ActionScript 3.0 and not a XML data connector. This way is for implementing a need for searchable items where internet access is not desired or implied.

First we should plan out how this will integrate.

Why MSAccess? Why not some other relational database management system (RDBMS) such as MySQL? 

• Usability:  It's easy for the client to keep track of information in a database tool they're familiar with.  In this case, it's Microsoft Access.
• Domain:  This application is for use on a distrubuted CD/DVD that will enable the user to search through data efficiently.  Since most RDBMS require a server and/or internet access, this pseudo-database will just run from flash and filter an XML file.

Since MSAccess can export external data as XML, ActionScript can read that file and place it in the datagrid. 

Sorry, if you're reading this article thinking, "How can flash read a MS Access database?"  I have one answer. Maybe VB is your answer or maybe even Silverlight.  Flash does not read MSAccess databases unless there exists some JDBC/ODBC driver to read.  But why do that when MS Access exports XML that flash can read?  Anyways, on to the application!

Comments

Add New Search

Datagrid Houndawg (67.49.2.xxx) 2009-01-12 18:51:52 Great Job. This is exactly what I was looking for. I hope it works for me like it does in the example. Question: How would you go about adding a image and/or a movie to this example. Reply | Quote 3   0

CellRenderer drooza (SAdministrator) 2009-01-17 22:18:47 Use CellRenderer http://www.sephiroth.it/tutorials/flashPHP/cell... Reply | Quote 0   0

Errerem carnt read Anonymous (82.42.145.xxx) 2009-02-05 08:28:30 this is just what I want but i carnt read how to do kt because am a starter in the flash 8 fingy Reply | Quote 2   0

dynamic grid... renzo (125.163.76.xxx) 2009-03-15 01:35:32 does anyone know how to edit the value at grid... Reply | Quote 0   0

how to play video when cell is clicked? Jason (86.29.128.xxx) 2009-05-02 22:15:43 how would you make a video play in flash when a cell is clicked in the datagrid? im guessing a function but would you know the exact code and where it gets placed in the AS?? thanks Reply | Quote 0   0

Anonymous (82.75.150.xxx) 2009-06-16 07:19:54 Is there a way to work with several xml- files; here for instance one for cars, one for truck, one for motorbikes. Depending on what the visitor is looking for, the data inside the xml-files in question should be read into the datagrid and the queries set for All. The visitor can 'jump' between each of the sections (eg by using a combobox and the grid gets filled up with the new data from the other xml-file immediately. I realy would like to have seperate xml-files for each of the needs of the visitor... Thank you very much in advance Reply | Quote 1   0

change data provider drooza (SAdministrator) 2009-06-18 19:24:09 What you can do is just change the dataprovider of the datagrid to another xml file. check out how it's filtered. since the dataprovider is changed to an array for filtering, you can just filter a different dataprovider. Reply | Quote 0   0

atul singh (61.16.244.xxx) 2009-07-02 00:09:56 very nice thanks for lot of work Regards Atul singh Reply | Quote 0   0

Anonymous (74.103.209.xxx) 2010-02-05 01:46:17 Nicely done. I am trying to figure how can I insert URL and get it to work. Reply | Quote 0   0

Question James (95.17.50.xxx) 2010-03-14 07:57:02 Really top notch tutorial, congratulations. I'm trying to take it a bit further but I need a bit of help. How can I use the filter to load a corresponding image into a UIloader - I think the problem I'm having is that logically the image can only appear when the user has filtered down to only one unique result in the data grid, but I can't see what the value of the result would be in action script, or what to set an event listener for. then I suppose it is a simple question of: -loader.source=that value+".png" If you don't think this is the way please tell me what you think Thanks in advance and keep up the good work - we need you! Reply | Quote 0   0

Gosia (84.203.225.xxx) 2010-08-24 04:00:47 Great job!!! Reply | Quote 0   0

Write comment
Name:
Email:	do not notifynotify
Title:
UBBCode:	-color-aquablackbluefuchsiagraygreenlimemaroonnavyolivepurpleredsilvertealwhiteyellow -size-tinysmallmediumlargehuge
Please input the anti-spam code that you can read in the image.

Powered by !JoomlaComment 3.26

3.26 Copyright (C) 2008 Compojoom.com / Copyright (C) 2007 Alain Georgette / Copyright (C) 2006 Frantisek Hliva. All rights reserved."