Hi All,
I am having an issue with Autocomplete extender, its completionlist item having value containing '-' sign, but in completeextender its giving dirty value...
Plz find details as below:
<asp:TextBox ID="txtMAWBNo" AutoPostBack="true" runat="server" Width="90px">
<cc2:AutoCompleteExtender ID="AutoCompleteExtender2" runat="server" TargetControlID="txtMAWBNo"
EnableCaching="true" ServicePath="~/AutoComplete.asmx" ServiceMethod="getMAWBNOFORSBUpdate"
DelimiterCharacters=";, :"
MinimumPrefixLength="2" CompletionListHighlightedItemCssClass="SelectedItem"
CompletionListItemCssClass="ItemListWidth" CompletionListCssClass="ListCss" önClientPopulated="AjaxAutoCompleteTooltip">
And in web service code as:
<webmethod()> _
<Script.Services.ScriptMethod()> _
Public Function getMAWBNOFORSBUpdate(ByVal prefixText As String, ByVal count As Integer) As Array
Dim strCommand As String = Nothing
Dim ReturnArr As New ArrayList
Dim dtReturn As DataTable = Nothing
Try
strCommand = "select Distinct isnull(MBLNo,'') as MBLNo from tbl_EximEntExportSeaMasterBooking where _Deleted=0 AND MBLNo like '%" & prefixText & "%' and ISNULL(IsBVC,0)=1 order by MBLNo"
objCommon = New DMLControl.SQLControl
dtReturn = objCommon.FetchDataTable(strCommand, clsSQLConnection.ConnectionString)
With dtReturn
For i As Integer = 0 To .Rows.Count - 1
ReturnArr.Add(Convert.ToString(.Rows(i).Item("MBLNo")))
Next
End With
Return ReturnArr.ToArray
Catch ex As Exception
End Try
Return ReturnArr.ToArray
End Function
MBLNo has value 75-01060 but its showing -485 in autocomplete extender..
Can someone help me out plz.....
Thanks...