自动完成对asp.net中多个表单字段的操作? [英] Autocomplete action to multiple form fields in asp.net ?
本文介绍了自动完成对asp.net中多个表单字段的操作?的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
嗨
我正在使用自动完成JS for textboxs.for第一个文本框它正常工作,但当我曾经为另一个texbox执行相同的代码时它不起作用。请检查我的代码如下
hi
i am using auto complete JS for to textboxs.for the first textbox its working properly but when i used to do the same code for the another texbox its not working. please check my code is below
<script type="text/javascript">
$(document).ready(function () {
SearchText();
});
function SearchText() {
$(".autosuggest").autocomplete({
source: function (request, response) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetAutoCompleteData",
data: "{'username':'" + document.getElementById('txtSearch').value + "'}",
dataType: "json",
success: function (data) {
response(data.d);
},
error: function (result) {
alert("Error");
}
});
}
});
}
</script>
<script type="text/javascript">
$(document).ready(function () {
SearchText();
});
function SearchText() {
$(".autosuggest1").autocomplete({
source: function (request, response) {
$.ajax({
type: "POST",
contentType: "application/json; charset=utf-8",
url: "Default.aspx/GetAutoCompleteData1",
data: "{'username1':'" + document.getElementById('txtSearch2').value + "'}",
dataType: "json",
success: function (data) {
response(data.d);
},
error: function (result) {
alert("Error");
}
});
}
});
}
</script>
<div class="span12">
<input id="txtSearch2" class="autosuggest1 span5" style="height: 30px;" type="text" placeholder="Photography Style,Occasion,Category">
<input style="height: 30px;" type="text" id="txtSearch" class="autosuggest span5" placeholder="Location: City">
<button type="submit" style="margin-top: -11px;" class="btn btn-warning btn-large">
Search </button>
</div>
C#代码
C# code is
[WebMethod]
public static List<string> GetAutoCompleteData(string username)
{
List<string> result = new List<string>();
using (SqlConnection con = new SqlConnection("Data Source=192.168.10.120;Initial Catalog=XXXX;User ID=XXX;password=XXX"))
{
using (SqlCommand cmd = new SqlCommand("select top 10 city from tbl_City where city LIKE '%'+@SearchText+'%'", con))
{
con.Open();
cmd.Parameters.AddWithValue("@SearchText", username);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
result.Add(dr["city"].ToString());
}
return result;
}
}
}
[WebMethod]
public static List<string> GetAutoCompleteData1(string username1)
{
List<string> result = new List<string>();
using (SqlConnection con = new SqlConnection("Data Source=192.168.10.120;Initial Catalog=XXXX;User ID=XXX;password=XXX"))
{
using (SqlCommand cmd = new SqlCommand("select top 10 Category from Category where city LIKE '%'+@SearchText+'%'", con))
{
con.Open();
cmd.Parameters.AddWithValue("@SearchText", username1);
SqlDataReader dr = cmd.ExecuteReader();
while (dr.Read())
{
result.Add(dr["city"].ToString());
}
return result;
}
}
}
推荐答案
( document )。ready( function (){
SearchText();
});
function SearchText(){
(document).ready(function () { SearchText(); }); function SearchText() {
( 。autosuggest)。autocomplete({
source: function (request,response){
(".autosuggest").autocomplete({ source: function (request, response) {
.ajax({
type: POST,
contentType: application / json; charset = utf-8,
url: Default.aspx / GetAutoCompleteData,
data: {'username':' + document .getElementById (' txtSearch')。value + '},
dataType: < span class =code-string> json,
成功: function (数据){
response(data.dd );
},
错误: function (结果){
alert( 错误);
}
});
}
});
}
< / script>
< script type = text / javascript>
.ajax({ type: "POST", contentType: "application/json; charset=utf-8", url: "Default.aspx/GetAutoCompleteData", data: "{'username':'" + document.getElementById('txtSearch').value + "'}", dataType: "json", success: function (data) { response(data.d); }, error: function (result) { alert("Error"); } }); } }); } </script> <script type="text/javascript">
这篇关于自动完成对asp.net中多个表单字段的操作?的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文