Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
GetDataSet method and mutltiple result sets
Message
General information
Forum:
ASP.NET
Category:
The Mere Mortals .NET Framework
Environment versions
Environment:
C# 3.0
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Miscellaneous
Thread ID:
01416914
Message ID:
01417443
Views:
28
>>Let me know if this helps...
>
>Kevin, This was very timely for me. I tried your push method out and it worked like a charm. Thanks for sharing.

Yes, worked great for me too. I just needed to set all the table names in the Biz object like this
 public DataSet GetDataForRouteScheduleReport(int CompanyID, DateTime StartDate, DateTime EndDate)
        {
            // Returns Header DataSet
            DataSet ds = this.GetDataSet("getRouteScheduleReportData", CommandType.StoredProcedure,
                this.CreateParameter("@nCompanyID", CompanyID), 
                this.CreateParameter("@StartDate", StartDate), this.CreateParameter("@EndDate", EndDate));
            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;
        }
and then in the ReportViewer page I used that method.

Kevin actually has this as part of the separate class, I found a link to this class and gave a link somewhere in this thread.
If it's not broken, fix it until it is.


My Blog
Previous
Reply
Map
View

Click here to load this message in the networking platform