C# 向DataTable中插入伪造DataTable数据及实现DataTable行列转换

using System;
using System.Collections.Generic;
using System.ComponentModel;
using System.Data;
using System.Drawing;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using System.Windows.Forms;

namespace Demo
{
    public partial class FormDataTable : Form
    {
        public FormDataTable()
        {
            InitializeComponent();
            dgvOld.DataSource = InsertFakeData();
            dgvNew.DataSource = ChangeRowCol();
        }
        /// <summary>
        /// C# 向DataTable中插入伪造DataTable数据
        /// </summary>
        private DataTable InsertFakeData()
        {
            DataTable table = new DataTable("Datas");
            try
            {
                table.Columns.Add("ID", Type.GetType("System.Int32"));
                table.Columns[0].AutoIncrement = true;
                table.Columns[0].AutoIncrementSeed = 1;
                table.Columns[0].AutoIncrementStep = 1;
                table.Columns.Add("Product", Type.GetType("System.String"));
                table.Columns.Add("Count", Type.GetType("System.Int32"));
                table.Columns.Add("Version", Type.GetType("System.String"));
                table.Columns.Add("Description", Type.GetType("System.String"));

                DataRow newRow;
                newRow = table.NewRow();
                newRow["Product"] = "水果刀";
                newRow["Count"] = 30;
                newRow["Version"] = "2.0";
                newRow["Description"] = "打架专用";
                table.Rows.Add(newRow);

                //newRow = table.NewRow();
                //newRow["Product"] = "折叠凳";
                //newRow["Count"] = 35;
                //newRow["Version"] = "3.0";
                //newRow["Description"] = "行走江湖七武器之一";
                //table.Rows.Add(newRow);

            }
            catch (Exception ex)
            {
                throw new Exception("错误信息：" + ex.Message + ex.StackTrace);
            }
            return table;
           
        }
        /// <summary>
        /// 实现行列切换转换
        /// </summary>
        /// <returns></returns>
        private DataTable ChangeRowCol()
        {
            DataTable dt = InsertFakeData();
            DataTable result = new DataTable();
            result.Columns.Add("A", typeof(string));
            result.Columns.Add("B",Type.GetType("System.String"));
            if (dt != null && dt.Rows.Count > 0)
            {
                foreach (DataColumn dc in dt.Columns)
                {
                    DataRow dr = result.NewRow();
                    dr[0] = dc.ColumnName;
                    if (dt.Rows[0][dc.ColumnName] == DBNull.Value)
                    {
                        dr[1] = 0;
                    }
                    else
                    {
                        dr[1] = dt.Rows[0][dc.ColumnName];
                    }
                    result.Rows.Add(dr);
                }
            }
            else
            {
                if (dt != null)
                {
                    foreach (DataColumn dc in dt.Columns)
                    {
                        DataRow dr = result.NewRow();
                        dr[0] = dc.ColumnName;
                        dr[1] = 0;
                        result.Rows.Add(dr);
                    }
                }
            }
            return result;
        }
    }
}

运行结果如下图:

转载于:https://www.cnblogs.com/lqsilly/archive/2013/05/06/3062664.html