如何更改数据表列名？ [英] How to change the DataTable Column Name?

问题描述

我有一个DataTable，其中有四个列，例如

I have one DataTable which has four columns such as

 StudentID        CourseID          SubjectCode            Marks    
------------     ----------        -------------          --------
    1               100              MT400                  80
    2               100              MT400                  79
    3               100              MT400                  88

这里我将此数据表插入到Sql中

Here I am inserting this Datatable into the Sql server table by passing this datatable as an XML Table.

我只想将DataTable列名 Marks更改为 SubjectMarks，并将此DataTable作为XML表传递

I just want to Change the DataTable Column Name "Marks" as "SubjectMarks" and pass this DataTable as an XML Table.

我知道如何将DataTable作为XML表传递。但是我不知道如何将DataTable列名 Marks更改为 SubjectMarks。

I know how to pass the DataTable as an XML Table. But I dont know, How to change the DataTable Column Name "Marks" as "SubjectMarks".

推荐答案

请尝试以下操作：

dataTable.Columns["Marks"].ColumnName = "SubjectMarks";

这篇关于如何更改数据表列名？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！