Non-Invocable member ‘Function’ cannot be used like a method

Help Studio
, ,
1

Hello Team,

I am getting below error while fetching the unique value from excel column.(in C# language)

The image shows an Expression Editor with a syntax error in the code, highlighting issues such as 'Syntax error', non-invocable member 'Function', and the name 'row' not existing in the current context. (Captioned by AI)
The image shows an Expression Editor with a syntax error in the code, highlighting issues such as 'Syntax error', non-invocable member 'Function', and the name 'row' not existing in the current context. (Captioned by AI)1087×311 9.27 KB

Can someone assist me to resolve this error or do we have another to do the same?

Thanks,
Riya

2

Hi @Riya1

You have given linq expression is in vb which is absolutely correct.

You can try the below for C#

DT.AsEnumerable().Where(row => !string.IsNullOrEmpty(row["ColumnA"].ToString())).Select(row => row["ColumnA"].ToString()).Distinct().ToList()

Hope it helps!!

3

Hi @Riya1

Use below query

Uniquevalues = DT.AsEnumerable().Select(row => row["YourColumnName"].ToString()).Distinct().ToList();

Regards,

4

Hi @Riya1 ,
In C#, the syntax for the LINQ query is slightly different from VB.NET.

Try this below LINQ

dt_Input.AsEnumerable().Select(row => row[“First Name”].ToString()).Distinct().ToList();
Thanks,
Muthuraj