C# 数组转换为DataTable 的三个方法代码,CSharp代码库,德仔网

代码语言
代码分类
【CSharp】 C# 数组转换为DataTable 的三个方法
作者:Dezai.CN / 发布于2011/8/22/ 557
<ol>
    <li class="alt"><span><span class="keyword">using</span><span> System; </span></span></li>
    <li><span><span class="keyword">using</span><span> System.Data; </span></span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">namespace</span><span> ArrayToDataTable </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span><span class="keyword">class</span><span> ArrayToDataTable </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span><span class="comment">/// <summary></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// 把一个一维数组转换为DataTable</span><span> </span></span></li>
    <li><span><span class="comment">/// </summary></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <param name="ColumnName">列名</param></span><span> </span></span></li>
    <li><span><span class="comment">/// <param name="Array">一维数组</param></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <returns>返回DataTable</returns></span><span> </span></span></li>
    <li><span><span class="comment">/// <remarks>柳永法 http://www.yongfa365.com/ </remarks></span><span> </span></span></li>
    <li class="alt"><span><span class="keyword">public</span><span> </span><span class="keyword">static</span><span> DataTable Convert(</span><span class="keyword">string</span><span> ColumnName, </span><span class="keyword">string</span><span>[] Array) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>DataTable dt = <span class="keyword">new</span><span> DataTable(); </span></span></li>
    <li><span>dt.Columns.Add(ColumnName, <span class="keyword">typeof</span><span>(</span><span class="keyword">string</span><span>)); </span></span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i = 0; i < Array.Length; i++) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>DataRow dr = dt.NewRow(); </span></li>
    <li class="alt"><span>dr[ColumnName] = Array[i].ToString(); </span></li>
    <li><span>dt.Rows.Add(dr); </span></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">return</span><span> dt; </span></span></li>
    <li><span>} </span></li>
    <li class="alt"></li>
    <li></li>
    <li class="alt"><span><span class="comment">/// <summary></span><span> </span></span></li>
    <li><span><span class="comment">/// 反一个M行N列的二维数组转换为DataTable</span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// </summary></span><span> </span></span></li>
    <li><span><span class="comment">/// <param name="ColumnNames">一维数组，代表列名，不能有重复值</param></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <param name="Arrays">M行N列的二维数组</param></span><span> </span></span></li>
    <li><span><span class="comment">/// <returns>返回DataTable</returns></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <remarks>柳永法 http://www.yongfa365.com/ </remarks></span><span> </span></span></li>
    <li><span><span class="keyword">public</span><span> </span><span class="keyword">static</span><span> DataTable Convert(</span><span class="keyword">string</span><span>[] ColumnNames, </span><span class="keyword">string</span><span>[,] Arrays) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>DataTable dt = <span class="keyword">new</span><span> DataTable(); </span></span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">foreach</span><span> (</span><span class="keyword">string</span><span> ColumnName </span><span class="keyword">in</span><span> ColumnNames) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>dt.Columns.Add(ColumnName, <span class="keyword">typeof</span><span>(</span><span class="keyword">string</span><span>)); </span></span></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i1 = 0; i1 < Arrays.GetLength(0); i1++) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>DataRow dr = dt.NewRow(); </span></li>
    <li><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i = 0; i < ColumnNames.Length; i++) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>dr[i] = Arrays[i1, i].ToString(); </span></li>
    <li class="alt"><span>} </span></li>
    <li><span>dt.Rows.Add(dr); </span></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">return</span><span> dt; </span></span></li>
    <li></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"></li>
    <li><span><span class="comment">/// <summary></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// 反一个M行N列的二维数组转换为DataTable</span><span> </span></span></li>
    <li><span><span class="comment">/// </summary></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <param name="Arrays">M行N列的二维数组</param></span><span> </span></span></li>
    <li><span><span class="comment">/// <returns>返回DataTable</returns></span><span> </span></span></li>
    <li class="alt"><span><span class="comment">/// <remarks>柳永法 http://www.yongfa365.com/ </remarks></span><span> </span></span></li>
    <li><span><span class="keyword">public</span><span> </span><span class="keyword">static</span><span> DataTable Convert(</span><span class="keyword">string</span><span>[,] Arrays) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>DataTable dt = <span class="keyword">new</span><span> DataTable(); </span></span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">int</span><span> a = Arrays.GetLength(0); </span></span></li>
    <li class="alt"><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i = 0; i < Arrays.GetLength(1); i++) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>dt.Columns.Add(<span class="string">"col"</span><span> + i.ToString(), </span><span class="keyword">typeof</span><span>(</span><span class="keyword">string</span><span>)); </span></span></li>
    <li><span>} </span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i1 = 0; i1 < Arrays.GetLength(0); i1++) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>DataRow dr = dt.NewRow(); </span></li>
    <li class="alt"><span><span class="keyword">for</span><span> (</span><span class="keyword">int</span><span> i = 0; i < Arrays.GetLength(1); i++) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>dr[i] = Arrays[i1, i].ToString(); </span></li>
    <li><span>} </span></li>
    <li class="alt"><span>dt.Rows.Add(dr); </span></li>
    <li><span>} </span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">return</span><span> dt; </span></span></li>
    <li class="alt"></li>
    <li><span>} </span></li>
    <li class="alt"></li>
    <li><span>} </span></li>
    <li class="alt"><span>} </span></li>
