***This version is an outdated version of my script which has some display errors with IE. Please take a look at asp with flexigrid V2.***
I came across a pretty nifty script called Flexigrid. Basically it allows you to take information from a database using JSON or XML and display it on a pretty nifty grid with search, pagination, sorting and some other cool features.
Anyway, all of the examples use PHP to generate the XML or JSON so I decided to do it in ASP using a microsoft access database. You can view a demo of what I made here and download all the files (including the test db) here.
You can also visit the flexigrid website here.

















Thanks for this :-)
Hi, thank so much for this code! Well, I tried to run this code at my machine ( I didn’t changed nothing, just unzipped and run) and it isn’t run om my IE only om my Firefox. Can you please help me?
Sorry, I forgot to say: my IE is version 6. And the problem is that this code show the total number of records (50000), displaying 1 to 15 but dosen’t show the records inside the table. Thank you!
I tried to do some tests and I found this: when the sortname is id the IE give an error message (id is null or not a object) and when and change to other value like firstname or lastname the page freeze and I need close the IE. The page stay at http://www.robertomiguez.com.br/flexgrid/default.asp
Sorry about that Roberto. The problem is to do with the json code that is generated. I’ve fixed it but haven’t had a chance to upload the changes. I’ll get the new stuff online today for you.
James’s last blog post..Diversifying My Blog
You are great! I really need this working. Please if have a chance please send the modification by e-mail to me (robertocsmiguez@gmail.com). Thank you so much!
Ok, I found the error and now is correct. Is juts about the comma at the end of the JSON file. Thank you for your help.
How dow i get this to work for asp.net
I’m pretty much a novice with asp.net so I wouldn’t really be able to do something like this.
If somebody has created something like this for asp.net let me know and I’ll be happy to add it to the site.
James’s last blog post..Essential Reads #1 - SmashingMagazine
Hi,
Thank you for providing the ASP version of the FlexiGrid. I just have a problem on using the Quick Search feature. How do I have to call the Search function?
Thanks
What is the problem you’re having? As long as you have the correct fields listed in the javascript it should just work.
Also just a quick note to remind people that this was V1 of the script, there are some errors with IE6 not displaying data.
V2 has these errors fixed: http://jamesowers.co.uk/asp-tutorials/63/flexigrid-with-asp-version-2/
James’s last blog post..CSS Fonts
hi,thanks u ,for u demo.but i have a problem.
how i can add a url in cell,such as “this grid is prowerful grid”.it will be title,then ,i click this title, it will skip new page.show detailed information of this title.
thanks again
Thank you for your code source. I help me for my job. It’s faboulous for me.
Sorry for my poor english. I’m french.
a++
Hello,
In my flexigrid, I’ve some checkboxes. I want to create a chexkbox who select all, and put them in my database.
Thanks for your help
andré