Display message when there is no data

Question

0.00/5 (No votes)

See more:

, +

I have webmethod and jquery for display chart in pop up for this .. so when i click on search button when there is data then working fine but when there is no data i want to display message "NO Data" in label .. and also pop must not display when there is no data how i do this ..

What I have tried:

check i try this code

C#

[WebMethod]
       public static string GetVo(DateTime fromdate, DateTime todate, string region)
       {

           string data2 = "[";
           try
           {
               T1 DB = new T1();
               var rea = (from vv in DB.tblVeh
                          join rv in DB.tblRen vv.MID equals rv.ID
                          join re in DB.tblRei on rv.RID equals re.RID
                          where
                          re.Region == region
                          && (vv.Name != "")
                          && re.StartDate >= fromdate
                          && re.EndDate <= todate
                          group vv by vv.Name into g
                          select new
                          {
                              Name = g.Key,
                              cnt = g.Select(t => t.Name).Count()
                          }).ToList();
     data2 += rea.ToList().Select(x => @"[""" + x.Name + @"""," + x.cnt + "]")
         .Aggregate((a, b) => a + "," + b);
               data2 += "]";

           }
           catch (Exception ex)
           {
               throw new Exception();
           }
           return data2;

       }

and jquery

JavaScript

<script type="text/javascript">
               var strarr = [["h", 9], ["t", 3], ["y", 1],["y (bunch)", 1]];
               $(function () {
                   $('[ID*=search_data]').on('click', function () {
                       var fromdate = $('[ID*=fromdate]').val();
                       var todate = $('[ID*=todate]').val();
                       var region = $('[ID*=regiondrop] option:selected')
                      [0].value;
                       var obj = {};
                       obj.fromdate = fromdate;
                       obj.todate = todate;
                       obj.region = region;
                       Getdata(obj);
                       return false;
                   });
               });
               function Getdata(obj) {
                   $.ajax({
                       type: "POST",
                       url: "WebForm1.aspx/GetVo",
                       data: JSON.stringify(obj),
                       contentType: "application/json; charset=utf-8",
                       dataType: "json",
                       async: true,
                       cache: false,
                       success: function (result) {
                           strarr = result.d;
                           var myarr = strarr;
                           Drewchart(myarr);
                       },
                       error: function (error) {
                           alert("error");
                           //$("#divcontainer").hide();
                       }
                   });
               }
               function Drewchart(result) {
                   console.log(JSON.stringify(result, null, 2));
                   $('#container').highcharts({
                       chart: {
                           type: 'pie',
                           options3d: {
                               enabled: true,
                               alpha: 45
                           }
                       },
                       title: {
                           text: 'Contents of Charts'
                       },
                       subtitle: {
                           text: '3D donut in Highcharts'
                       },
                       plotOptions: {
                           pie: {
                               innerSize: 100,
                               depth: 45
                           }
                       },
                       series: [{
                           name: 'Delivered amount',
                           data: JSON.parse(result)
                       }]

                   });
               }
    </script>

   <div id="divcontainer" style="display: none" align = "center">
         <div id="container"  class="cont_charts">

       </div>

and for pop up

JavaScript

<script type="text/javascript" >
        $(function () {
            $("#divcontainer").dialog({
                modal: true,
                autoOpen: false,
                title: "Chart",
                width: 600,
                height: 450
            });
            $("#search_data").click(function () {
                $("#divcontainer").dialog('open');

            });
        });
   </script>

Posted 20-Jul-16 22:22pm

super_user

Updated 20-Jul-16 22:29pm

Add a 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)

F-ES Sitecore · Accepted Answer · 2016-07-20T22:29:00

Solution 1

JavaScript

success: function (result) {
    var myData = JSON.parse(data.d);
    if (myData.length == 0)
    {
        // do something to show a message
        return;
    }
    strarr = result.d;
    var myarr = strarr;
    Drewchart(myarr); // here you could pass in myData and drop the JSON.parse in this method
},

for when there is no data in your action

C#

T1 DB = new T1();
               var rea = (from vv in DB.tblVeh
                          join rv in DB.tblRen vv.MID equals rv.ID
                          join re in DB.tblRei on rv.RID equals re.RID
                          where
                          re.Region == region
                          && (vv.Name != "")
                          && re.StartDate >= fromdate
                          && re.EndDate <= todate
                          group vv by vv.Name into g
                          select new
                          {
                              Name = g.Key,
                              cnt = g.Select(t => t.Name).Count()
                          }).ToList();
     if (rea.Any())
     {
         // rea is already a List, you don't have to keep using ToList
         data2 += rea.Select(x => @"[""" + x.Name + @"""," + x.cnt + "]")
         .Aggregate((a, b) => a + "," + b);
    }
    data2 += "]";

Posted 20-Jul-16 22:29pm

F-ES Sitecore

Updated 21-Jul-16 0:27am

v2

Comments

super_user 21-Jul-16 5:48am

when i try this this show this.. check please https://media.giphy.com/media/26gJznDimxRyV0zi8/giphy.gif

F-ES Sitecore 21-Jul-16 6:07am

That's an error in your .net code and nothing to do with your original question. If you're getting exceptions then post the relevant details as text, that animated gif is of no help at all.

super_user 21-Jul-16 6:10am

error is same "Sequence contains no elements" this means there is no data.. so how i handle this when there is no data then i want to show message no break the code

F-ES Sitecore 21-Jul-16 6:27am

I've updated my answer

super_user 21-Jul-16 6:46am

@F-ES Sitecore ok i try your answer.. i try this .. success: function (result) {
var myData = JSON.parse(result.d);
if (myData.length == 0 && myData!==null) {
$("#Label4").text('No data found')
return;
}
strarr = result.d;
var myarr = strarr;
Drewchart(myarr);
},
this show not any error but this also not show any message. e.g. No data found

F-ES Sitecore 21-Jul-16 6:49am

Use the debugger to see what is in result.d and what is in myData and go from there. Also you want to check for null before using the reference

if (myData!=null && myData.length == 0) {

super_user 21-Jul-16 6:56am

this is show now error .Uncaught TypeError: Cannot read property 'length' of undefined

F-ES Sitecore 21-Jul-16 8:02am

That shows what is coming back doesn't parse to an array. You need to use the debugger to see exactly what is coming back and write the code to handle that, there is no point coding "blind", putting random parsing etc without knowing the data you're getting. It could be you need eval rather than JSON.parse

var myData = eval(result.d);

I don't know as I don't know what your method is returning in various scenarios, look at the networking tab of your browser tools and use the "debugger" keyword in your scripts.

super_user 21-Jul-16 8:21am

have you check my recent comment?

super_user 21-Jul-16 8:21am

when i set debugger adn when i check f12 this show like that where there is no data..http://oi68.tinypic.com/2ic2t75.jpg and where there is data this show like this .. http://oi68.tinypic.com/2rxh2wx.jpg

F-ES Sitecore 21-Jul-16 8:31am

Not quite sure what's going on there, mydata is clearly an array from your debug output so .length should work fine.

super_user 22-Jul-16 1:58am

ok now this worked.. success: function (result) {

if(result !==null && result.length >0){
strarr = result.d;
var myarr = strarr;
$("#divcontainer").dialog('open');
Drewchart(myarr);
}
else{
$("#<%=Label4.ClientID%>").text('No data found')
$("#tabledata").hide();
$("#divcontainer").dialog('hide');
}
} ,

when i run this table is hide and message is show but pop is display where there is no data so how i hide pop up when i add line $("#divcontainer").dialog('hide'); this show error jquery.min.js:2 Uncaught Error: no such method 'hide' for dialog widget instance

super_user 21-Jul-16 7:18am

when i set debugger adn when i check f12 this show like that where there is no data..http://oi68.tinypic.com/2ic2t75.jpg and where there is data this show like this .. http://oi68.tinypic.com/2rxh2wx.jpg