Member_2_5230414
asked on
VB.net Datatable -> check if column contains value before adding it
Hello all,
I have a datable and I want to check if the column contains a value before adding a row...
so...
If scorestable.Columns("HomeT eam") contains value = "Myteam" then
'Do something
else
scorestable.Rows.Add(Strin gOutNumber s(div.sele ctSingleNo de(".//td[ @class='ho me']").Inn erText), div.selectSingleNode(".//t d[@class=' time']").I nnerText.T rim().Subs tring(0, 2) , thescorestext)
End if
That way I don't get repeat values
I have a datable and I want to check if the column contains a value before adding a row...
so...
If scorestable.Columns("HomeT
'Do something
else
scorestable.Rows.Add(Strin
End if
That way I don't get repeat values
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
i used the below code but its not adding anything to the table
dim DVScores as new dataview(scorestable)
For each dr as DataRow in DVScores
If dr.Item("HomeTeam").ToString.Contains(StringOutNumbers(div.selectSingleNode(".//td[@class='home']").InnerText)) Then
' value found - do something, e.g.
else
scorestable.Rows.Add(StringOutNumbers(div.selectSingleNode(".//td[@class='home']").InnerText), div.selectSingleNode(".//td[@class='time']").InnerText.Trim().Substring(0, 2) , thescorestext)
Exit For
End If
Next
ASKER
Works great although not used Linq before- something I will look into thanks
Open in new window