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

Deepika Chaudhary

15y5.8k.NET

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

5 Replies

Know the answer? Post it — somebody with the same question will find it here.

Deepika Chaudhary15y ago
the problem got solved using session..instead of viewstate we have to use session if storing large no. of data.
0
Deepika Chaudhary15y ago
protected void Button1_Click(object sender, EventArgs e)
{

dtExcelData = ExcelData();
ViewState["dtExcelData"] = dtExcelData;if (dtExcelData.Rows.Count < 0)//here i am getting all the 65536 rows.

return;
}

protected void Button2_Click(object sender, EventArgs e)
{
DataTable dtTest1 = (DataTable)ViewState["dtExcelData"];
if (dtTest1.Rows.Count < 1)
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?
0
Deepika Chaudhary15y ago
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.
0
Amit Choudhary15y ago
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.

0
Deepika Chaudhary15y ago
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.
0