topic RE: Issue in Code Stage using DataTable as Variable in Product Forum

Issue in Code Stage using DataTable as Variable

MohiniShelke — Fri, 19 Jul 2019 10:48:00 GMT

Hi Team,

I am using c# linq query of group in Code Stage,

But, I am getting following error.

Description: Compiler error at line 1: 'System.Data.DataTable' does not contain a definition for 'AsEnumerable' and no extension method 'AsEnumerable' accepting a first argument of type 'System.Data.DataTable' could be found (are you missing a using directive or an assembly reference?)
Repairable: No

Please let me know the solution for this?

Thanks in advance

------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------

RE: Issue in Code Stage using DataTable as Variable

david.l.morris — Fri, 19 Jul 2019 11:03:00 GMT

You're missing a namespace. I think that specific error is if you're missing the generic collections namespace. Can't remember.

Try making sure you have these at least:

External References:

System.dll
System.Data.dll
System.Xml.dll
System.Drawing.dll
System.Core.dll
System.Data.DataSetExtensions.dll

Namespace Imports:

System
System.Drawing
System.Data
System.Collections.Generic
System.Linq

Edit: One or two of those may be unnecessary depending on what you're doing with it, but it won't hurt to add them all.

------------------------------
Dave Morris
3Ci @ Southern Company
Atlanta, GA
------------------------------

RE: Issue in Code Stage using DataTable as Variable

MohiniShelke — Fri, 19 Jul 2019 12:33:00 GMT

Thank David Morris

It works fine but another error occurs as follws:

Description: Compiler error at line 0: The out parameter 'ColumnValues' must be assigned to before control leaves the current method
Repairable: No
My Code :

var grouped = from table in InputCollection.AsEnumerable()var grouped = from table in InputCollection.AsEnumerable()group table by new { placeCol = table["Place"]
} into groupby select new{Value = groupby.Key,ColumnValues = groupby,};

Thanks

------------------------------
Mohini Shelke
RPA Developer
vElement It
------------------------------

RE: Issue in Code Stage using DataTable as Variable

GopalBhaire — Fri, 19 Jul 2019 13:02:00 GMT

Set a default value for variable ColumnValues

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Issue in Code Stage using DataTable as Variable

MohiniShelke — Mon, 22 Jul 2019 06:15:00 GMT

Hi can you tell me how to define default value to variable ColumnValues ?

I tried ,but not working.

I have already shared the code

Thanks in advance.

Thanks & Regards,

Mohini Shelke

RPA Developer, vElement IT,

Cell : (+91)9503221751

https://velement.io/

------Original Message------

Set a default value for variable ColumnValues

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Issue in Code Stage using DataTable as Variable

GopalBhaire — Mon, 22 Jul 2019 08:12:00 GMT

What is datatype of ColumnValues?

if it's collection set this at beginning ColumnValues=new System.Data.DataTable();
if it's text set this at beginning ColumnValues=String.Empty;

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------

RE: Issue in Code Stage using DataTable as Variable

MohiniShelke — Mon, 22 Jul 2019 12:49:00 GMT

Thanks!

Working fine

Thanks & Regards,

Mohini Shelke

RPA Developer, vElement IT,

Cell : (+91)9503221751

https://velement.io/

------Original Message------

What is datatype of ColumnValues?

if it's collection set this at beginning ColumnValues=new System.Data.DataTable();
if it's text set this at beginning ColumnValues=String.Empty;

------------------------------
Gopal Bhaire
Analyst
Accenture
------------------------------