[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")

---

How many records?

Why the two data sets?

Well - as the exception says - you're trying to do something which you haven't got memory for.
You need to change your procedure.

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...