You actually answered this question by your previous response. I was just trying to figure out how to pass the parameters collection into GetDataSet method.

>>Hi everybody,
>>
>>I have this code
>>
>>

>>public DataSet GetDataForRouteScheduleReport(int CompanyID, DateTime StartDate, DateTime EndDate)
>>        {
>>            // Returns Header DataSet
>>            DataSet ds = this.GetDataSet("getRouteScheduleReportData", CommandType.StoredProcedure);
>>            ds.Tables[0].TableName = "RouteData";
>>            ds.Tables[1].TableName = "Cleaners";
>>            ds.Tables[2].TableName = "Equipment";
>>            ds.Tables[3].TableName = "Jobs";
>>            ds.Tables[4].TableName = "JobDetails";
>>            ds.Tables[5].TableName = "Notes";
>>            return ds;
>>        }

>>
>>but I believe this code doesn't pass parameters. Do we have a sample of passing parameters here?
>>
>>Thanks in advance.
>
>
>I am not sure what you are trying to do here. Are you trying to rename the tables? What do you mean by passsing parameters. The only thing returned is the DataSet and what is passed in is defined in the arguments of your method. I guess I am just not sure of the question.
>Tim