Could not get the value property. Not enough storage is available to complete this operation.

Question

Hi all I am getting this error Could not get the value property. Not enough storage is available to complete this operation. when trying to import the excel data in ado.net datatable with 65536 no. of rows. how can i solve this? With around 30000 i am not getting any error. This error i am getting with large no. of record in excel file and reading that in ado.net table? Please help..

Deepika Chaudhary · Answer

the problem got solved using session..instead of viewstate we have to use session if storing large no. of data.

Deepika Chaudhary · Answer

protected void Button1_Click( object sender EventArgs e) { dtExcelData = ExcelData(); ViewState[ dtExcelData ] = dtExcelData; if (dtExcelData.Rows.Count return ; } protected void Button2_Click( object sender EventArgs e) { DataTable dtTest1 = ( DataTable )ViewState[ dtExcelData ]; if (dtTest1.Rows.Count return ; } But when clicking on button2 it is not going in click event and give the error..if i use the button2 code in the button 1 only then it will not throw the error.. so problem is with postback and large records stored in viewstate..how can i solve this?

Deepika Chaudhary · Answer

not the problem with column data type.. i am getting all the 65536 records in datatable..and in viewstate also. but after postback it is giving error.

Amit Choudhary · Answer

This error is not because of no. of rows. But because of column data type is getting changed while reading and converting it to datatable. I guess a column from Excel is being treated as numeric column which is not supposed to be numeric. And thats why while reading when the cell value having more than 65536 it is throwing error. This is my guess it could be such scenario but i'm sure this error is coming due to some wrong conversion. Try using IMEX=1 in the connection string. For more details read this article here thoroughly will help you understanding the issue and giving you solution for this. Hope this was helpful.

Deepika Chaudhary · Answer

I am able to read the data from excel to ado.net datatable but after that i am storing the datatable records in viewstate. and on button click using this viewstate..but if the datatable records are larger like 65536 testing then i am getting this error htmlfile: Could not get the value property. Not enough storage is available to complete this operation. and it is not going on button click event.