1
Answer

c# and codec audio and video

Photo of paolo

paolo

17y
3k
1
Hi, I'm new here. I'm not a great C#/.Net programmer. I'd like to program a little application that decode in a memory buffer some all of multimedia file type (like avi, mp3, aac etc...) of all supported format (all installed codec) So 1) I'm a bit confused about codec, which is right name to use? Codec or Dx Filter? 2) I'd like to display all codecs present in a pc 3) There's a place where windows write which codec must used with file extention? 4) I've read about quartz dll but which is the right/fast way to decode in a memory buffer an mp3 or avi? Thanks

Answers (1)

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.