数组转DataTable

 

using System;using System.Data;namespace ArrayToDataTable{    class ArrayToDataTable    {        /// <summary>        /// 把一个一维数组转换为DataTable        /// </summary>        public static DataTable Convert(string ColumnName, string[] Array)        {            DataTable dt = new DataTable();            dt.Columns.Add(ColumnName, typeof(string));            for (int i = 0; i < Array.Length; i++)            {                DataRow dr = dt.NewRow();                dr[ColumnName] = Array[i].ToString();                dt.Rows.Add(dr);            }            return dt;        }        /// <summary>        /// 反一个M行N列的二维数组转换为DataTable        /// </summary>        public static DataTable Convert(string[] ColumnNames, string[,] Arrays)        {            DataTable dt = new DataTable();            foreach (string ColumnName in ColumnNames)            {                dt.Columns.Add(ColumnName, typeof(string));            }            for (int i1 = 0; i1 < Arrays.GetLength(0); i1++)            {                DataRow dr = dt.NewRow();                for (int i = 0; i < ColumnNames.Length; i++)                {                    dr[i] = Arrays[i1, i].ToString();                }                dt.Rows.Add(dr);            }            return dt;        }        /// <summary>        /// 反一个M行N列的二维数组转换为DataTable        /// </summary>        public static DataTable Convert(string[,] Arrays)        {            DataTable dt = new DataTable();            int a = Arrays.GetLength(0);            for (int i = 0; i < Arrays.GetLength(1); i++)            {                dt.Columns.Add("col" + i.ToString(), typeof(string));            }            for (int i1 = 0; i1 < Arrays.GetLength(0); i1++)            {                DataRow dr = dt.NewRow();                for (int i = 0; i < Arrays.GetLength(1); i++)                {                    dr[i] = Arrays[i1, i].ToString();                }                dt.Rows.Add(dr);            }            return dt;        }    }}

调用

using System;   using System.Collections.Generic;   using System.ComponentModel;   using System.Data;   using System.Drawing;   using System.Text;   using System.Windows.Forms;     namespace ArrayToDataTable   {       public partial class Form1 : Form      {           public Form1()           {              InitializeComponent();           }           private void button1_Click(object sender, EventArgs e)           {               dataGridView1.DataSource = ArrayToDataTable.Convert("haha", new string[] { "1", "2", "3", "4", "5", "6" });           }           private void button2_Click(object sender, EventArgs e)             {               string[,] array3D = {                                    { "1", "数组转DataTable 1", "0"},                                    { "2", "数组转DataTable 2", "1"},                                    { "3", "数组转DataTable 3", "1"},                                    { "4", "数组转DataTable 4", "2"},                                    { "5", "数组转DataTable 5", "2"},                                   { "6", "数组转DataTable 6", "5"},                                    };               dataGridView1.DataSource = ArrayToDataTable.Convert(new string[] { "haha1", "haha2", "haha3" }, array3D);           }           private void button3_Click(object sender, EventArgs e)           {               string[,] array3D = {                                    { "1", "数组转DataTable 1", "0"},                                    { "2", "数组转DataTable 2", "1"},                                    { "3", "数组转DataTable 3", "1"},                                    { "4", "数组转DataTable 4", "2"},                                    { "5", "数组转DataTable 5", "2"},                                    { "6", "数组转DataTable 6", "5"},                                    };               dataGridView1.DataSource = ArrayToDataTable.Convert(array3D);           }           private void linkLabel1_LinkClicked(object sender, LinkLabelLinkClickedEventArgs e)           {               System.Diagnostics.Process.Start("Iexplore.exe", "http://www.yongfa365.com/");           }       }   }