Slow Crystal Report Loading C# VS.Net 2005

[Coldfire]

I am having problem with slow crystal report loading plus slow dataadapter.fil l method
here is my code

[HTML]
string SelectCmd = "SELECT * FROM EnterInstituteI nformation WHERE EnterInstituteI nformation.Inst ituteID=" + ID;

this.oleDbSelec tCommand1.Comma ndText = SelectCmd;

oleDbSelectComm and1.Connection = oleDbConnection 1;
oleDbDataAdapte r1.SelectComman d = oleDbSelectComm and1;

oleDbDataAdapte r1.Fill(dsEnter InstituteInform ationFullReport 1);

//--Initializing CrystalReport
InstituteReport rpt;
rpt = new InstituteReport ();
rpt.Load("Insti tuteReport.rpt" );
rpt.SetDataSour ce(this.dsEnter InstituteInform ationFullReport 1);
this.crystalRep ortViewer1.Repo rtSource = rpt;

this.Show(); //form at which crystalreportVi ewer lies
this.oleDbConne ction1.Close();[/HTML]
give me some hints to improve the speed of loading crystalreports

[Coldfire]

just to mention...
i am using MS Access Database with only few records may be 5 and the table contains 14 columns.

[kenobewan]

Are you still running debug mode? Please provide more information. Thanks.

[Coldfire]

Are you still running debug mode? Please provide more information. Thanks.

Yes, but I also have checked it in Release mode, the delay is almost same.

[HTML]
oleDbDataAdapte r1.Fill(dt); //taking 30 secs almost
.....
.....
.....
this.Show(); //this fucntion loads crystalreport and is taking 15-20 secs
[/HTML]


One more thing,
can I pull data in crystalreport without dataadapter/dataset

[Coldfire]

if this is the reason ....
[HTML]In previous versions of ADO.NET, if you used a DataSet (Who haven't), you most likely are familiar with slow performance of the DataSet when loading and serializing a large amount of data. Now ADO.NET team has done a fantastic job by taking care of these problems in ADO.NET 2.0 by extending the DataSet and the DataTable classes.

In previous versions of ADO.NET (1.0 and 1.1), it was all about the DataSet and the DataTable was a slave of the DataSet. In ADO.NET 2.0, the DataTable object celeberates independence from the DataSet and brings much more to the table for developers. [/HTML]
@
http://www.c-sharpcorner.com/UploadFile/mahesh/DataTable201117 2005235038PM/DataTable20.asp x

But i am using .NetFramwork 2.0 and building my application in VS.Net 2005. From where can I see that my ADO.Net version is 1.1 or 2.0.(obviously it should be 2.0).
Do I need to upgrade ado.net 2.0 further. If yes, than how?

[farooqbob]

It can help u


Private rpt As RptAdress 'this is a crystal report class genrated by .net
Private DSrpt As DS_ADDRESS ' this is Dataset XSD class

Public Function LoadRptData(ByV al SelectQuery As String) As Boolean
Dim mycon As OleDbConnection
Dim da As OleDbDataAdapte r
Try
mycon = New OleDbConnection
mycon.Connectio nString = gconnString
'Dim sqlstmt As String = "Select NriName, ADDRESS from ADDRESS_BOOK"
da = New OleDbDataAdapte r(SelectQuery, mycon)
' Remember to change data source as applicable.
DSrpt = New DS_ADDRESS
da.Fill(DSrpt, "ADDRESS_BO OK")

rpt = New RptAdress
rpt.Database.Ta bles(0).SetData Source(DSrpt)
RptAddressViewe r.ReportSource = rpt

Return True
Catch ex As Exception
Throw ex
End Try
End Function