Forum
Log In
Home
Topic RSS
09:29
02/10/2009
Offline
Hi! I have 2 tables - Items and ItemsCategory. I want to edit Items table with jQgrid. In each row(through add or edit action) i must select category for each item from dropdown list. In all examples Tony(thanks for creating this magic tool:)) fill the dropdown list("select") element from string - like "FE:FedEx;IN:InTime;TN:TNT;AR:ARAMEX".
Here the question: what easy way to fill them from database?
Thank's, sorry for bad eng
01:50
Moderators
08/10/2009
Offline
Nothing that is built-in the grid to dynamically retrieve that from database, since this is a pure client-side side utility. The only (and as far as I can tell, the best) way to do it is to first featch the data from database and then when constructing the jQuery init statement from jqGrid to include it as a server variable, e.g. write it directly from server.
In ASP.NET that woud be
jQuery("#jqGridId").jqGrid ...
..
<%= DropDownValues.ToString() %>
...
where DropDownValues are calculated on the server.
Trirand ASP.NET WebForms & MVC components based on jQuery & ThemeRoller
12:06
02/10/2009
Offline
Even if datatype of my jQgrid instance is 'JSON'?
Most Users Ever Online: 994
Currently Online:
41 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
OlegK: 1255
markw65: 179
kobruleht: 144
phicarre: 132
YamilBracho: 124
Renso: 118
Member Stats:
Guest Posters: 447
Members: 11373
Moderators: 2
Admins: 1
Forum Stats:
Groups: 1
Forums: 8
Topics: 10592
Posts: 31289
Newest Members:
, razia, Prankie, psky, praveen neelam, greg.valainis@pa-tech.comModerators: tony: 7721, Rumen[Trirand]: 81
Administrators: admin: 66
