如何更改 DataTable 列名称？

小开

最佳答案

试试这个:

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

小开

通过执行以下操作重命名列:

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

小开

在生成 XML 之后，您只需将 XML <Marks>... content here </Marks>标记替换为 <SubjectMarks>... content here </SubjectMarks>tag。并将更新后的 XML 传递给数据库。

编辑: 我在这里解释完整的过程在这里。

生成的 XML 如下所示。

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

在这里，您可以将 XML 分配给字符串变量，如

string strXML = DataSet.GetXML();


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

现在将 strXML 传递到数据库。希望对你有所帮助。

小开

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

小开

用这个

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

小开

用途:

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

或者

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

小开

试试这个

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

]