Wednesday, August 1, 2012

JQuery Table Column Values


The values in a specific Column of a Table can be obtained using the following jQuery script.

 $(
"#tblEmployee tr td:nth-child(n)").each(function() {
      alert($(
this).text());
 });



Example
Change the mapping of the jQuery file jquery-1.7.2.js and style sheet file Stylesheet.css to map to your local drive.

<html xmlns="http://www.w3.org/1999/xhtml" >
<
head><title>
      jQuery Table
</title>
<
script type="text/javascript"
src="JavaScript/jquery-1.7.2.js"></script>
<
link type="text/css"
href="Stylesheet.css"
rel="Stylesheet" />
<script type="text/javascript">
$(document).ready(function() {
// Add Table Style
$("#tblEmployee").addClass("Table");
//
// Add Table Cell Style
$("#tblEmployee td").addClass("TableCell");
//
// Add Header Style
$("#tblEmployee th").addClass("TableHeader");
//
      // Add Row Style
      $("#tblEmployee tr").addClass("TableRow");         
      //
      // Loop Through a Specific Column (Names)
      // Column index starts with 1
      $('#cmdGetNames').click(function(event) {
         event.preventDefault();
         $("#tblEmployee tr td:nth-child(2)").each(function() {
            alert($(this).text());
         });
       });

</script>    
</head>
<body>
<table
        cellspacing="0"
        rules="all"
        border="1"
        id="tblEmployee"
        style="border-collapse:collapse;">
      <tr>
            <th scope="col">ID</th>
<th scope="col">Name</th>
<th scope="col">DOB</th>
<th scope="col">Email</th>
      </tr>
<tr>                         
             <td>237</td>
             <
td>John</td>
             <
td>05/04/1981</td>
             <
td>john@abcsoftware.com</td>
</tr>
<
tr>       
       <td>238</td>
       <
td>Tom</td>
       <
td>11/11/1967</td>
       <
td>tom@abcsoftware.com</td>
      </tr>
<tr>         
             <td>239</td>
       <td>Harry</td>
             <
td>10/07/1973</td>
             <
td>harry@abcsoftware.com</td>
      </tr>
<tr>             
             <td>240</td>
             <
td>Peter</td>
             <
td>01/01/1981</td>
             <
td>peter@abcsoftware.com</td>
</tr>
<
tr>
<td>241</td>
<
td>John</td>
<
td>05/04/1981</td>
<
td>john@abcsoftware.com</td>
      </tr>
</table>
<input type="submit" name="cmdGetNames" value="Get Names" id="cmdGetNames "/>
 

</body>
</html>

Add your Table (or) add server side code to populate the Table with data.

Stylesheet.css

.Table
{
      border: 1px solid #000000;
}
.TableCell
{
    padding: 3px 3px 3px 3px; /* Cellpadding */
    border: 1px solid #000000;
    font-family:Verdana;
    font-size:10pt;   
}
.TableCellEven
{
    padding: 3px 3px 3px 3px;
    border: 1px solid #000000;
    background-color:#ffffcc;
    font-family:Verdana;
    font-size:10pt;    
}
.TableCellOdd
{
    padding: 3px 3px 3px 3px;
    border: 1px solid #000000;
    background-color:#fedcba;
    font-family:Verdana;
    font-size:10pt; 
}
.TableHeader
{
      background-color:#999966;
}
.TableRow
{
    background-color:#ffffcc;
}
.TableRowEven
{
    background-color:#ffffcc;
}
.TableRowOdd
{
    background-color:#FEDCBA;
}
.TableRowHover
{
    background-color:#CCCCCC;
}
.TableRowSelected
{
    background-color:#CC99FF;
}
Related Post
JQuery Table Style
JQuery Table Header Style
JQuery Table Selected Row Values
JQuery Table Selected Row Index
JQuery Table Row Click Event
JQuery Table Row Selected
JQuery Table Column Values
JQuery Table Row Values
JQuery Table Column Count
JQuery Table Row Count
JQuery Table Hover Effect
JQuery Table Alternating Column Style
JQuery Table Alternating Row Style
JQuery Table Row Style
jQuery Table Tutorial
jQuery Table Filter Autocomplete Style
jQuery Table Search Client Side



Search Flipkart Products:
Flipkart.com

No comments: