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