Flexigrid with asp

***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.


This entry was posted on April 07th, 2008 and is filed under ASP tutorials. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response or Trackback from your own site.

 
« Diversifying My Blog
Looking for link exchanges »
 
 

18 Responses to “Flexigrid with asp”

  1. Tree
    15. April 2008 at 10:01

    Thanks for this :-)

  2. Roberto
    25. April 2008 at 02:08

    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?

  3. Roberto
    25. April 2008 at 02:10

    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!

  4. Roberto
    25. April 2008 at 02:40

    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

  5. James
    25. April 2008 at 03:01

    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

  6. Roberto
    25. April 2008 at 03:39

    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!

  7. Roberto
    25. April 2008 at 05:12

    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.

  8. Idowu
    21. May 2008 at 08:37

    How dow i get this to work for asp.net

  9. James
    22. May 2008 at 03:16

    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

  10. Nimrod
    2. June 2008 at 03:13

    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

  11. James
    2. June 2008 at 03:18

    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

  12. wzhyu
    14. June 2008 at 01:21

    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

  13. André
    1. August 2008 at 09:49

    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++

  14. André
    4. August 2008 at 08:34

    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é

  15. Londinium News » Blog Archive » Flexigrid - Lightweight but rich data grid
    10. October 2008 at 06:23

    [...] ASP example by Synergiq: http://jamesowers.co.uk/asp-tutorials/57/flexigrid-with-asp/ [...]

  16. Abc
    18. November 2008 at 01:18

    hi my problem is whenever i try to display more than 250 records using flexigrid, script crashes or it dosen’t show the records inside the table.

  17. Ruru
    20. November 2008 at 02:18

    Thank you for your work. Such a nice script, Such a nice ajax grid.

  18. Coco
    11. March 2009 at 17:42

    Hi, I’m new to the Flexigrid. I’ve a question on how to capture the table toggle button. With this feature, I can show/hide the table. If I hide the table, I want to adjust other UI’s height. Is there a way I can capture the event?

    Thanks,
    Coco

Leave a Reply