Hello everyone, I have the following line, which obtains the new lines of a company and shows me the sales of each new line, but I have a problem there are some lines that have uppercase letters and others in lowercase, how can I do so that my linq is not case sensitive
That is, when I run my linq, I get the list of the following new lines
Aceites de café
Aceites de Café
Cold Brew
Extracto
Granulado
Liofilizado
Polvo
VIA
I need only one Aceites de café to come out
This is the linq I have
(From row In dtFinal.AsEnumerable() Where row(“Sociedad”).ToString.Trim.Equals(“Ind Colombiana Cafe S.A.S”) Group row By NF = row.Item(“LINEA NUEVA”).ToString.ToLower Into Group Select dtFinal.Rows.Add({
NF, Group.Sum(Function(x) If(String.IsNullOrEmpty(x(“Ventas Netas Act”).ToString) Or String.IsNullOrWhiteSpace(x(“Ventas Netas Act”).ToString),0, Convert.ToDouble(x.Item(“Ventas Netas Act”).ToString)))
})).CopyToDataTable