>
>I'm pretty new to this and I really don't have an idea on how to optimize my Select statement to utilize the index on the table. In VFP, I use the Fox commands to optimize using SEEK, Scan...EndScan, but I can't use them in .Net.
>Any ideas?

See Using Rushmore Query Optimization to Speed Data Access http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dv_foxhelp/html/dgusing_rushmore_to_speed_data_access.asp