如何检查数据表中的列名中是否有空格。 [英] how to check is there any space in the column names in a data table.

问题描述

如何检查数据表中列名中是否有空格。如果有空格需要替换那个没有空格的列名

how to check is there any space in the column names in a data table. if there is any space need to be replace that column name without space

推荐答案

using System;
using System.Collections.Generic;
using System.Text;

using System.Data.Common;
using System.Data;

namespace ConsoleApplication1
{
    class Program
    {
        static void Main(string[] args)
        {
            DataTable tbl = new DataTable();
            tbl.Columns.Add("Column A");
            tbl.Columns.Add("Column B");
            tbl.Columns.Add("Column C");
            tbl.Columns.Add("Column D");
            tbl.Columns.Add("Column E");

            Console.WriteLine("Before Change...");
            PrintColumnsName(tbl);

            foreach (DataColumn dcl in tbl.Columns)
            {
                if (dcl.ColumnName.Contains(" "))
                {
                    dcl.ColumnName = dcl.ColumnName.Replace(" ", "");
                }
            }

            tbl.AcceptChanges();

            Console.WriteLine("After Change...");
            PrintColumnsName(tbl);

            Console.WriteLine("Press a key to quit...");
            Console.ReadKey();
        }

        static void PrintColumnsName(DataTable t)
        {
            foreach (DataColumn dcl in t.Columns)
            {
                Console.WriteLine(dcl.ColumnName);
            }
        }
    }
}

DataTable 有一个 Columns 属性，你可以迭代： http://msdn.microsoft.com/en-us/library/system.data.datatable.columns.aspx [ ^ ]

DataTable has a Columns property which you can iterate through : http://msdn.microsoft.com/en-us/library/system.data.datatable.columns.aspx[^]

这篇关于如何检查数据表中的列名中是否有空格。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！