- using System;
- using System.Data;
-
- namespace ArrayToDataTable
- {
- class ArrayToDataTable
- {
-
-
-
-
-
-
-
- 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;
- }
-
-
-
-
-
-
-
-
-
- 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;
-
- }
-
-
-
-
-
-
-
-
- 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./");
- }
- }
- }
演示及ArrayToDataTable类下载地址:ArrayToDataTable.rar
原创作者:柳永法(yongfa365)'Blog |
|