MESCIUS SPREAD for ASP.NET 10.0J
SetSortIndicator メソッド (BaseSheetAxisModel)

行または列のインデックス
ソートインジケータの値
指定した行または列にソートインジケータを設定します (この実装は何もしません)。
構文
'Declaration
 
Public Overridable Sub SetSortIndicator( _
   ByVal index As Integer, _
   ByVal value As SortIndicator _
) 
public virtual void SetSortIndicator( 
   int index,
   SortIndicator value
)

パラメータ

index
行または列のインデックス
value
ソートインジケータの値
この例では、指定した列のソートインジケータを返します。
DataTable tblMain = new DataTable();
int i;
tblMain = new DataTable();
tblMain.Columns.Add("ColA");
tblMain.Columns.Add("ColB");
for (i = 1; i <=99; i++)
{
   DataRow r = tblMain.NewRow();
   r[0] = "A " + i.ToString();
   r[1] = "B " + i.ToString();
   tblMain.Rows.Add(r);
}
FpSpread1.DataSource = tblMain;
FpSpread1.ActiveSheetView.AllowSort = true;
 
FarPoint.Web.Spread.Model.BaseSheetAxisModel b;
FarPoint.Web.Spread.Model.SortIndicator si;
b = (FarPoint.Web.Spread.Model.BaseSheetAxisModel)FpSpread1.ActiveSheetView.ColumnAxisModel;
b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending);
si = b.GetSortIndicator(0);
Response.Write(si.ToString());
Dim tblMain As New DataTable
Dim i As Integer
tblMain = New DataTable
tblMain.Columns.Add("ColA")
tblMain.Columns.Add("ColB")
For i = 1 To 99
   Dim r As DataRow = tblMain.NewRow()
   r(0) = "A " + i.ToString()
   r(1) = "B " + i.ToString()
   tblMain.Rows.Add(r)
Next i
FpSpread1.DataSource = tblMain
FpSpread1.ActiveSheetView.AllowSort = True

Dim b As FarPoint.Web.Spread.Model.BaseSheetAxisModel
Dim si As FarPoint.Web.Spread.Model.SortIndicator
b = FpSpread1.ActiveSheetView.ColumnAxisModel
b.SetSortIndicator(0, FarPoint.Web.Spread.Model.SortIndicator.Descending)
si = b.GetSortIndicator(0)
Response.Write(si.ToString()) 
参照

BaseSheetAxisModel クラス
BaseSheetAxisModel メンバ
GetSortIndicator メソッド

 

 


© MESCIUS inc. All rights reserved.