how do show blank row when there is no data

Sajid Hussain

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

 var SecBeat = _service.GetBeatBySector_Id(sectorId); 
            foreach (var Sb in SecBeat)          
   {                 dataset.SectorBeat.Rows.Add(Sb.Name);             }        
     var bs = _service.GetAllBeatStatus().Where(x => x.Date == dt && x.Sector_Id == sectorId && x.Shift == 1).ToList();    
                         if (bs != null)            
     {                     foreach (var bsec in bs)                  
   {                           Employee emp = _service.GetEmployee(bsec.Employee_Id);  
                       Beat beat = beats.FirstOrDefault(x => x.Id == bsec.Beat_Id && x.Sector_Id == sectorId);     
                    dataset.Beat.Rows.Add(beat.Name,  
                        emp.Name,          
                emp.Id,                  
        emp.CellNo                     
        // bs.HasWireless                      
    );                 
      }                  
  }            
    else       
          {            
         foreach (var bsec in bs)                   
  {                         dataset.Beat.Rows.Add("", "", "");       
                }               
  }

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Sajid Hussain11y ago
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("", "", ""); } } i have update the code ,i just want that when 4 employee against 4 beat complte ,then it will move to else statment
+1
Vithal Wadje11y ago
check bsec condition is blank
+1