-
November 4th, 2009, 07:25 AM
#1
[RESOLVED] error - Exception of type 'System.OutOfMemoryException' was thrown.
Hi all, my application occurs an error "Exception of type 'System.OutOfMemoryException' was thrown." when trying to import xlsx file to sql server.
Any help appreciated...Please Help this is very urgent
Code:
strSQL = "select * from [" & ExcelSheetName & "]"
Dim Oledbcmd As New OleDbCommand(strSQL, XLSconnection)
Dim oledbda As New OleDbDataAdapter(strSQL, XLSconnection)
Dim DS As New DataSet
ProgressBar1.PerformStep()
oledbda.Fill(DS, "DS")
-
November 4th, 2009, 06:30 PM
#2
Re: error - Exception of type 'System.OutOfMemoryException' was thrown.
How many records?
Why the two data sets?
-
November 6th, 2009, 02:36 AM
#3
Re: error - Exception of type 'System.OutOfMemoryException' was thrown.
Well - as the exception says - you're trying to do something which you haven't got memory for.
You need to change your procedure.
-
November 6th, 2009, 04:39 AM
#4
Re: error - Exception of type 'System.OutOfMemoryException' was thrown.
Yes,that's why after i deleted the dataset code, and just using data reader, the code works fine. Dataset consume much memory than data reader...
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|