• 连接数据库智能感知


    前台代码:

    <head runat="server">
        <title></title>
        <link href="js/jquery.autocomplete.css" rel="stylesheet" type="text/css" />
        <script src="js/Jquery1.7.js" type="text/javascript"></script>
        <script src="js/jquery.autocomplete.js" type="text/javascript"></script>
        <script src="js/jquery.autocomplete.pack.js" type="text/javascript"></script>
        <script type="text/javascript">
            $(function () {
                $.ajax({
                    type: "post",
                    contentType: "application/json",
                    url: "WebService1.asmx/getGoods",
                    data: "{}",
                    success: function (result) {
                        var array = new Array();
                        for (var i = 0; i < result.d.length; i++) {
                            array.push(result.d[i]);
                        }
                        $('#txtQuery').autocomplete(array);
                    }
                })
            })

        </script>
    </head>
    <body>
        <form id="form1" runat="server">
        <div>
            <asp:TextBox ID="txtQuery" runat="server"></asp:TextBox>
        </div>
        </form>
    </body>

    -------------------------WebServices-----------------------------

    namespace WebApplication1
    {
        /// <summary>
        /// WebService1 的摘要说明
        /// </summary>
        [WebService(Namespace = "http://tempuri.org/")]
        [WebServiceBinding(ConformsTo = WsiProfiles.BasicProfile1_1)]
        [System.ComponentModel.ToolboxItem(false)]
        // 若要允许使用 ASP.NET AJAX 从脚本中调用此 Web 服务,请取消对下行的注释。
         [System.Web.Script.Services.ScriptService]
        public class WebService1 : System.Web.Services.WebService
        {

            [WebMethod]
            public string HelloWorld()
            {
                return "Hello World";
            }

            [WebMethod]
            public List<string> getGoods()
            {
                List<string> list = new List<string>();
                if (Context.Cache["goods"] == null)
                {
                    string conStr = ConfigurationManager.ConnectionStrings["strcon"].ConnectionString;
                    SqlConnection conn = new SqlConnection(conStr);
                    conn.Open();
                    SqlCommand cmd = conn.CreateCommand();
                    cmd.CommandText = "select T_GoodsTitle from T_Goods";
                    SqlDataReader reader = cmd.ExecuteReader();
                    while (reader.Read())
                    {
                        list.Add(reader["T_GoodsTitle"].ToString());
                    }
                    Context.Cache["goods"] = list;
                }
                else {
                    list = Context.Cache["goods"] as List<string>;
                }
                return list;
            }


        }
    }

  • 相关阅读:
    【JS】【8】拼接字符串
    【JS】【7】获取粘贴板的内容
    【Eclipse】【3】checkstyle插件
    【Eclipse】【2】遇到的问题
    android手机短信监听器,监听到的短信发送到web服务器,完整源码分享
    android手机号归属地查下案例源码
    免费web api接口大全
    android读取远程图片案例
    android向web提交参数的4种方式总结,附带网站案例源码
    csu 10月 月赛 B 题 Scoop water
  • 原文地址:https://www.cnblogs.com/qiqiBoKe/p/3134733.html
Copyright © 2020-2023  润新知