I use this all the time to build sql criterias. If you are doing what I think you are, there are 2 ways that I use to handle the building of the comma delimited string for a SQL clause.

1) Basically, just always add a comma when adding an item to the comma delimited list. Then at the end, check to see if the last character is a comma and then remove it using
myString = myString.SubStr ing(0,myString. Length-1);
2)...

I am running into an issue with a HashTable where it isnt holding data in the order that I am adding it. I am pulling a SqlDataReader out of a table and looping through that to add the items to the HashTable. I have an ID field (autonumber) and a Sort Index field. I want the items to be stored in the hashtable by Sort Index. However, when I add the items into the hashtable they are getting all messed up. For example, when I have the following data:...