如何在ajax-autocompleteextender中显示多个列

本文介绍了如何在ajax-autocompleteextender中显示多个列的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

问题描述

我只能显示一列'mem_name'。我还要显示一个额外的列'mem_id'。谁能帮我吗。我的代码：

SqlCommand cmd = new SqlCommand（select * from member where mem_name like @Name +'％'，con）;

cmd.Parameters.AddWithValue（@ Name，prefixText）;

SqlDataAdapter da = new SqlDataAdapter（cmd）;

DataTable dt = new DataTable（）;

da.Fill（dt）;

List< string> CountryNames = new List< string>（）;

for（int i = 0; i< dt.Rows.Count; i ++）

{

CountryNames.Add（dt.Rows [i] [1] .ToString（））;

}

返回CountryNames;

I am able to show just one column 'mem_name'. I want to show an extra column 'mem_id' also. Can anyone help me out. My code:

SqlCommand cmd = new SqlCommand("select * from member where mem_name like @Name+'%'", con);
cmd.Parameters.AddWithValue("@Name", prefixText);
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataTable dt = new DataTable();
da.Fill(dt);
List<string> CountryNames = new List<string>();
for (int i = 0; i < dt.Rows.Count; i++)
{
CountryNames.Add(dt.Rows[i][1].ToString());
}
return CountryNames;

推荐答案

<asp:TextBox ID="_txtMem" runat="server" Width="150px" AutoPostBack="true" OnTextChanged="_txtMem_TextChanged"></asp:TextBox>

//添加具有至少这些属性的AutoCompleteExtender //

//add AutoCompleteExtender with atleast these properties//

<asp:AutoCompleteExtender ID="_txtBuy_AutoCompleteExtender" runat="server"

OnClientItemSelected="ClientItemSelectedMem">
</asp:AutoCompleteExtender>

<asp:HiddenField ID="hfMemId" runat="server" />

2.使用javascript

2.Use javascript

<script type="text/javascript">
        function ClientItemSelectedMem(sender, e) {

            var hdMemID =

3.将此代码放在_txtMem_TextChanged事件上.cs页面

3.place this code on _txtMem_TextChanged Event on .cs page

string MemId = "";
        string MemName = "";
        customerId = Request.Form[hfMemId.UniqueID];
        customerName = Request.Form[_txtMem.UniqueID];

4.使用这样的GetCompletionList方法

4.use GetCompletionList method like this

// Select member from database//
Member = aBal.SltMem(prefixText);
        if (Member.Count > 0)
        {
            foreach (string i in Member)
            {
                string[] splt = i.Split(',');
                string item = AjaxControlToolkit.AutoCompleteExtender.CreateAutoCompleteItem(splt[1].ToString(), splt[0].ToString());
                list.Add(item);
            }
        }
        else
        {
            list.Add("No Member Named " + prefixText + "");
        }
        return list.ToArray();
<pre>

这篇关于如何在ajax-autocompleteextender中显示多个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！

DT