Hi, I am Facing issue with extracting data from SQL Database. pls help me out

[Lokesh_M2 (Lokesh M)]

I need extract data from various columns in Sql Database.
1.One of the column with nvarchar datatype with numbers.
2. While in UiPath if am taking as string of that column and comparing it is nor working.
3. I converted to nchar variables to integer. but is showing validation error like this.
Invoke Process workflow: The following errors were encountered while processing the workflow tree:
‘Process’: The private implementation of activity ‘1: Process’ has the following validation error: Cannot assign from type ‘System.String’ to type ‘System.Int32’.
‘Process’: The private implementation of activity ‘1: Process’ has the following validation error: Cannot assign from type ‘System.String’ to type ‘System.Int32’.

[Srini84 (Srinivas)]

@Lokesh_M2

So while comparining a string value to Integer it will always throws an issue
But you can convert using Cint(StringValue) = 32 then it will works

If this is not the issue, can you share some screenshots / more info?

Thanks,
Srini

[Lokesh_M2 (Lokesh M)]

Hi, Thank u for response, Actually my issue is
Two columns in SQL database with data with datatype nCharvar
No of personsroomA= 2
No of personroomB= 2

now i need compare data from these two columns in UiPath.

[Srini84 (Srinivas)]

@Lokesh_M2

For that you can refer below post

Compare two column and update to another column through linq

@Yoichi In the same sheet i want to update the datatable ex: i have some 10 coulmns. Out of that i have to check columns -“Names” and “Material” should not be nothing then update the columns column(“status”)=“Approve” and column("Date ")=Date.Now [image] want to create a new datatable at last Please help Regards, Seema

You have to change the type Of String to Of Int32 and it will work

Hope this may help you

Thanks,
Srini