时间戳

首页 > 解决方案 > 如何将数据gridview导出到xml

c# - 如何将数据gridview导出到xml

问题描述

您好我正在尝试使用 XDocument 将数据网格视图保存到 XML 文件，但问题是当我单击导出按钮时，数据网格视图变得清晰并且导出的 XML 文件为空

此按钮从多个文本框填充 datagridview：

 private void add_Click(object sender, EventArgs e)
 {
     int n = dataGridView1.Rows.Add();

     dataGridView1.Rows[n].Cells[0].Value = txtOne.Text;
     dataGridView1.Rows[n].Cells[1].Value = txtTwo.Text;
     dataGridView1.Rows[n].Cells[2].Value = txtThree.Text; 
 }

此按钮导出为 XML：

private void Export_Click(object sender, EventArgs e)
{

const string FILENAME = @"c:\temp\test.xml";
XDocument doc = new XDocument(
new XDeclaration("1.0", "ISO-8859-1", null),
new XElement("root",    
    dt.AsEnumerable().Select(row => new XElement("child", new object[]{
            new XElement("one",row[0]),
            new XElement("two",row[1]),
            new XElement("three",row[2]),
            }));


dataGridView1.DataSource = dt;
doc.Save(FILENAME);
SaveFileDialog saveFileDialog1 = new SaveFileDialog();
saveFileDialog1.InitialDirectory = Convert.ToString(Environment.SpecialFolder.MyDocuments);
saveFileDialog1.Filter = "File Name |*.xml";
saveFileDialog1.FilterIndex = 1;
if (saveFileDialog1.ShowDialog() == DialogResult.OK)
{
    doc.Save(saveFileDialog1.FileName);
}

标签： c#parsingxml-parsing

解决方案

如果要从中读取所有数据DataGridView并导出到XDocument，则必须使用两个周期来读取所有行和所有单元格。

private void ExportButton_Click(object sender, EventArgs e)
{
    var columnHeaders = (from DataGridViewColumn column in dataGridView1.Columns select column.HeaderText).ToArray();

    var xDoc = new XDocument(
        new XDeclaration("1.0", "ISO-8859-1", null),
        new XElement("root"));

    foreach (DataGridViewRow row in dataGridView1.Rows)
    {
        if (row.IsNewRow)
            continue;

        var xRow = new XElement("row");

        foreach (DataGridViewCell cell in row.Cells)
        {
            xRow.Add(new XElement(columnHeaders[cell.ColumnIndex], cell.Value));
        }

        xDoc.Element("root")?.Add(xRow);
    }

    xDoc.Save(@"d:\tmp\test.xml");
}

如果需要，您可以saveFileDialog从对话框中添加和设置文件名

推荐阅读