在C#SqlDataAdapter Fill中可以返回多少列是否有硬性限制? [英] Is there a hard limit as to how many columns can be returned in C# SqlDataAdapter Fill?

问题描述

我目前正在处理一个遗留项目，该遗留项目需要运行一些SQL才能获取一些数据.他们使用DataTables，DataSets等来处理数据.

I'm currently working on a legacy project that has some SQL needs to run to get some data. They use DataTables, DataSets, etc to work with the data.

正在执行的查询仅返回一行，但是它包含700多个列.

The query in question that gets executed only returns one row, however it contains well over 700 columns.

不幸的是，当代码执行以填充数据集时，如果查询包含655列以上，则不会返回任何内容.

Unfortunately when the code executes to fill the data set, if the query contains over 655 columns, nothing gets returned.

是否有一种方法可以解决此限制，因此，如果查询返回656+列，则将返回数据，还是有其他解决方法?

Is there a way to get around this limitation so if a query returns 656+ columns data will get returned or is there some other workaround?

谢谢！

追赶红鲱鱼.数据在那里，如果数据中有656+列，我只是无法在调试器中以表的形式查看它.观看者不能处理超过655个.

Chasing a red herring. The data is there, I just can't view it in the debugger as a table if there's 656+ columns in the data. The viewer can't handle more than 655.

推荐答案

数据在那里，如果数据中有656多个列，我只是无法在调试器中以表的形式查看它.观看者不能处理超过655个.

The data is there, I just can't view it in the debugger as a table if there's 656+ columns in the data. The viewer can't handle more than 655.

这篇关于在C#SqlDataAdapter Fill中可以返回多少列是否有硬性限制?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！