VB.NET中的数据集到CSV [英] Dataset to CSV in VB.NET

问题描述

我需要将数据从 DataSet 导出为包含标题的CSV格式。我的数据集将有超过100条记录，所以我只想将10条记录导出到CSV文件。



我尝试导出到CSV文件，但所有数据来自导出数据集。



有没有办法只导出10条记录（10条记录是用户选择，它可以是10或20，......）



谢谢，

Imran

解决方案

如果您循环浏览记录并逐个导出它们，那么应该做一些简单的事情：

 对于 i 作为 整数 =  0    ExportCount  -   1  
导出（MyDataSet.Tables（ 0 ）。行（i））
 下一步 

或者，试试移动s要导出到第二个数据集并导出的记录的ubset。但是，如果没有看到你的代码，很难给出有意义的答案。

& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; LT;代码&放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; GT; cscscscscscsc&安培;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; LT;&安培;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; GT;&放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; LT;代码&放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; GT;&安培;放大器;放大器;放大器;放大器;放大器;放大器; amp; amp; amp; amp; amp; amp; amp lang =& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; GT;&放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; LT; / A&安培& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; &安培;放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; GT;&放大器;放大器;放大器;放大器;放大器;放大器;放大器;放大器; LT; / A&放大器;放大器;放大器;放大器;放大器;放大器放大器;& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; ;安培;放大器;放大器; LT; / A&上午p; amp; amp; amp; amp; gt;]c＃& amp; amp; amp; amp; gt;& amp; amp; amp; lt; pre lang =c＃& amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp; amp;& amp; amp; amp; lt; pre lang =c＃& amp; amp; amp; gt;& amp; amp; lt; pre lang =c＃& amp; amp; gt;& amp; amp; lt; pre lang =c＃& amp; amp; amp;& amp; amp; lt; pre lang =c＃& amp; amp;& amp; lt; pre lang =c＃& amp; gt;& amp; lt; pre lang =c＃& amp; gt;& amp; lt; pre lang =c＃& amp; gt;& amp; lt; pre lang =c＃& gt;& lt; pre lang =c＃& gt;& lt; pre lang =c＃& gt;& lt; pre lang = java& gt;& lt; pre lang =java& gt;& lt; pre lang =java& gt;& lt; pre lang =java>< small> <大><预>< /预>< /大>< /小>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /预>< /代码>< /代码>

Hi,

I need to export data from DataSet to CSV format with headers. My dataset will have more that 100 records, so I want only 10 records to be exported to CSV file.

I tried exporting to CSV file, but all the data from dataset is exported.

Is there any way to export only 10 records (10 records is a user choice, it can be 10 or 20,...)

Thanks,
Imran

解决方案

If you are looping through the records and exporting them one by one, it should be a simple matter of doing something like:

For i As Integer = 0 To ExportCount - 1
    Export(MyDataSet.Tables(0).Rows(i))
Next

Or, try moving the subset of records you want to export into a second dataset and exporting that. But without seeing your code, it is difficult to give a meaningful answer.

&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;code&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;cscscscscscsc&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;code&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;pre lang=&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;a href=""&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;/a&amp;amp;amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;amp;amp;lt;a href=""&amp;amp;amp;amp;amp;amp;amp;amp;gt;&amp;amp;amp;amp;amp;amp;amp;lt;/a&amp;amp;amp;amp;amp;amp;gt;[&amp;amp;amp;amp;amp;amp;lt;a href="" target="_blank"&amp;amp;amp;amp;amp;gt;^&amp;amp;amp;amp;lt;/a&amp;amp;amp;amp;gt;]"c#"&amp;amp;amp;amp;gt;&amp;amp;amp;lt;pre lang="c#"&amp;amp;amp;gt;&amp;amp;amp;lt;pre lang="c#"&amp;amp;amp;gt;&amp;amp;lt;pre lang="c#"&amp;amp;gt;&amp;amp;lt;pre lang="c#"&amp;amp;gt;&amp;amp;lt;pre lang="c#"&amp;gt;&amp;lt;pre lang="c#"&amp;gt;&amp;lt;pre lang="c#"&amp;gt;&amp;lt;pre lang="c#"&amp;gt;&amp;lt;pre lang="c#"&gt;&lt;pre lang="c#"&gt;&lt;pre lang="c#"&gt;&lt;pre lang="java"&gt;&lt;pre lang="java"&gt;&lt;pre lang="java"&gt;&lt;pre lang="java"><small><big><pre></pre></big></small></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></pre></code></code>

这篇关于VB.NET中的数据集到CSV的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！