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

最新推荐文章于 2024-08-14 13:02:48 发布

weixin_34032792

最新推荐文章于 2024-08-14 13:02:48 发布

阅读量284

点赞数

CC 4.0 BY-SA版权

文章标签： c#

原文链接：http://www.cnblogs.com/lqsilly/archive/2013/05/06/3062664.html

本文提供了一个使用 C# 向 DataTable 中插入数据并进行行列转换的例子。通过实例代码展示了如何创建 DataTable，添加列，并插入行数据。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

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;
        }
    }
}