I am working with application for Excel sheets in vb.net
My database is Sql server 2005
I am having around 8 lakhs of rows in my database and 64 columns.
when I import a excel sheet for searching the Duplicate of excel sheet rows in database i get this Error System Out of Memory Exception.
What is the reason to occur this kind of Error.
Is it due to Excess of rows in database or coding error in Application.
Please Revert back with simple solution.
So that i can work on it.

maybe if you could give us more details?

Complete error,
How are you importing it,
If via code, can you provide us with the code,
If the exception is being triggered in code, we need the code + the exact line where the exception is being fired.
What do you mean by 8 lakhs of rows

without knowing what code you are working on , how can one guess if it is coding error or not .

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.