c# and codec audio and video
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
Hi Anoop,
Please try this SQL and let me know if it works for you
- declare @storeid bigint
- set @storeid=19
- 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
- from InventoryInwards as I
- LEFT JOIN
- (select ReferenceNo, nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as InwardQty
- from InventoryInwards where StoreID=@storeid
- group By NameOfStores, ReferenceNo, Unit) as Inwards ON I.NameOfStores = Inwards.NameOfStores
- and i.ReferenceNo=Inwards.ReferenceNo
-
- left JOIN
- (select nameofStores, ISNULL(Sum(ISNULL(Qty,0)),0) as IssuedQty
- from InventoryIssued where StoreID=@storeid
- group By NameOfStores, ReferenceNo, unit) as Issued on I.NameOfStores= Issued.NameOfStores
-
-
-
- where i.StoreID = @storeid
- group by I.NameOfStores, I.ReferenceNo, I.Unit
Accepted 0
Thanks Ankit... that was I missing out.