如何为逗号分隔的多个值实现自动完成文本框？ [英] How to implement autocomplete textbox for multi values separated by comma?

问题描述

此代码返回一个值，但我想在文本框中显示为123,224,456,786。



我尝试了什么：

this code returning one value, but I want display as 123,224,456,786 in textbox.

What I have tried:

[System.Web.Script.Services.ScriptMethod()]
    [System.Web.Services.WebMethod(EnableSession = true)]
    public static List<string> employeeid(string prefixText, int count)
    {
        OracleConnection con = new OracleConnection(ConfigurationManager.ConnectionStrings["Conn"].ConnectionString.ToString());
        DataTable dtbl = new DataTable();
        OracleDataAdapter da = new OracleDataAdapter();
        List<string> Empid = new List<string>();
        try
        {
            string str = "select '3'|| emp_code || '0' as empcode from empmaster where '3'|| emp_code || '0' like '" + prefixText + "%'";
            dtbl = new DataTable();
            da = new OracleDataAdapter(str, con);
            if (con.State == ConnectionState.Closed)
            {
                con.Open();
            }
            da.Fill(dtbl);
            for (int i = 0; i < dtbl.Rows.Count; i++)
            {
                Empid.Add(dtbl.Rows[i]["empcode"].ToString());
            }

            return Empid;
        }
        catch (Exception ex)
        {
            throw ex;
        }

    }

推荐答案

您的方法返回包含字符串值的对象[List]。您所要做的就是解析列表如下：

例如：

var result = String.Join（，，new List< string> {'1'， '2'，'3'，'4'，'5'}）

Your method returns object [List] containing string values. All you have do is parse the list as below :
eg:
var result = String.Join(",", new List<string> { '1', '2', '3', '4', '5' })

这篇关于如何为逗号分隔的多个值实现自动完成文本框？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！