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);
}
Example download from here without XML attached. Read dataset's XML and display all contained tables
- Details
- Written by: Stanko Milosev
- Category: Windows Forms
- Hits: 1505
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. Here I already gave one example of DataTables. Here is code: