2
Answers

which classes are used in asp.net

Photo of cyrax khan

cyrax khan

10y
868
1
i am currently learning desktop/ console app programming with c#

i am curious to know when you write asp.net web pages do you still use the same classes
that you use in writing desktop apps

eg using system
  using threading
etc

or is it that when you write asp.net web pages you are only allowed to use a certain category of classes.

thnx

Answers (2)

0
Photo of Ankit Sharma
NA 8.8k 141k 7y
Hi Anoop,
 
Please try this SQL and let me know if it works for you
 
  1. declare @storeid bigint    
  2. set @storeid=19    
  3. select  I.NameOfStores, I.ReferenceNo, SUM(Inwards.InwardQty) InwardQty,  SUM(ISNULL(Issued.IssuedQty,0)) IssuedQty, SUM((ISNULL(Inwards.InwardQty,0)-ISNULL(Issued.IssuedQty,0)))as Balance    
  4. from InventoryInwards as I     
  5. LEFT JOIN    
  6.         (select ReferenceNo,  nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty    
  7.         from InventoryInwards where StoreID=@storeid  
  8.         group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores    
  9.         and i.ReferenceNo=Inwards.ReferenceNo  
  10.          
  11. left JOIN    
  12.         (select   nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty    
  13.         from InventoryIssued where StoreID=@storeid    
  14.         group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores    
  15.         
  16.           
  17.     
  18. where i.StoreID = @storeid    
  19. group by I.NameOfStores, I.ReferenceNo, I.Unit   
Accepted
0
Photo of Anoop Bansal
NA 58 2.2k 7y
Thanks Ankit... that was I missing out.