#region 将一维数组转化成DataTable函数 ///
/// 将一维数组转化成DataTable函数 /// ///
///
public static DataTable ConvertString(string[] Array) { DataTable dt = new DataTable(); dt.Columns.Add(column0_name, typeof(string)); dt.Columns.Add(column1_name, typeof(string)); dt.Columns.Add(column2_name, typeof(string)); dt.Columns.Add(column3_name, typeof(string)); dt.Columns.Add(column4_name, typeof(string)); dt.Columns.Add(column5_name, typeof(string)); DataRow dr = dt.NewRow(); dr[column0_name] = Array[10].ToString(); dr[column1_name] = Array[5].ToString(); dr[column2_name] = Array[6].ToString(); dr[column3_name] = Array[7].ToString(); dr[column4_name] = Array[8].ToString(); dr[column5_name] = Array[9].ToString(); dt.Rows.Add(dr); return dt; } #endregion #region 二维数组转DataTable类型的函数 ///
/// 将二维数组转化成DataTable函数 /// ///
///
private DataTable DTableConvert(string[] ColumnNames, string[,] Array) { DataTable dt = new DataTable(); foreach (string ColumnName in ColumnNames) { dt.Columns.Add(ColumnName,typeof(string)); } for (int i = 0; i < Array.GetLength(0); i++) { DataRow dr = dt.NewRow(); for (int j = 0; j < ColumnNames.Length; j++) { dr[i] = Array[i, j].ToString(); } dt.Rows.Add(dr); } return dt; } #endregion
数组转DataTable的实现
最新推荐文章于 2024-01-09 16:06:43 发布