I am having problem with slow crystal report loading plus slow dataadapter.fill method
here is my code
[HTML]
string SelectCmd = "SELECT * FROM EnterInstituteInformation WHERE EnterInstituteInformation.InstituteID=" + ID;
this.oleDbSelectCommand1.CommandText = SelectCmd;
oleDbSelectCommand1.Connection = oleDbConnection1;
oleDbDataAdapter1.SelectCommand = oleDbSelectCommand1;
oleDbDataAdapter1.Fill(dsEnterInstituteInformation FullReport1);
//--Initializing CrystalReport
InstituteReport rpt;
rpt = new InstituteReport();
rpt.Load("InstituteReport.rpt");
rpt.SetDataSource(this.dsEnterInstituteInformation FullReport1);
this.crystalReportViewer1.ReportSource = rpt;
this.Show(); //form at which crystalreportViewer lies
this.oleDbConnection1.Close();[/HTML]
give me some hints to improve the speed of loading crystalreports