玉祥平台客服-15087858732

标题: DataTable的一个简单的扩展 [打印本页]

作者: zoroseo2020 时间: 2020-5-11 12:50
提示: 作者被禁止或删除内容自动屏蔽

作者: Adam丶鱼 时间: 2020-7-26 19:11
标题: DataTable的一个简单的扩展
/// <summary>
/// DataTable扩展类
/// </summary>
public static class DataTableExtensions
{
/// <summary>
/// 显示DataTable的结构信息
/// </summary>
/// <param name="table">datatable</param>
public static void LoadDataTableStructure(this DataTable table)
{
      if (table == null)
      {
         System.Diagnostics.Debug.WriteLine("datatable is null.");
      }

      StringBuilder structureInfo = new StringBuilder();
      string colName = string.Empty;
      string colType = string.Empty;

      structureInfo.AppendLine("============================Begin=============================");
      structureInfo.AppendLine("TableName: " + table.TableName);
      structureInfo.AppendLine(string.Format("{0,-20}{1}", "ColumnName", "DataType"));

      foreach (DataColumn col in table.Columns)
      {
         colName = col.ColumnName;
         colType = col.DataType.ToString();
         structureInfo.AppendLine(string.Format("{0,-20}{1}", colName, colType));
      }

      structureInfo.AppendLine("=============================End==============================");
      System.Diagnostics.Debug.WriteLine(structureInfo.ToString());
}
}

作者: Adam丶鱼 时间: 2020-7-26 19:11

作者: fteair 时间: 2020-7-28 14:09

欢迎光临玉祥平台客服-15087858732 (http://bbs.delit.cn/)