>Is there any way to re-fill the table in my dataset with a WHERE clause in my SQL statement?<
Yes, just set your SqlCommand.CommandText equal to the SELECT statement with the WHERE clause in it and Fill the DataSet again. Does this answer your question or have I totally misunderstood your problem?
