To map a data table to columns in a list
Create the DataTable at the class level.
Dim table As System.Data.DataTable = New System.Data.DataTable("Employees")
System.Data.DataTable table = new System.Data.DataTable("Employees");
Add sample columns and data in the Startup event handler of the Sheet1 class (in a document-level project) or ThisAddIn class (in an application-level project).
table.Columns.Add("Id", GetType(Int32))
table.Columns.Add("FirstName", GetType(String))
table.Columns.Add("LastName", GetType(String))
table.Columns.Add("Title", GetType(String))
table.Rows.Add(1, "Nancy", "Anderson", "Sales Representative")
table.Rows.Add(2, "Robert", "Brown", "Sales Representative")
table.Columns.Add("Id", typeof(int));
table.Columns.Add("FirstName", typeof(string));
table.Columns.Add("LastName", typeof(string));
table.Columns.Add("Title", typeof(string));
table.Rows.Add(1, "Nancy", "Anderson", "Sales Representative");
table.Rows.Add(2, "Robert", "Brown", "Sales Representative");
Call the SetDataBinding method and pass in the column names in the order they should appear. The list object will be bound to the newly-created DataTable, but the order of the columns in the list object will differ from the order they appear in the DataTable.
Me.List1.AutoSetDataBoundColumnHeaders = True
Me.List1.SetDataBinding(table, "", "Title", "LastName", "FirstName")
this.list1.AutoSetDataBoundColumnHeaders = true;
this.list1.SetDataBinding(table, "", "Title", "LastName", "FirstName");
Specifying Unmapped Columns
When you map columns to a DataTable, you can also specify that certain columns should not be bound to data by passing in an empty string. A new column that is not bound to data is then added to the ListObject control.
To specify an unmapped column when mapping ListObject columns
This code example assumes you have an existing ListObject named list1 on the worksheet in which this code appears.
Tasks
Concepts
Other Resources