How to change the DataTable Column Name?

Question

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

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

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

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".

Moon · Accepted Answer · 2011-06-21T01:11:47.553

296

Try this:

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

edited Jun 21 '11 at 01:11

answered Jun 20 '11 at 05:47

Moon

33,439
20
81
132

1

Hi, I tried this solution but somehow my data gets lost when I change the column name. – Bat_Programmer Oct 20 '11 at 03:25
2

I just tried this solution now and it works fine - it did not do any changes or wipe out the underlying column data. Maybe something else is happening in your code... – AshesToAshes Aug 15 '13 at 15:25
1

what if the original name 'Marks' can contain whitespace? – Laurence Oct 12 '14 at 20:13

score 31 · Answer 2 · edited Aug 15 '13 at 15:25

31

Rename the Column by doing the following:

dataTable.Columns["ColumnName"].ColumnName = "newColumnName";

edited Aug 15 '13 at 15:25

AshesToAshes

937
3
14
31

answered Jun 20 '11 at 05:52

Saurabh

5,661
2
26
32

score 7 · Answer 3 · answered Mar 13 '18 at 08:38

7

Use:

dt.Columns["Name"].ColumnName = "xyz";
dt.AcceptChanges();

or

dt.Columns[0].ColumnName = "xyz";
dt.AcceptChanges();

answered Mar 13 '18 at 08:38

Subhash Saini

254
4
5

score 6 · Answer 4 · answered Feb 05 '15 at 07:31

6

 dtTempColumn.Columns["EXCELCOLUMNS"].ColumnName = "COLUMN_NAME";                        
 dtTempColumn.AcceptChanges();

answered Feb 05 '15 at 07:31

Hardik Shah

186
1
6

2

What does your additional code do here? Adding comments would help. – nawfal Feb 08 '18 at 01:43

score 1 · Answer 5 · answered Jun 14 '18 at 10:49

try this

"columns": [
{data: "id", name: "aaa", sortable: false},
{data: "userid", name: "userid", sortable: false},
{data: "group_id", name: "group_id", sortable: false},
{data: "group_name", name: "group_name", sortable: false},
{data: "group_member", name: "group_member"},
{data: "group_fee", name: "group_fee"},
{data: "dynamic_type", name: "dynamic_type"},
{data: "dynamic_id", name: "dynamic_id"},
{data: "content", name: "content", sortable: false},
{data: "images", name: "images", sortable: false},
{data: "money", name: "money"},
{data: "is_audit", name: "is_audit", sortable: false},
{data: "audited_at", name: "audited_at", sortable: false}

]

Pankaj Agarwal · Answer 6 · 2011-06-20T06:22:19.463

after generating XML you can just Replace your XML <Marks>... content here </Marks> tags with <SubjectMarks>... content here </SubjectMarks>tag. and pass updated XML to your DB.

Edit: I here explain complete process here.

Your XML Generate Like as below.

<NewDataSet>
      <StudentMarks> 
          <StudentID>1</StudentID>
          <CourseID>100</CourseID>
          <SubjectCode>MT400</SubjectCode>
          <Marks>80</Marks>
      </StudentMarks>
      <StudentMarks> 
          <StudentID>1</StudentID>
          <CourseID>100</CourseID>
          <SubjectCode>MT400</SubjectCode>
          <Marks>79</Marks>
      </StudentMarks>
      <StudentMarks> 
          <StudentID>1</StudentID>
          <CourseID>100</CourseID>
          <SubjectCode>MT400</SubjectCode>
          <Marks>88</Marks>
      </StudentMarks>
  </NewDataSet>

Here you can assign XML to string variable like as

string strXML = DataSet.GetXML();

strXML = strXML.Replace ("<Marks>","<SubjectMarks>");
strXML = strXML.Replace ("<Marks/>","<SubjectMarks/>");

and now pass strXML To your DB. Hope it will help for you.

score 0 · Answer 7 · answered Aug 23 '16 at 06:38

0

Use this

dataTable.Columns["OldColumnName"].ColumnName = "NewColumnName";

answered Aug 23 '16 at 06:38

Anurag Deokar

840
7
13

How to change the DataTable Column Name?

7 Answers7

Linked