ServicePath Property

Visual Basic
C#

'Declaration
 
Public Property ServicePath As String

'Usage
 
Dim instance As AutoCompleteCellType
Dim value As String
 
instance.ServicePath = value
 
value = instance.ServicePath

public string ServicePath {get; set;}

Property Value

String containing the name of the Web service path

This property determines the path to the Web service from which the extender pulls the word or sentence completions. If this is not provided, the service method should be a page method.

This example uses a Web service for an automatic completion cell.

C#

FarPoint.Web.Spread.Extender.AutoCompleteCellType ac = new FarPoint.Web.Spread.Extender.AutoCompleteCellType();
ac.BackgroundImageUrl = null;
ac.CompletionInterval = 1000;
ac.CompletionSetCount = 5;
ac.DelimiterCharacters = ";, :";
AjaxControlToolkit.TextBoxWatermarkExtender twe = new AjaxControlToolkit.TextBoxWatermarkExtender();
twe.WatermarkText = "Type a character";
ac.Extenders.Add(twe);
ac.ServicePath = "WebService.asmx";
ac.ServiceMethod = "GetAllNames";
ac.MinimumPrefixLength = 1;
ac.EnableCaching = true;
ac.ShowEditor = true;
FpSpread1.ActiveSheetView.Cells[0, 0].CellType = ac;

public class WebService : System.Web.Services.WebService {
    
        [WebMethod]

  public  string[] GetAllNames(string prefixText, int count)
  {
        ArrayList filteredList = new ArrayList();
        string[] names = {"AzamSharp","Scott","Alex","Mary","John","Ali","Sam","Sammy"};
        foreach (string name in names)
        {
                if (name.ToLower().StartsWith(prefixText.ToLower()))
                filteredList.Add(name);
        }
        return (string[]) filteredList.ToArray(typeof(string));
  }
}

Visual Basic

Dim ac As New FarPoint.Web.Spread.Extender.AutoCompleteCellType
ac.BackgroundImageUrl = Nothing
ac.CompletionInterval = 1000
ac.CompletionSetCount = 5
ac.DelimiterCharacters = ";, :"
Dim twe As New AjaxControlToolkit.TextBoxWatermarkExtender
twe.WatermarkText = "Type a character"
ac.Extenders.Add(twe)
ac.ServicePath = "WebService.asmx"
ac.ServiceMethod = "GetAllNames"
ac.MinimumPrefixLength = 1
ac.EnableCaching = True
ac.ShowEditor = True
FpSpread1.ActiveSheetView.Cells(0, 0).CellType = ac

Public Class WebService
     Inherits System.Web.Services.WebService

    <WebMethod()>
    Public Function GetAllNames(ByVal prefixText As String, ByVal count As Integer) As String()
        Dim filteredList As ArrayList = New ArrayList
        Dim names() As String = {"AzamSharp", "Scott", "Alex", "Mary", "John", "Ali", "Sam", "Sammy"}

        For Each name As String In names
            If name.ToLower.StartsWith(prefixText.ToLower) Then
                filteredList.Add(name)
            End If
        Next
        Return CType(filteredList.ToArray(GetType(System.String)), String())
    End Function

End Class

Reference

AutoCompleteCellType Class
AutoCompleteCellType Members