Error Exception of type 'System.OutOfMemoryException' was thrown

[mrprogman]

Hi , when a run this code i got this error

Error Exception of type 'System.OutOfMemoryException' was thrown

what can be the problem..?...memory ..?..the code..?.what can i try to find first.....?.....thanks for you answers..

Dim MyConnection As System.Data.Odbc.OdbcConnection = New System.Data.Odbc.OdbcConnection("Driver={Progress Openedge 10.1A Driver};DSN=PROGRESS;DB=pace;UID=sysprogress;PWD=password;HOST=192.168.10.248;PORT=2580;")


Dim MyCommand As System.Data.Odbc.OdbcDataAdapter = New System.Data.Odbc.OdbcDataAdapter("SELECT PUB.tkt.inum,PUB.tkt.idate,PUB.titm.pccost,PUB.titm.pcost FROM PUB.titm INNER JOIN PUB.tkt ON PUB.TITM.SID = PUB.TKT.SID WHERE PUB.tkt.sid in (21) AND PUB.tkt.idate >= {d '2012-01-30'} AND PUB.tkt.idate <= {d '2012-01-30'} ", MyConnection)


Dim DS As DataSet = New DataSet
MyCommand.Fill(DS, "titm")
GridView1.DataSource = DS.Tables("titm").DefaultView
GridView1.DataBind()

 

[Stefan]

0. putting code between

 can make it more readable
1. which statement results in the error?
2. how many records should the query be returning? does qualifying the query so that it returns less records prevent the error?
3. can you strip the query down to a really basic query (that does not error) and then keep adding to it until you get an error?

 

[mrprogman]

0. putting code between

 can make it more readable[/COLOR]
[COLOR=#333333]-OK
1. which statement results in the error?
[/COLOR]- Only receive this error , no line codes or other advice

[COLOR=#333333]2. how many records should the query be returning? does qualifying the query so that it returns less records prevent the error?[/COLOR]
[COLOR=#333333]- I Think that this is the problem, i pull many records..more of 8000

3. can you strip the query down to a really basic query (that does not error) and then keep adding to it until you get an error?
- I make this, but, if only pull one field from the table , i receive the error, it's the same problem[/COLOR]