自动完成jQuery函数返回内部服务器错误同时呼吁web服务 [英] Autocomplete Jquery function returning Internal Server Error while calling webservice

问题描述

我的工作，需要当一些数据输入和数据将从数据库中提取到文本框自动完成一个项目。

I am working on a project that requires to autocomplete textbox when some data is inputted and the data will be fetched from a database.

有关这个我创建了一个Web服务的 -

For this I created a webservice as -

    [WebService(Namespace = "http://tempuri.org/")]
[WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
//[ToolboxItem(false)]
// To allow this Web Service to be called from script, using ASP.NET AJAX, uncomment the following line. 
[ScriptService]
public class SearchIssues : System.Web.Services.WebService
{
    //[ScriptMethod]      
    [WebMethod]
    public string[] GetCompletionList(string prefixText)
    {
        DataSet ds = null;
        DataTable dt = null;
        OracleConnection conn = null;
        StringBuilder sb = new StringBuilder();
        try
        {
            conn = new OracleConnection(WebConfigurationManager.ConnectionStrings["Conn"].ToString());
            sb.Append("select issueno from cet_sepcet where issueno like '");
            sb.Append(prefixText);
            sb.Append("%'");
            OracleDataAdapter daRes = new OracleDataAdapter(sb.ToString(), conn);
            ds = new DataSet();
            daRes.Fill(ds);
            dt = ds.Tables[0];
        }         
        catch (Exception exc)
        {

        }

        if (conn.State == ConnectionState.Open)
        {
            conn.Close();
        }
        List<string> IssueList = new List<string>();
        for (int i = 0; i < dt.DataSet.Tables[0].Rows.Count; i++)
        {
            IssueList.Add(dt.DataSet.Tables[0].Rows[i][0].ToString());
        }
        return IssueList.ToArray();
    }
}

我写了jQuery AJAX方法是 -

The jquery ajax method I wrote is as -

         $(function() {
        $(".tb").autocomplete({
            source: function(request, response) {               
            debugger;
                $.ajax({
                    url: "SearchIssues.asmx/GetCompletionList",
                    data: request.term,
                    dataType: "json",
                    type: "POST",
                    contentType: "application/json; charset=utf-8",
                    dataFilter: function(data) { return data; },
                    success: function(data) {
                        response($.map(data.d, function(item) {
                            return {
                                value: item                           
                            }
                        }))
                        //alert('Hello');
                    },
                    error: function(XMLHttpRequest, textStatus, errorThrown) {
                     debugger;
                        alert(errorThrown);
                    }
                });
            },
            minLength: 1
        });
    });

WebService的运行完全正常。但问题是当我尝试调用从.aspx页面中的web服务。它会引发内部服务器错误。

The webservice is running perfectly fine. But the problem comes when I try to call the webservice from the .aspx page. Its throws Internal server error.

我不知道是我要去的地方错了。请帮助。

I am not sure as where I am going wrong. Kindly help.

在此先感谢。
AKHIL

Thanks in advance. Akhil

推荐答案

我建议你使用萤火虫来检查是否安置自己的请求和响应这种方式，你可以很容易地调试您的应用程序。

I advice you to use firebug to check whether your Post requests and responses this way you can easily debug your application.

本之一 AJAX

  data: request.term,

应该是实际

  data:  "{'prefixText':'" + request.term+ "'}",

您服务，期待 prefixText 字符串作为parmeter，我假设 request.term 是价值

Your service is expecting prefixText string as a parmeter, I assume request.term is the value.

更新

我不知道是不是在你的工作到底该为我的作品：

I dont know what is not working at your end this works for me :

        <script src="js/jquery-1.4.2.min.js" type="text/javascript"></script>
        <script src="js/jquery-ui-1.8.custom.min.js" type="text/javascript"></script>
        <link href="http://ajax.googleapis.com/ajax/libs/jqueryui/1.8/themes/base/jquery-ui.css" rel="stylesheet" type="text/css"/>

        <script type="text/javascript">
            $(document).ready(function() {          
               $("input#autocomplete").autocomplete({
                source: function (request, response) {
                    $.ajax({
                        url: "/Service/WSDataService.asmx/GetStatesWithAbbr",
                        data: "{'name':'" + $(autocomplete).val() + "'}",
                        dataType: "json",
                        type: "POST",
                        contentType: "application/json; charset=utf-8",
                        dataFilter: function (data) { return data; },
                        success: function (data) {
                            response($.map(data.d, function (item) {
                                return {
                                    label: item.Name,
                                    value: item.Name
                                }
                            }))
                        }
                    });
                },
                minLength: 1
              });
            });
        </script>

...

     <input id="autocomplete" />

服务：

   [WebMethod]        
    public List<State> GetStatesWithAbbr(string name)
    {
        List<State> sbStates = new List<State>();
        //Add states to the List
       }

这篇关于自动完成jQuery函数返回内部服务器错误同时呼吁web服务的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！