将可见列从datatable导出到xml [英] exporting visible column from datatable to xml

问题描述

我只需要将可见列从datatable导出到xml，我有这个代码

I need to export only visible columns from datatable to xml, I have this code

DataTable dt = new DataTable();

foreach (DataGridViewColumn col in dg1.Columns)
{
    dt.Columns.Add(col.HeaderText);
}

foreach (DataGridViewRow row in dg1.Rows)
{
    DataRow dRow = dt.NewRow();

    foreach (DataGridViewCell cell in row.Cells)
    {
        dRow[cell.ColumnIndex] = cell.Value;
    }
    dt.Rows.Add(dRow);
}

DataSet ds = new DataSet();
ds.Tables.Add(dt);
ds.WriteXml(saveFileDialog1.FileName);

它适用但所有列

it works but for all columns

推荐答案

看到我回答的一个非常相似的问题你昨天？



将可见的datagridview列导出到csv [ ^ ]

See a very similar question I answered for you yesterday?

exporting visible columns of datagridview to csv[^]

这篇关于将可见列从datatable导出到xml的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！