Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
<tr>
<td colspan="2">
<span style="font-weight:bold">Enter Last Name, First Name:</span>
<asp:TextBox ID="txtFindName" runat="server" Width="250px" />
<asp:AutoCompleteExtender ID="AutoCompleteExtender1" runat="server"
TargetControlID="txtFindName" ServiceMethod="FindNameSID"
MinimumPrefixLength="3" ServicePath="~/User/AutoComplete.asmx" />
<asp:TextBoxWatermarkExtender ID="TextBoxWatermarkExtender1"
runat="server" TargetControlID="txtFindName"
WatermarkCssClass="WtrMrk" WatermarkText="SNUFFY JOE" />
<asp:LinkButton ID="btnFindNameAdd" runat="server" Text="Add to Roster" ToolTip="Click to Add Member to Roster" />
</td>
</tr>
<WebMethod()> _
Public Function FindNameSID(ByVal prefixText As String, ByVal count As String) As String()
Dim items As New List(Of String)
sql = "SELECT name_ind FROM OPENQUERY(SIDPERS, 'Select name_ind from pers_person_tbl where name_ind like ''%" & prefixText & "%''')"
myDataTable = New DataTable
myDataTable = getData(sql)
If myDataTable.Rows.Count > 0 Then
For Each dRow As DataRow In myDataTable.Rows
items.Add(dRow(0).ToString)
Next
End If
Return items.ToArray
End Function
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
From novice to tech pro — start learning today.
Open in new window