format total with two decimals in linq : The Official Microsoft ASP.NET Forums

Reply

lvasquez20

0 Points

format total with two decimals in linq

Feb 01, 2013 08:05 PM|LINK

hello everyone, i have a little problem with decimal, i have a linq but my total returns me a lot of decimals but i only need two, this is my linq

Dim listado = (From a In db.LOG_MuestrasLeatherD _
                             Join b In db.LOG_MuestrasLeather On a.IDMuestraLeather Equals b.IDMuestraLeather
                             Join c In db.PROD_Tamaños On a.IDTamaño Equals c.IDTamaño
                             Join d In db.PROD_Secciones On b.IDSeccion Equals d.IDSeccion _
                              Where b.IDMuestra_E = idmuestrae
                                Select New With { _
                                            .IDMuestra_E = b.IDMuestra_E,
                                            .IDMuestraLeather = b.IDMuestraLeather,
                                            .Seccion = d.Seccion,
                                            .Tamaño = c.Tamaño,
                                            .Bancas = b.Bancas,
                                            .Subtramos = b.Subtramos,
                                            .Cantidad = a.Cantidad,
                                            .RollosXBanca = a.RollosXBanca,
                                            .Rollos = a.Rollos,
                                            .Total = (a.Rollos /
                                                         (From z In db.LOG_MuestrasLeatherD
                                                             Where
                                                              z.LOG_MuestrasLeather.IDMuestra_E = idmuestrae
                                                             Select New With { _
                                                                 z.Rollos()
                                                            }) _
                                                        .Sum(Function(p) p.Rollos) * 100)
                                    })

so in the column total i want to return only two decimals

 .Total = (a.Rollos /
                (From z In db.LOG_MuestrasLeatherD
                 Where
                 z.LOG_MuestrasLeather.IDMuestra_E = idmuestrae
                         Select New With { _
                               z.Rollos()
                          }) _
                         .Sum(Function(p) p.Rollos) * 100)

so how i can to do? i appreciate the help

keep the faith