how do show blank row when there is no data

Question

0.00/5 (No votes)

See more:

i am working on rdlc report , i am using following code

C#

var SecBeat1 = _service.GetBeatBySector_Id(sectorId).Count();
         for (int i = 1; i <= SecBeat1; i++)
         {
             var bs = _service.GetAllBeatStatus().Where(x => x.Date == dt && x.Sector_Id == sectorId && x.Shift == 1).FirstOrDefault();
               if(bs!=null)
                 {
                     Employee emp = _service.GetEmployee(bs.Employee_Id);
                     Beat beat = beats.FirstOrDefault(x => x.Id == bs.Beat_Id && x.Sector_Id == sectorId);
                     dataset.Beat.Rows.Add(beat.Name,
                      emp.Name,
                      emp.Id,
                      emp.CellNo
                         // bs.HasWireless
                      );

                 }

                     else
                     {

                             dataset.Beat.Rows.Add("", "", "");


                     }

        }

there are a no of beats in the sector,i have show all all beats of the sector,then if employee are availbale against each beats then employee will be show up ,and if

Posted 11-Mar-15 21:58pm

Sajid227

Updated 12-Mar-15 19:44pm

v2

Add a Solution

Comments

Sinisa Hajnal 12-Mar-15 7:26am

And what happens instead? You don't get any rows?

Your else will cause an exception if ever bs is null because you're checking if bs!=null and in else it will be null and you're trying to use in foreach.

Sajid227 13-Mar-15 1:45am

i have update the code ,i just want that when all employee against all beats fill up ,then it will move to else statement,

Sinisa Hajnal 13-Mar-15 2:49am

Did you consider changing GetAllBeatStatus and GetEmployee so that one returns employeeId = 0 and the other returns some default empty employee when it gets zero as parameter? That way you wouldn't have to check anything, you'd just show whatever comes...and you would know that no employee safely returns empty value.

Sajid227 13-Mar-15 3:19am

yes, i want to show total row base on beats,there is emp available, then it show up otherwise blank row show up??is there any method ?

Sinisa Hajnal 13-Mar-15 3:39am

As I said, change GetEmployee method so that it returns blank employee (that is, name = "" etc) if some default id is passed (0?)

Sajid227 15-Mar-15 4:19am

is there any other eway to do this??

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)