vb.net数据集内存超出异常 [英] vb.net dataset memory out of exception

问题描述

大家好



我的要求是从sql server带来数据，但我需要从数据库中带来6万亿行项目



当我使用dataadapter.fill（数据集）时我得到了异常内存



请指导我解决问题.. ..........



先谢谢

hi All

My requirement is to bring the data from sql server but i need to bring 6 lakhs line items from database

when i am using dataadapter.fill(dataset) i am getting memory out of exception

please guide me to solve the issue............

Thanks in Advance

推荐答案

您的数据集也是如此big.Datasets存储在计算机内存中，所以我猜你的内存太多了。尝试使用datareader或编写xml和那里的读数。考虑到您尝试检索的行数，您应该选择未断开连接的数据访问。

Your dataset is too big.Datasets are stored in computer memory so i guess yours is using too much memory. Try using a datareader or writing xml and the reading from there. Given the number of lines you are trying to retrieve you should go for connected data access not disconnected.

这篇关于vb.net数据集内存超出异常的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！