Guriddo » Topic: How to convert search string to where clause in asp .net mvc

How to convert search string to where clause in asp .net mvc

Guriddo
How to convert search string to where clause in asp .net mvc

This topic has 6 replies, 2 voices, and was last updated 15 years ago by OlegK.

Creator

Topic
May 15, 2011 at 9:51 am #78376

kobruleht
Participant

jqGrid passes search string

1
Creator

Topic

Viewing 6 replies - 1 through 6 (of 6 total)

Author

Replies
May 15, 2011 at 12:30 pm #97993

OlegK
Participant

If you would use Entity Framework to access to the database the code will be relatively easy. Look at the “UPDATED” part of the answer

May 15, 2011 at 3:32 pm #97995

kobruleht
Participant

Thank you. Great sample.

Erorr handler used in this code fails if inline editing

May 15, 2011 at 9:19 pm #97999

OlegK
Participant

I posted you the link to example which has no editing. It get only data from the server. If you use some kind of editing you should of course implement additional event handlers or in case of inline editing use errorfunc additional parameters of editRow. Look at the answer or another one for example.

Best regards
Oleg

May 15, 2011 at 11:59 pm #98001

kobruleht
Participant

Thank you. In case or error my appli returns 4xx http error code.

Same issue is described in

/blog/?page_id=393&forum=1&topic=5672&watch=user
/blog/?page_id=393/help/ajax-validation-while-saving-an-inline-edit/

https://github.com/tonytomov/jqGrid/blob/master/js/grid.inlinedit.js

show two different names:

line 23 and 103

May 16, 2011 at 10:41 am #98005

kobruleht
Participant

I also noticed anoter message in this form which wrote that Enter key is unbinded too early. How to fix this so that Enter/Esc are unbinded only if save was successfull ?

Your Filter class uses switch for every type. Maybe it is possible to use Convert.ChangeType instead of this to remove this switch as described in

http://www.codeproject.com/KB/aspnet/AspNetMVCandJqGrid.aspx?msg=3586944#xx3586944xx

May 16, 2011 at 11:01 am #98007

OlegK
Participant

Sorry, but I have now too few time. So if you found an error you should post the bug report in the Bugs part of the forum.

By the way Tony is the developer of jqGrid not me. I use jqGrid in some of my projects and I help other (mostly on the stackoverflow.com) who use jqGrid, but it is only hobby for me.

Best regards
Oleg
Author

Replies