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";vardb=Database.Open("tipy");varselectedData=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
@{
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
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
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 @selectedDataBeginning ASP.NET Web Pages with WebMatrix | My Site | Twitter
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