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

User · Answer

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

User · Answer

Use this   dataTable Columns  OldColumnName   ColumnName    NewColumnName

User · Answer

Use   dt Columns  Name   ColumnName    xyz   dt AcceptChanges      or  dt Columns 0  ColumnName    xyz   dt AcceptChanges

User · Answer

Rename the Column by doing the following   dataTable Columns  ColumnName   ColumnName    newColumnName

User · Answer

dtTempColumn Columns  EXCELCOLUMNS   ColumnName    COLUMN NAME                            dtTempColumn AcceptChanges

User · Answer

Try this      dataTable Columns  Marks   ColumnName    SubjectMarks

User · Answer

after generating XML you can just Replace your XML  lt Marks gt     content here  lt  Marks gt  tags with  lt SubjectMarks gt     content here  lt  SubjectMarks gt tag  and pass updated XML to your DB   Edit  I here explain complete process here   Your XML Generate Like as below    lt NewDataSet gt         lt StudentMarks gt              lt StudentID gt 1 lt  StudentID gt             lt CourseID gt 100 lt  CourseID gt             lt SubjectCode gt MT400 lt  SubjectCode gt             lt Marks gt 80 lt  Marks gt         lt  StudentMarks gt         lt StudentMarks gt              lt StudentID gt 1 lt  StudentID gt             lt CourseID gt 100 lt  CourseID gt             lt SubjectCode gt MT400 lt  SubjectCode gt             lt Marks gt 79 lt  Marks gt         lt  StudentMarks gt         lt StudentMarks gt              lt StudentID gt 1 lt  StudentID gt             lt CourseID gt 100 lt  CourseID gt             lt SubjectCode gt MT400 lt  SubjectCode gt             lt Marks gt 88 lt  Marks gt         lt  StudentMarks gt     lt  NewDataSet gt    Here you can assign XML to string variable like as  string strXML   DataSet GetXML     strXML   strXML Replace    lt Marks gt     lt SubjectMarks gt     strXML   strXML Replace    lt Marks  gt     lt SubjectMarks  gt       and now pass strXML To your DB  Hope it will help for you

[c#] How to change the DataTable Column Name?

Examples related to c#

Examples related to asp.net

Examples related to ado.net

Examples related to datatable