Flexigrid with asp (version 2)

April 25th, 2008 in ASP tutorials. 29 Comments

After some users reported problems using my flexigrid with asp and IE I decided to redo some of the code to fix it.

Basically the problem was that when the JSON code generated it is supposed to add a comma (,) to the end of every line apart from the last one. My code put a comma at the end of every line including the last one. Firefox realises this and fixes the problem while IE just dies and wont show the content. All I did was added a quick if statement to the end of the line that checks to see if it’s the last record retrieved from the database or not and sticks the comma on the end if it has to.

Flexigrid with ASP

I’ve also been working with flexigrid at work as part of an application I’m making which populates the flexigrid with data users have entered using online forms and PDAs. This presented the problem that people dont always enter alpha numeric characters and flexigrid doesn’t seem to like this so I added a function called cleanup that will remove all non alpha numeric characters from your data before it kills flexigrid. This is also included in the new distro. And as a side note, I have had flexigrid working with 3500 records from a Sybase database a work without any problems.

Update

The flexigrid site has now moved to here. If you have any questions to do with the javascript or flexigrid functionality then ask there. If it is a problem with the ASP then you can ask on this site.

I don’t have a demo of the ASP version online at the minute due to me not having any ASP hosting any more, I’ll do my best to find somewhere to get it online. If you would like to host the demo please get in touch with me.

Demo

Hasan from hasankoroglu.com kindly offered to host the demo for the Flexigrid with ASP on his server since I don’t have an ASP server any more. You can check out the demo of the Flexigrid with ASP on Hasan’s website by clicking here.

Download

You can download the latest version of ASP Flexigrid here.

Bookmark

29 Comments

Jose

September 5, 2008 at 5:10 am

Thx a lot for the samples… it has been very useful, so, thanks for share it.
Just a question, is there any way of doing a colum data with hyperlink?
Sorry, but I haven’t found it neither flexigrid documentation not in json.

Thanks in advance

Jose

September 5, 2008 at 6:36 am

Sorry, I’ve found it…

http://codeigniter.com/forums/viewreply/380339/

Thx anyway

Konstantinos

September 20, 2008 at 7:19 pm

Hello.
Thank you for your great work.
Just a quick question. I am using response.charset=iso-8859-7 (for greek language)
and eventhough the greek letters appear correctly the grid does not display any results when i use search. I tried to see if the javascript was taking the value in another charset but using alerts i found that the value it searches stays the same in greek. However no results appear. can you help me ? thnx again!

Konstantinos

September 21, 2008 at 6:06 pm

i found it…
it was an encoding issue in jquery.js
Solved it :)

BSanders

October 7, 2008 at 2:25 pm

The link to your demo page is invalid. Would you please correct the link? When I download the samples, it works fine except for “rows per page” – when you sort on a column, the rows per page setting is ignored.

foobar

November 7, 2008 at 3:34 pm

Hi James,

would you be kind enough to provide a link to see the demo.

Many thanks

Ruru

November 20, 2008 at 2:20 am

Hello James,
Your ajax grid demo link broke!!?

James

November 20, 2008 at 8:19 am

Ok guys. The demo is working again now.

David

December 2, 2008 at 6:38 pm

Great example. Do you happen to have a asp.net c# example or know a site that might?

Lakes

January 31, 2009 at 9:25 am

James,

Was very excited to find your blog about Flexigrid V2. Exactly what I need. The links don’t seem to be working for the demo or the download.

Are they still available or can you send me the proper links?

Much appreciated!!

James

February 2, 2009 at 5:14 am

Hi, If you try and download the file again it should work.

I’ll have to find a new place to host the demo because I dont have asp hosting any more.

Jamess last blog post..Automatically published articles with WordPress

Peter

February 2, 2009 at 2:02 pm

Hi James
Do have some example code using Flexigrid with asp.net and json. I will need to update the grid periodically probably from an ashx page.

Thanks

Peter

February 2, 2009 at 2:23 pm

Sorry I forgot to mention I’m using C#

Lakes

February 5, 2009 at 12:12 am

James,

Tried the link again – Thanks!

Had to DL it on a Windows machine since it was a .RAR file. Looking forward to working with it.

Thanks again!!!

Jiri

February 17, 2009 at 1:02 pm

Hi, I tried to see your demo page but that link doesn’t work again. And http://codeigniter.com/forums/viewreply/380339/ doesn’t work too.

Thanks

Andy H

February 18, 2009 at 11:53 am

So far I’ve found two different links that state this grid works, but each one goes to a bad URL. Anyone know of a site that works for ASP?

rwg

March 13, 2009 at 12:46 pm

Thank you for your code!!!!

March 13, 2009 at 10:00 pm

Hi and thanks you for your code.
I would like add a “window.location” on a double click on a row.
Can you help me ?
thanks a lot

Peter

March 20, 2009 at 2:13 pm

Has anyone gotten Flexigrid to work with asp.net. When I try using it with asp.net the page just keeps saying processing please wait and nothing happens.