Spread Silverlight Documentation
GetDataColumnName Method
Example 


The column index for which the name is requested.
Gets the column name at the specified position.
Syntax
'Declaration
 
Public Function GetDataColumnName( _
   ByVal column As System.Integer _
) As System.String
'Usage
 
Dim instance As Worksheet
Dim column As System.Integer
Dim value As System.String
 
value = instance.GetDataColumnName(column)
public System.string GetDataColumnName( 
   System.int column
)

Parameters

column
The column index for which the name is requested.

Return Value

Returns the column name for data binding.
Exceptions
ExceptionDescription
System.IndexOutOfRangeException Specified index is out of range; must be between 0 and the total number of columns.
Example
This example uses the GetDataColumnName method.
public class lname
        {
            public string last { get; set; }
            public int val { get; set; }
            public lname(string last, int val)
            {
                this.last = last;
                this.val = val;
            }
        }

lname[] arr = new lname[] { new lname("Smith", 100), new lname("Fender", 3), new lname("Gill", 5) };
GcSpreadSheet1.Sheets[0].DataSource = arr;
GcSpreadSheet1.Sheets[0].BindDataColumn(1, "last");
GcSpreadSheet1.Sheets[0].BindDataColumn(0, "val");
TextBox1.Text = GcSpreadSheet1.Sheets[0].GetDataColumnName(0);
Public Class lname
        Public Property last() As String
            Get
                Return m_last
            End Get
            Set(value As String)
                m_last = Value
            End Set
        End Property
        Private m_last As String
        Public Property val() As Integer
            Get
                Return m_val
            End Get
            Set(value As Integer)
                m_val = Value
            End Set
        End Property
        Private m_val As Integer
        Public Sub New(last As String, val As Integer)
            Me.last = last
            Me.val = val
        End Sub
    End Class

Dim arr As lname() = New lname() {New lname("Smith", 100), New lname("Fender", 3), New lname("Gill", 5)}
GcSpreadSheet1.Sheets(0).DataSource = arr
GcSpreadSheet1.Sheets(0).BindDataColumn(1, "last")
GcSpreadSheet1.Sheets(0).BindDataColumn(0, "val")
TextBox1.Text = GcSpreadSheet1.Sheets(0).GetDataColumnName(0)
Requirements

Target Platforms: Windows 7, Windows 8 Desktop, Windows Vista SP1 or later, Windows Server 2000, Windows 2000 Professional, Windows XP Professional, Windows NT 4.0 Workstation, SP6, Windows NT 4.0 Server, SP6

See Also

Reference

Worksheet Class
Worksheet Members

 

 


Copyright © GrapeCity, inc. All rights reserved.