Thanks for the help. This worked. However, I only used the second line. I already had a DataSet, then to get a distinct list of all the states in this DataSet, I used the line:
MyDataSet.Tables["Employees"].DefaultView.ToTable(true,"myStatefld");
The ToTable is pretty nice. Hey, Jerry...
Glad that worked. Yeah, the ToTable is really sweet - it helps for instances where a table object is required (as opposed to a view object), and that first parameter helps with filtering distinct rows. I did a demo of that at a User Group a few months ago, and a few developers almost leaped for joy.
Kevin