DataSet ds = new DataSet();
ds.ReadXml(@"test.xml");
foreach (DataTable dataTable in ds.Tables)
{
DataGridView dataGridView = new DataGridView();
dataGridView.Dock = DockStyle.Top;
dataGridView.DataSource = dataTable;
dataGridView.AutoSizeColumnsMode = DataGridViewAutoSizeColumnsMode.DisplayedCells;
dataGridView.AutoSizeRowsMode = DataGridViewAutoSizeRowsMode.None;
dataGridView.AllowUserToOrderColumns = true;
dataGridView.AllowUserToResizeColumns = true;
Controls.Add(dataGridView);
Label label = new Label();
label.Text = dataTable.TableName;
label.Dock = DockStyle.Top;
Controls.Add(label);
}
Read dataset's XML and display all contained tables
- Details
- Written by: Stanko Milosev
- Category: Windows Forms
- Hits: 1417
I have saved an XML with DataSet.WriteXml, then I wanted to display values of that XML in a DataGridView, where each DataTable contained in that XML will create new DataGridView: