将sqldataadapter中的数据填充到VB.NET中包含二进制数据的数据表时出错 [英] Getting error when fill data from sqldataadapter to datatable in VB.NET which contain binary data

问题描述

Hi
我将二进制数据存储在一个表中，在For循环中逐个获取二进制数据，下面是我的代码，其中

fadts是datatable包含3行，当第一个时间工作正常，第二次在dataadapter中填充数据时会抛出错误，

Hi I am stored binary data in one table,in For loop gets binary data one by one,below is my code in that
fadts is datatable contains 3 rows,when first time it works fine,second time when goes to fill data in dataadapter it throws error,

           For Each row1 As DataRow In fadts.Rows
                    callclearsql()
                    System.Threading.Thread.Sleep(2000)
                    Dim facons1 As New SqlConnection(My.Settings.CS)
                    facons1.Open()
                    Dim fadrs1 As New SqlDataAdapter("SELECT ID,DocumentExtension,DocumentName,[Document]  FROM FileStore  where ID=" & row1("ID").ToString & "", facons1)
                    Dim fadts1 As New DataTable
                    fadrs1.SelectCommand.CommandTimeout = 0
                    fadts1.Rows.Clear()
                    fadrs1.Fill(fadts1)' Here got Exception of type 'System.OutOfMemoryException' was thrown.

                    Writelog("above loop1.1")
Next

它只工作第一次循环，第二次抛出错误，[Document]列包含二进制数据。



请回复asap



问候

Aravind



我的尝试：



我对fadrs1，fadts1和sql连接进行了处理，清除和关闭，但即使它抛出错误。

It work only first loop,second time it throws error,[Document] column contains binary data.

Pls reply asap

Regards
Aravind

What I have tried:

I did dispose,clear and close for fadrs1,fadts1 and sql connection,but even it throws error.

推荐答案

谢谢，最后我找到了解决方案形成此链接，感谢MicroSoft

https://msdn.microsoft.com/en-us/library/87z0hy49(v = vs.110）.aspx

Thanks,finally i found solution form this link,Thanks MicroSoft
https://msdn.microsoft.com/en-us/library/87z0hy49(v=vs.110).aspx

这篇关于将sqldataadapter中的数据填充到VB.NET中包含二进制数据的数据表时出错的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！