CrystalDecisions.CrystalReports.Engine.ReportDocument rpt = new CrystalDecisions.CrystalReports.Engine.ReportDocument(); rpt.Load(AppDomain.CurrentDomain.BaseDirectory + "\\TechReport.rpt"); DataAcessLayer obj = new DataAcessLayer(); Report rptViewer = new Report(); DataTable DataTab = new DataTable(); System.Data.OleDb.OleDbDataAdapter dataAdapter = new System.Data.OleDb.OleDbDataAdapter(); System.Data.OleDb.OleDbConnection CON = new System.Data.OleDb.OleDbConnection(); CON.ConnectionString = obj.connectionString; string[] tablename = new string[5]; string[] querystring = new string[5]; tablename[0] = "TechnicalParameter"; tablename[1] = "StructualPerameter"; tablename[2] = "PerformancePerameter"; tablename[3] = "EconomicParameter"; tablename[4] = "AcceptibilityParameter"; querystring[0] = "Select * From TechnicalParameter where PlantID= " + id + " "; querystring[1] = "Select * From StructualPerameter where PlantID=" + id + " "; querystring[2] = "Select * From PerformancePerameter where PlantID=" + id + " "; ; querystring[3] = "Select * From EconomicParameter where PlantID=" + id + " "; querystring[4] = "Select * From AcceptibilityParameter where PlantID=" + id + " "; ; DataSet DataSet = new DataSet(); for (int I = 0; I <= Microsoft.VisualBasic.Information.UBound(tablename); I++) { System.Data.OleDb.OleDbDataAdapter Adapter = new System.Data.OleDb.OleDbDataAdapter(); Adapter = obj.GetDataAdeptor(querystring[I]); Adapter.Fill(DataSet, tablename[I]); } rpt.SetDataSource(DataSet); rpt.PrintOptions.PaperSize = CrystalDecisions.Shared.PaperSize.PaperA4; rptViewer.crytt.ViewerCore.ReportSource = rpt; rptViewer.Show();
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)