How to get value of one complete row in data table.
You can read DataRow for each DataColumn in DataTable. I have attached a screenshot for same.Here item is of type DataColumn.
IS there any other way to compare to columns value of excel without looping…?
You can do some magic actually:
I will reffer to an older post where i explain how working with List instead of using Datatables can help when you need to work with dataTables.
What are you trying to do?
I will give you some examples:
List of first columns values as string :
string.join(",", dataTable.Rows.Cast(of DataRow).Select(function(row) row(0).tostring).tolist)
Getting totals for data subgroups:
In order to understand the example Column1=Footbal Team Column2=Cost
Total cost of all player on each team: it could be done with only one line code but would be more difficult
for each (teamName in dataTable.Rows.Cast(of DataRow).Select(function(row) row(0).tostring).distinct)
accumulativeCost = dataTable.Rows.Cast(of DataRow).Where(function(row) row(0).tostring = teamName).Sum(function(row) row(1))
You can do almost anything with linq give us a detailed explanation about your problem and we can provide you a detailed answer