Databases
StackOverflow2013
Postsdbo
PO
 

Note that there are some explanatory texts on larger screens.

plurals
  1. PO
    primarykey
    data
    text
    <p>You are right you are not the first person who ask the question. To clear the situation with the cell color I made <a href="http://www.ok-soft-gmbh.com/jqGrid/CellColor.htm" rel="noreferrer">the demo</a></p> <p><img src="https://i.stack.imgur.com/AHvnO.png" alt="enter image description here"></p> <p>for you which change the text color of the cell or the background color of the sell in different ways:</p> <pre><code>loadComplete: function() { // 2 is zero-base index of the column 'name' ('Client'). Every from the options // multiselect:true, rownumbers:true and subGrid:true will increase // the index by 1 because the option inserts additional columns $("#6 td:eq(2)", grid[0]).css({color:'red'}); grid.jqGrid('setCell',"12","name","",{color:'red'}); grid.jqGrid('setCell',"10",'name', '', 'my-highlight'); grid.jqGrid('setCell',"8",'name', '', 'ui-state-error ui-state-error-text'); grid.jqGrid('setCell',"4","name","",{'background-color':'yellow', 'background-image':'none'}); grid.jqGrid('setCell',"3","name","",'ui-state-highlight'); } </code></pre> <p>where</p> <pre><code>&lt;style type="text/css"&gt; .my-highlight { color: red; } &lt;/style&gt; </code></pre> <p>and "3", "4", "6", "8", "10" and "12" are th rowid of the rows where the color of the corresponding column will be changed.</p> <p>By the way my personal favorites are the ways using 'ui-state-highlight' or 'ui-state-error ui-state-error-text' classes which are the part of the <a href="http://jqueryui.com/docs/Theming/API" rel="noreferrer">jQuery UI Themes</a>.</p> <p><strong>UPDATED</strong>: To understand the difference of the usage of different methods in case of the usage of another jQuery UI Theme I added <a href="http://www.ok-soft-gmbh.com/jqGrid/CellColorLeFrog.htm" rel="noreferrer">one more demo</a> used La Frog Theme where the same table as above look like the following:</p> <p><img src="https://i.stack.imgur.com/PAGBQ.png" alt="enter image description here"></p>
    singulars
    1. This table or related slice is empty.
    1. POHow to change the color of jqGrid cell?
      singulars
      1. PTQuestion
    1. PTAnswer
    1. USOleg
    1. USOleg
    plurals
    1. This table or related slice is empty.
    1. This table or related slice is empty.
    1. POHow to change the color of jqGrid cell?
      singulars
      1. PTQuestion
    1. This table or related slice is empty.
    1. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTAcceptedByOriginator
    2. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    3. VO
      singulars
      1. PO
      1. This table or related slice is empty.
      1. VTUpMod
    1. COnice answer given by you!
      singulars
      1. PO
      1. USsanghavi7
    2. CO@ankit5607san: You are welcome! The current version of jqGrid support `cellattr` (see [the answer](http://stackoverflow.com/a/7408355/315935) and [this one](http://stackoverflow.com/a/12180842/315935)) which is more recommended as the usage of `setCell` inside of `loadComplete`.
      singulars
      1. PO
      1. USOleg
    3. CO@Oleg: This is fantastic. But, I want to change CSS for all cells of a column whose name and index I have.
      singulars
      1. PO
      1. USHardik Mishra
 

Querying!

 
Guidance
A row detail

Detail views are divided into sections. All the information in the data section comes from columns in the selected row. The other sections display data from other, related rows.

Related data can be related in a to-one or a to-many fashion. Captions of data related in a to-many fashion link to a list view showing a filtered view of the table.

Try moving around until you find a non-empty to-many entry and click on the label to get to one. You can move back to the root by clicking on the database name in the header.

SQuiL has stopped working due to an internal error.

If you are curious you may find further information in the browser console, which is accessible through the devtools (F12).

Reload