Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
GetDataSet method and mutltiple result sets
Message
Information générale
Forum:
ASP.NET
Catégorie:
The Mere Mortals .NET Framework
Versions des environnements
Environment:
C# 3.0
OS:
Windows XP
Network:
Windows 2003 Server
Database:
MS SQL Server
Divers
Thread ID:
01416914
Message ID:
01417443
Vues:
27
>>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform