Print all rows of datatable in a message box

[swetha_pattabhi]

My datatable name is MarkSheet
it has columns - StudentName , Age, EmailId , Score.

The values in datatable Marksheet are the inputs from user. After taking all inputs from user I am trying to show all the rows of a datatable in a message box to user.

Text attribute of the message box →
"The School’s marksheet provided by you is
" + MarkSheet.ToString

This is giving me the name of the datatable but i want the data.

[redlynx82 (Wolfgang)]

This has been asked (and answered) several times. The general idea is to loop over each for, and then over each cell. You want to append all data to a string-typed variable, and then add a New Line character after each row. Here are just a few examples:

How to read value of individual cells from datatable

How do I read an individual value from a row and column in a datatable ? I know I can do for each row and then get item … that’s too cumbersome I need to simply say x = datatable (row, col)

How to loop through rows and columns in an excel and pass them to a webpage

Hi, I need to capture data from each row and each column and pass them to a webpage to login. Excel: usrname password user1 pswd1 user2 pswd2 user3 pswd3 webpage username-textbox password-textbox How do i do this? I started of by Read Range activity to read data present on the excel. created a variable to read the column count in to. I am looking for how would i fetch and pass them to webpage in a loop

Get a cell value from DataTable

I have a simple csv file which has a header row and n amount of rows below it like this. Each row has two columns: parameter;value firstname;simon surname;cowell title;judge birthday;07.10.1959 favouritecolour;pink gender;male The amount of rows can differ but the “parameter” column’s values are always constant. How can I read for example the value of “birthday” (which would be 07.10.1959 in this example) into a variable from this csv file? I have found some examples which are using the…

[venkat4u (venkat)]

@swetha_pattabhi,

currently message box doesnt support the Datatable as input.

the work arround is you can use output datatable → which convert datatable as string format.

after you convert you can print in messagebox

[Jan_Brian_Despi]

Hi @swetha_pattabhi.
You may use Output Data Table activity.

Output Data Table

Its input is a data table and its output is a string.
You may use the output from the Output Data Table activity on the message box.

Thanks and regards.
Despi

[swetha_pattabhi]

Thank you all. I used a string variable and have written all the Datarows to it. Finally printed the string variable in log message and message box activity