I have a Datatable filled with this query:
The primary key is Employee_ID.
Basically, I want to find if a particular row exists on this DataTable by looking at the SSN, instead of the Employee_ID. The SSN is a unique key, but not the primary key.
I just want a boolean flag that returns if a matching SSN record exists.
How do I do this?
I am using Visual Basic 2005, Visual Studio 2005.