Hi Folks I want to get the count of id from the status column

[Sanket_Shinde1 (Sanket Shinde)]

all ids start from 63
I want tatal count of those id
in ss I have used filter to show you

[Shiva_Nikhil]

@Sanket_Shinde1

dt.asenumerable.where(function(a) a("Status").tostring.startswith("63")).tolist.count

[Parvathy (PS Parvathy)]

Hi @Sanket_Shinde1

Try this:

totalIdsCount = YourDataTable.AsEnumerable().Where(Function(row) row.Field(Of String)("Status").StartsWith("63")).Count()

Output Datatype of totalIdsCount is System.Int32
Hope it helps!!

[Yoichi]

HI,

Can you try the following?

dt.AsEnumerable.Count(Function(r) r("status").ToString.StartsWith("63"))

Regards,

[Sanket_Shinde1 (Sanket Shinde)]

@Parvathy

totalIdsCount = YourDataTable.AsEnumerable().Where(Function(row) row.Field(Of String)("Status").StartsWith("63")).Count()

The count is coming zero 0

[Sanket_Shinde1 (Sanket Shinde)]

Count is coming as Zero 0

[Shiva_Nikhil]

@Sanket_Shinde1

can you try this use .trim

dt.asenumerable.where(function(a) a("Status").tostring.trim.startswith("63")).tolist.count

[Sanket_Shinde1 (Sanket Shinde)]

Same it is not giving the count
coming Zero 0

[Sanket_Shinde1 (Sanket Shinde)]

It works ! Thank You So Much Shiva_Nikhil

[Sanket_Shinde1 (Sanket Shinde)]

It work with some modification = ToString.Trim.StartWith…

Thank You So Much Parvathy

[Sanket_Shinde1 (Sanket Shinde)]

It work with some modification = ToString.Trim.StartWith…

Thank You So Much Yoichy