Sunday, March 24, 2013

C# remove item from ListObject



  private void OnDeleteItemCommand(BO.DC_RequisitionItem reqItem)  
     {  
         if (reqItem.id != 0)  
           {  
             var objReqItem = ViewData.Requisition.DC_RequisitionItemList.SingleOrDefault(m => m.id == reqItem.id);  
             if (objReqItem != null)  
             {  
               //Get deleted item by item id  
               var itemList = new ObservableCollection<BO.DC_RequisitionItem>();  
               foreach (var mx in ViewData.Requisition.DC_RequisitionItemList.Where(mx => mx.ReqRefNo == reqItem.id))  
               {  
                 itemList.Add(mx);  
               }  
               if (itemList.Any())  
               {  
                 foreach (var m in itemList)  
                 {  
                   ViewData.Requisition.DC_RequisitionItemList.Remove(m);  
                   var da = ViewData.Requisition.DC_RequisitionItemList.FirstOrDefault( mx =>m.ReqRefNo == objReqItem.id);  
                   if (da != null)  
                     ViewData.Requisition.DC_RequisitionItemList.Remove(da);  
                 }  
               }  
               //delete from requisition item  
               ViewData.Requisition.DC_RequisitionItemList.Remove(objReqItem);  
             }  
           }  
     }  

SQL Get all Index create script from Database

To get all script from database as a create new index into another database you can use the following --Get all Index Script SELECT...