</ol>
<div>示例代码：</div>
<ol>
    <li class="alt"><span><span class="keyword">using</span><span> System; </span></span></li>
    <li><span><span class="keyword">using</span><span> System.Collections.Generic; </span></span></li>
    <li class="alt"><span><span class="keyword">using</span><span> System.ComponentModel; </span></span></li>
    <li><span><span class="keyword">using</span><span> System.Data; </span></span></li>
    <li class="alt"><span><span class="keyword">using</span><span> System.Drawing; </span></span></li>
    <li><span><span class="keyword">using</span><span> System.Text; </span></span></li>
    <li class="alt"><span><span class="keyword">using</span><span> System.Windows.Forms; </span></span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">namespace</span><span> ArrayToDataTable </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span><span class="keyword">public</span><span> partial </span><span class="keyword">class</span><span> Form1 : Form </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span><span class="keyword">public</span><span> Form1() </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>InitializeComponent(); </span></li>
    <li><span>} </span></li>
    <li class="alt"></li>
    <li><span><span class="keyword">private</span><span> </span><span class="keyword">void</span><span> button1_Click(</span><span class="keyword">object</span><span> sender, EventArgs e) </span></span></li>
    <li class="alt"><span>{ </span></li>
    <li><span>dataGridView1.DataSource = ArrayToDataTable.Convert(<span class="string">"haha"</span><span>, </span><span class="keyword">new</span><span> </span><span class="keyword">string</span><span>[] { </span><span class="string">"1"</span><span>, </span><span class="string">"2"</span><span>, </span><span class="string">"3"</span><span>, </span><span class="string">"4"</span><span>, </span><span class="string">"5"</span><span>, </span><span class="string">"6"</span><span> }); </span></span></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">private</span><span> </span><span class="keyword">void</span><span> button2_Click(</span><span class="keyword">object</span><span> sender, EventArgs e) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span><span class="keyword">string</span><span>[,] array3D = { </span></span></li>
    <li><span>{ <span class="string">"1"</span><span>, </span><span class="string">"数组转DataTable 1"</span><span>, </span><span class="string">"0"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"2"</span><span>, </span><span class="string">"数组转DataTable 2"</span><span>, </span><span class="string">"1"</span><span>}, </span></span></li>
    <li><span>{ <span class="string">"3"</span><span>, </span><span class="string">"数组转DataTable 3"</span><span>, </span><span class="string">"1"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"4"</span><span>, </span><span class="string">"数组转DataTable 4"</span><span>, </span><span class="string">"2"</span><span>}, </span></span></li>
    <li><span>{ <span class="string">"5"</span><span>, </span><span class="string">"数组转DataTable 5"</span><span>, </span><span class="string">"2"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"6"</span><span>, </span><span class="string">"数组转DataTable 6"</span><span>, </span><span class="string">"5"</span><span>}, </span></span></li>
    <li><span>}; </span></li>
    <li class="alt"><span>dataGridView1.DataSource = ArrayToDataTable.Convert(<span class="keyword">new</span><span> </span><span class="keyword">string</span><span>[] { </span><span class="string">"haha1"</span><span>, </span><span class="string">"haha2"</span><span>, </span><span class="string">"haha3"</span><span> }, array3D); </span></span></li>
    <li></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">private</span><span> </span><span class="keyword">void</span><span> button3_Click(</span><span class="keyword">object</span><span> sender, EventArgs e) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span><span class="keyword">string</span><span>[,] array3D = { </span></span></li>
    <li><span>{ <span class="string">"1"</span><span>, </span><span class="string">"数组转DataTable 1"</span><span>, </span><span class="string">"0"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"2"</span><span>, </span><span class="string">"数组转DataTable 2"</span><span>, </span><span class="string">"1"</span><span>}, </span></span></li>
    <li><span>{ <span class="string">"3"</span><span>, </span><span class="string">"数组转DataTable 3"</span><span>, </span><span class="string">"1"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"4"</span><span>, </span><span class="string">"数组转DataTable 4"</span><span>, </span><span class="string">"2"</span><span>}, </span></span></li>
    <li><span>{ <span class="string">"5"</span><span>, </span><span class="string">"数组转DataTable 5"</span><span>, </span><span class="string">"2"</span><span>}, </span></span></li>
    <li class="alt"><span>{ <span class="string">"6"</span><span>, </span><span class="string">"数组转DataTable 6"</span><span>, </span><span class="string">"5"</span><span>}, </span></span></li>
    <li><span>}; </span></li>
    <li class="alt"><span>dataGridView1.DataSource = ArrayToDataTable.Convert(array3D); </span></li>
    <li></li>
    <li class="alt"><span>} </span></li>
    <li></li>
    <li class="alt"><span><span class="keyword">private</span><span> </span><span class="keyword">void</span><span> linkLabel1_LinkClicked(</span><span class="keyword">object</span><span> sender, LinkLabelLinkClickedEventArgs e) </span></span></li>
    <li><span>{ </span></li>
    <li class="alt"><span>System.Diagnostics.Process.Start(<span class="string">"Iexplore.exe"</span><span>, </span><span class="string">"http://www.yongfa365.com/"</span><span>); </span></span></li>
    <li><span>} </span></li>
    <li class="alt"><span>} </span></li>
    <li><span>} </span></li>
</ol>
<div></div>
试试其它关键字
　数组转换为DataTable　
同语言下
可能有用的
Dezai.CN贡献的其它代码(4037)