如何在ajax-autocompleteextender中显示多个列 [英] how to show more than one column in 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;

推荐答案

请清除问题，我不明白你的问题，我想帮助你，首先你说你想用mem_id显示memname，但你返回值countryNames，然后你想要的地方显示memname和mem_id，plz快速回复

please clear the question, i am not understand ur question, i want to help u, first u say u want to display memname with mem_id, but u return the value countryNames, then where u want to display both memname and mem_id, plz reply soon

您好S.Rajendran，



1.在.aspx页面上播放代码

Hi S.Rajendran,

1.take code on your .aspx page

<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 =

get（' <％= hfMemId.ClientID％>' ）;

hdMemID.value = e.get_value（）;

}
< / script>

get('<%= hfMemId.ClientID %>'); hdMemID.value = e.get_value(); } </script>

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中显示多个列的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！