alert(eventArgs.get_value())返回所选文本,而不是ID
alert(eventArgs.get_value()) returning selected text and not the ID
我正在使用下面的代码用自动完成填充文本框,当选择时,它不会给我行ID,而是只给我选择的文本。alert(eventArgs.get_value())没有返回SQL中行的实际ID的原因是什么?
<script language="javascript" type="text/javascript">
function getSelected(source, eventArgs) {
alert(eventArgs.get_value())
}
</script>
Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
AutoCompleteExtender.OnClientItemSelected = "getSelected"
End Sub
Public Function GetCompletionList(prefixText As String, count As Integer, ByVal contextKey As String) As String()
Try
Dim Con As SqlConnection
Dim cmd As SqlCommand
Con = New SqlConnection
Dim test As String
test = contextKey
Con.ConnectionString = ""
Con.Open()
cmd = New SqlCommand
cmd.Connection = Con
'cmd.CommandText = "SELECT NPI, [Entity Type Code], [Provider Last Name (Legal Name)], [Provider First Name], [Provider Business Mailing Address City Name] FROM NPIData WHERE [Provider Last Name (Legal Name)] LIKE @Provider + '%' AND [Provider Business Mailing Address City Name] = @State"
cmd.CommandText = "SELECT NPI, [Entity Type Code], [Provider Last Name (Legal Name)], [Provider First Name], [Provider Business Mailing Address City Name], [Provider Business Mailing Address State Name], [Provider Business Mailing Address Postal Code] FROM NPIData WHERE ([Provider Business Mailing Address State Name] = @State) AND ([Provider Last Name (Legal Name)] LIKE N'%' + @Provider + N'%') ORDER BY [Provider First Name]"
cmd.Parameters.AddWithValue("@Provider", prefixText)
cmd.Parameters.AddWithValue("@State", contextKey)
Dim customers As List(Of String) = New List(Of String)
Dim reader As SqlDataReader = cmd.ExecuteReader()
While reader.Read
customers.Add(reader("Provider Last Name (Legal Name)").ToString + ", " + reader("Provider First Name").ToString + " " + reader("Provider Business Mailing Address City Name").ToString + ", " + reader("Provider Business Mailing Address State Name").ToString + " " + reader("Provider Business Mailing Address Postal Code").ToString)
End While
Con.Close()
Return customers.ToArray
Catch ex As Exception
End Try
它没有返回行ID,因为您没有在AutoExtender中填充它,您只给了它一个文本值,而不是底层值。客户应该这样填充(假设NPI是您的行id?)
customers.Add(AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(
reader("NPI").ToString,
reader("Provider Last Name (Legal Name)").ToString + ", "
+ reader("Provider First Name").ToString + " " + reader("Provider Business Mailing Address City Name").ToString + ", "
+ reader("Provider Business Mailing Address State Name").ToString + " " + reader("Provider Business Mailing Address Postal Code").ToString))
相关文章:
- 根据选项卡内部的文本链接中的哈希ID动态选择jqueryUI选项卡
- JavaScript-onClick将按钮ID或单击按钮的文本传递给函数
- 如何在Jquery函数中为自动完成文本区域指定一个变量作为Id
- 从id标记中的文本进行检查,并将类添加到另一个标记中
- Javascript:获取具有动态id的文本框值
- 更改错误文本“用户 ID 或密码不正确”
- 获取带有 jQuery 中的文本值的 AN LI 的 ID
- 从 li 获取文本和 id 值
- 对具有相同 id 的多个元素进行文本验证
- 修复Javascript代码以将文本中的所有Youtube链接转换为Youtube ID功能
- 除了类、id 和文本之外,我还如何在 jQuery 中的元素中传递变量
- 在按键时检索文本区域的 ID
- 如何将文本插入到几个带有 id 的文本区域中的一个文本区域中
- 使用纯JS点击即可从li元素中获取文本和id
- 使用javascript/jQuery获取文本id
- 在加载模式中从输入文本id获取img src
- 如何获取选定的文本id,并用javascript替换保持标签完整的文本
- 如何获取动态创建的文本框的动态输入文本id
- 当使用Javascript克隆表行时,增加我的输入文本id
- 动态创建输入文本 ID,并在 JavaScript 中获取它并在 UI 中加载值