本文共 4304 字,大约阅读时间需要 14 分钟。
using System; using System.Data; namespace ArrayToDataTable { class ArrayToDataTable { ///调用/// 把一个一维数组转换为DataTable /// 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; } ////// 反一个M行N列的二维数组转换为DataTable /// 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; } ////// 反一个M行N列的二维数组转换为DataTable /// 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/"); } } }
转载地址:http://fxjal.baihongyu.com/