List<Customer> list = new List<Customer>(); list.Add(new Customer() {Name = "Nancy", Country = "Japan", City = "Tokyo"}); list.Add(new Customer() {Name = "Janet", Country = "Japan", City = "Sendai",}); list.Add(new Customer() {Name = "Rose", Country = "Japan", City = "Tokyo",}); list.Add(new Customer() {Name = "Buchanan", Country = "Japan", City = "Osaka",}); list.Add(new Customer() {Name = "Leverling", Country = "Japan", City = "Tokyo",}); list.Add(new Customer() {Name = "Gavin", Country = "China", City = "Beijing",}); list.Add(new Customer() {Name = "Victoria", Country = "China", City = "Xi'An",}); list.Add(new Customer() {Name = "Apple", Country = "China", City = "Beijing",}); list.Add(new Customer() {Name = "Tim", Country = "China", City = "Beijing",}); list.Add(new Customer() {Name = "John", Country = "China", City = "Xi'An",}); gcSpreadGrid1.ItemsSource = list; LayoutTemplate template1 = new LayoutTemplate(); template1.ColumnDefinitions.Add(new TemplateColumnDefinition() {Width = 80}); template1.ColumnDefinitions.Add(new TemplateColumnDefinition() {Width = 120}); //Set row template's layout template1.RowTemplate = new RowTemplate(); template1.RowTemplate.RowCount = 2; template1.RowTemplate.Cells.Add(new CellTemplate() {DataColumnName = "Name", ColumnIndex = 0, RowIndex = 0, RowSpan = 2}); template1.RowTemplate.Cells.Add(new CellTemplate() {DataColumnName = "Country", ColumnIndex = 1, RowIndex = 0}); template1.RowTemplate.Cells.Add(new CellTemplate() {DataColumnName = "City", ColumnIndex = 1, RowIndex = 1}); //set column header template's layout template1.ColumnHeaderTemplate = new RowTemplate(); template1.ColumnHeaderTemplate.RowCount = 1; template1.ColumnHeaderTemplate.Cells.Add(new CellTemplate() {DataColumnName = "Name", ColumnIndex = 0, RowIndex = 0}); template1.ColumnHeaderTemplate.Cells.Add(new CellTemplate() {DataColumnName = "City", ColumnIndex = 1, RowIndex = 0}); gcSpreadGrid1.LayoutTemplate = template1; gcSpreadGrid1.LayoutMode = LayoutMode.Template;
Dim list As New List(Of Customer)() list.Add(New Customer() With { _ .Name = "Nancy", _ .Country = "Japan", _ .City = "Tokyo" _ }) list.Add(New Customer() With { _ .Name = "Janet", _ .Country = "Japan", _ .City = "Sendai" _ }) list.Add(New Customer() With { _ .Name = "Rose", _ .Country = "Japan", _ .City = "Tokyo" _ }) list.Add(New Customer() With { _ .Name = "Buchanan", _ .Country = "Japan", _ .City = "Osaka" _ }) list.Add(New Customer() With { _ .Name = "Leverling", _ .Country = "Japan", _ .City = "Tokyo" _ }) list.Add(New Customer() With { _ .Name = "Gavin", _ .Country = "China", _ .City = "Beijing" _ }) list.Add(New Customer() With { _ .Name = "Victoria", _ .Country = "China", _ .City = "Xi'An" _ }) list.Add(New Customer() With { _ .Name = "Apple", _ .Country = "China", _ .City = "Beijing" _ }) list.Add(New Customer() With { _ .Name = "Tim", _ .Country = "China", _ .City = "Beijing" _ }) list.Add(New Customer() With { _ .Name = "John", _ .Country = "China", _ .City = "Xi'An" _ }) gcSpreadGrid1.ItemsSource = list Dim template1 As New LayoutTemplate() template1.ColumnDefinitions.Add(New TemplateColumnDefinition() With { _ .Width = 80 _ }) template1.ColumnDefinitions.Add(New TemplateColumnDefinition() With { _ .Width = 120 _ }) 'Set row template's layout template1.RowTemplate = New RowTemplate() template1.RowTemplate.RowCount = 2 template1.RowTemplate.Cells.Add(New CellTemplate() With { _ .DataColumnName = "Name", _ .ColumnIndex = 0, _ .RowIndex = 0, _ .RowSpan = 2 _ }) template1.RowTemplate.Cells.Add(New CellTemplate() With { _ .DataColumnName = "Country", _ .ColumnIndex = 1, _ .RowIndex = 0 _ }) template1.RowTemplate.Cells.Add(New CellTemplate() With { _ .DataColumnName = "City", _ .ColumnIndex = 1, _ .RowIndex = 1 _ }) 'set column header template's layout template1.ColumnHeaderTemplate = New RowTemplate() template1.ColumnHeaderTemplate.RowCount = 1 template1.ColumnHeaderTemplate.Cells.Add(New CellTemplate() With { _ .DataColumnName = "Name", _ .ColumnIndex = 0, _ .RowIndex = 0 _ }) template1.ColumnHeaderTemplate.Cells.Add(New CellTemplate() With { _ .DataColumnName = "City", _ .ColumnIndex = 1, _ .RowIndex = 0 _ }) gcSpreadGrid1.LayoutTemplate = template1 gcSpreadGrid1.LayoutMode = LayoutMode.Template
System.Object
GrapeCity.Windows.SpreadGrid.LayoutTemplate