Hi, I have a VB 2005 Windows Application using an Access 2003 database.
In my application, I've creating a dataTable called "dtUsers" and am filling it with all the fields from the "Users" Table. I would like to use the FIND property to search the dataTable for a specific User's Last Name. I know I can loop through all the rows one at a time until I find a match, but that seems extremely inefficient.
If dtUsers.Rows.Find("LastName") = "Finklestinkle" Then
Console.WriteLine("I found him...!!!")
I think the syntax may be wrong, and it keeps telling me the dataTable does not have a Primary Key.
Any suggestions or tutorials that might help?