problem by select output RSS

• • Reply
  

  triskac

  Member

  15 Points

  52 Posts

  problem by select output

  Jan 24, 2013 07:49 PM|LINK

  Hi

  I have this code, when I try it in database I get result, but in webmatrix I get error System.Collections.ObjectModel.ReadOnlyCollection`1[System.Object]

  Code is here

  @{
       Layout="/Shared/Layout2.cshtml"; 
      var db = Database.Open("tipy");
      var selectedData = db.Query ("select SUM (D.Zisk) from (select case when C.VyhraCelkom='Ano' then (C.Odd*5-5) when C.VyhraCelkom='Nie'then (C.Odd*0-5) end as Zisk from (select B.IdTiketu, B.Datum, B.Odd,B.VyhraCelkom from (select Id, IdTiketu, Datum, Kurz as Odd,VyhraCelkom from tipytest where TypStavky='Jednoducha' union select A.Id, A.IdTiketu, A.Datum, A. Calcrate as Odd,A.VyhraCelkom from (select Cur1.ID,Cur1.TypStavky,Cur1.Datum,Cur1.IdTiketu, Cur1.Kurz * Cur2.Kurz as CalcRate,Cur1.VyhraCelkom From tipytest as Cur1 INNER JOIN tipytest as Cur2 on Cur1.Datum=Cur2.Datum And Cur1.TypStavky=Cur2.TypStavky And Cur1.IdTiketu=Cur2.IdTiketu And Cur1.Id <> Cur2.ID where Cur1.TypStavky='Kombi') A) B group by Datum, IdTiketu, Odd, VyhraCelkom) C) D");
  }
   
  The result is @selectedData

• • Reply
  

  Mikesdotnett...

  All-Star

  154955 Points

  19872 Posts

  Moderator

  MVP

  Re: problem by select output

  Jan 25, 2013 05:27 AM|LINK

  Use Database.QueryValue insteadof Database.Query:

  @{
       Layout="/Shared/Layout2.cshtml";
      var db = Database.Open("tipy");
      var selectedData = db.QueryValue("select SUM (D.Zisk) from (select case when C.VyhraCelkom='Ano' then (C.Odd*5-5) when C.VyhraCelkom='Nie'then (C.Odd*0-5) end as Zisk from (select B.IdTiketu, B.Datum, B.Odd,B.VyhraCelkom from (select Id, IdTiketu, Datum, Kurz as Odd,VyhraCelkom from tipytest where TypStavky='Jednoducha' union select A.Id, A.IdTiketu, A.Datum, A. Calcrate as Odd,A.VyhraCelkom from (select Cur1.ID,Cur1.TypStavky,Cur1.Datum,Cur1.IdTiketu, Cur1.Kurz * Cur2.Kurz as CalcRate,Cur1.VyhraCelkom From tipytest as Cur1 INNER JOIN tipytest as Cur2 on Cur1.Datum=Cur2.Datum And Cur1.TypStavky=Cur2.TypStavky And Cur1.IdTiketu=Cur2.IdTiketu And Cur1.Id <> Cur2.ID where Cur1.TypStavky='Kombi') A) B group by Datum, IdTiketu, Odd, VyhraCelkom) C) D");
  }
   
  The result is @selectedData

  
  
  

  Regards, Mike
  Beginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
  • Marked as answer by triskac on Jan 25, 2013 07:03 AM
• • Reply
  

  triskac

  Member

  15 Points

  52 Posts

  Re: problem by select output

  Jan 25, 2013 07:03 AM|LINK

  Mike,

  thank you very much, now it is working