How to check the complete column is null or not using viewdata

Question

1.00/5 (1 vote)

See more:

Hi I have something like

ViewData["getServices"] = (from p in dbObj.gen_crm_consolidate
                                       where p.service_id == sID && p.pdate >= sDate.Date && p.pdate <= eDate.Date
                                       orderby p.pdate descending
                                       select p).ToList();
return PartialView("_ServicePartial", ViewData["getServices"]);

and in View i am using this as

var q = (List<DM.Models.DB.gen_crm_consolidate>)(ViewData["getServices"]);
                           foreach (var item in q)
                           {

It is working perfectly fine. I have almost 10-12 columns in ViewData and just i want to check weather complete column is empty or not and if it is empty i will not show it in view.

What I have tried:

I tried to access value of q from viewdata but nothing happens.

Posted 7-Feb-17 0:59am

Member 12583662

Updated 8-Feb-17 23:36pm

Add a Solution

Comments

Karthik_Mahalingam 7-Feb-17 7:53am

what is complete column ?
not clear, provide more info.

Member 12583662 8-Feb-17 5:36am

foreach (var item in q)
{

@Convert.ToString(string.Format("{0:dd/MM/yyyy}", @item.pdate))
@item.active_base
@item.charged_base
@item.total_calls
@item.total_mou
@item.daily_ivr_unique_user
@item.total_pulse
@item.actrevenue
@item.Rrevenue
@item.total_revenue

}

Member 12583662 8-Feb-17 5:38am

Action code is already given. and this is the view. View changes based on different services selected. For some active_base is null and for they have values. I want to check if entire column is null than it should not be seen on screen.

Karthik_Mahalingam 8-Feb-17 5:58am

entire colum or row ?

Member 12583662 8-Feb-17 6:58am

it will fetch and show date wise data from 1st to 30th. want to exclude if Entire column is null.

Karthik_Mahalingam 8-Feb-17 7:16am

entire row of one column?

Member 12583662 8-Feb-17 21:59pm

Yes all rows of one column like active_base. If it has no value in all dates it should be eliminated. or hidden.

Karthik_Mahalingam 8-Feb-17 22:59pm

are you displaying in a grid?
show a screenshot

Member 12583662 9-Feb-17 3:17am

I am using DataTable for this. Like below Calls column have all 0
Date base Base2 Calls
08-02-2017 2333 3 0
07-02-2017 2332 3 0
06-02-2017 2331 3 0
05-02-2017 2328 1 0
04-02-2017 2325 3 0
03-02-2017 2312 2 0
02-02-2017 2311 2 0
01-02-2017 2309 2 0
31-01-2017 2309 2 0
30-01-2017 2307 2 0

Karthik_Mahalingam 9-Feb-17 3:19am

c# datatable or jquery datatable ?

Member 12583662 9-Feb-17 4:53am

Jquery

Karthik_Mahalingam 9-Feb-17 5:04am

show your datatable code..

Karthik_Mahalingam 9-Feb-17 5:11am

are you using pagination?

Member 12583662 9-Feb-17 5:41am

yes

Member 12583662 9-Feb-17 5:42am

The main code is already mentioned here. For datatable i only used jquery class to apply datatable features. SO no special code in that part.

Karthik_Mahalingam 9-Feb-17 5:54am

check my below solution.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Karthik_Mahalingam · Accepted Answer · 2017-02-08T23:36:00

refer this example and build it.
Location and Age columns are empty and 0 values respectively.

HTML

<!DOCTYPE html>
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
   
    <link href="https://cdn.datatables.net/1.10.13/css/jquery.dataTables.min.css" rel="stylesheet" />
    <script src="jquery.js"></script>
    <script src="https://cdn.datatables.net/1.10.13/js/jquery.dataTables.min.js"></script>
    

    <script>
        var table;
        $(document).ready(function () {
             table = $('#example').DataTable({                
                "paging": false
             });
             var columnsCount = table.columns()[0].length;
             var data = table.rows().data();
             var columnIndexToHide = [];
             for (var j = 0; j < columnsCount; j++) {
                 
                 var icount = 0;
                 for (var i = 0; i < data.length; i++) {
                     var val = data[i][j];                      
                     if (val != '' && val != '0') // hide for empty and column having 0 value.
                         break;
                     else
                     {
                         icount++;
                         if (icount == data.length)
                         { columnIndexToHide.push(j); break;}                         
                     }
                     
                 }
             }
             for (var i = 0; i < columnIndexToHide.length; i++) {
                 table.column(columnIndexToHide[i]).visible(false)
             } 
        });
       
    </script> 
    </head>
<body>
    
     
    <table id="example" class="display" cellspacing="0" width="100%">
        <thead>
            <tr>
                <th>Name</th>
                <th>Position</th>
                <th>Location</th>
                <th>Age</th>
                <th>Start date</th>
                <th>Salary</th>
            </tr>
        </thead>
        
        <tbody>
            <tr>
                <td>Tiger Nixon</td>
                <td>System Architect</td>
                <td></td>
                <td>0</td>
                <td>2011/04/25</td>
                <td>$320,800</td>
            </tr>
            <tr>
                <td>Garrett Winters</td>
                <td>Accountant</td>
                <td></td>
                <td>0</td>
                <td>2011/07/25</td>
                <td>$170,750</td>
            </tr>
            <tr>
                <td>Ashton Cox</td>
                <td>Junior Technical Author</td>
                <td></td>
                <td>0</td>
                <td>2009/01/12</td>
                <td>$86,000</td>
            </tr>
            <tr>
                <td>Cedric Kelly</td>
                <td>Senior Javascript Developer</td>
                <td></td>
                <td>0</td>
                <td>2012/03/29</td>
                <td>$433,060</td>
            </tr>
            
        
        </tbody>
    </table>
    

</body> 
</html>