如何在asp.net c＃中使用javascript和3层架构创建自动完成文本框 [英] How to create autocomplete textbox using javascript and 3 tier architecture in asp.net c#

问题描述

在下面的代码中如何编写业务逻辑层类。

In below code how to write in business logic layer class.

[WebMethod]
       public static string[] GetAutoCompleteData(string Address)
       {
           List<string> request = new List<string>();
           using (SqlConnection conn = new SqlConnection())
           {
               conn.ConnectionString = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
               using (SqlCommand cmd = new SqlCommand())
               {
                   cmd.CommandText = "select Address,Latitute,Longitute from Locations where " + "Address like @SearchText + '%'";
                   cmd.Parameters.AddWithValue("@SearchText", Address);
                   cmd.Connection = conn;
                   conn.Open();
                   using (SqlDataReader sdr = cmd.ExecuteReader())
                   {
                       while (sdr.Read())
                       {
                           request.Add(string.Format("{0}-{1}-{2}",sdr["Address"],sdr["Latitute"],sdr["Longitute"]));
                       }
                   }
                   conn.Close();
               }
               return request.ToArray();
           }
       }

推荐答案

Hi Ankit，



我认为以下链接具有您想要的完全相同的解决方案：

http://www.aspsnippets.com/Articles/jQuery-UI-AutoComplete-TextBox-with-Database-in-ASPNet.aspx [< a href =http://www.aspsnippets.com/Articles/jQuery-UI-AutoComplete-TextBox-with-Database-in-ASPNet.aspx\"target =_ blanktitle =New Window> ^ ]



您也可以查看以下链接：

http://www.aspdotnet-pools.com/2014/06/autocomplete-textbox-in-aspnet-with.html [< a href =http://www.aspdotnet-pools.com/2014/06/autocomplete-textbox-in-aspnet-with.htmltarget =_ blanktitle =New Window> ^ ]



问候，

Praneet

Hi Ankit,

I think the following link has exactly the same solution as you want:
http://www.aspsnippets.com/Articles/jQuery-UI-AutoComplete-TextBox-with-Database-in-ASPNet.aspx[^]

You can also check this link:
http://www.aspdotnet-pools.com/2014/06/autocomplete-textbox-in-aspnet-with.html[^]

Regards,
Praneet

这篇关于如何在asp.net c＃中使用javascript和3层架构创建自动完成文本框的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！