If you're dataset is fixed (meaning same query except for where clause) it might be easier to create a report that takes in one or more parameters and let the report do the rest.
eg. the query is :
select emp_id, emp_name, emp_grade from employees where emp_category = :p0;
you create the report as you wish and send the :p0 parameter to the report through .Net. The report handles the rest.
hope this helps.