Ajax ASP Web形式在网格中搜索

Question

我在一边发现了我的问题的实现，但我不知道为什么它不起作用。当我将一些价值放入文本框中时，它应该给我发回，但没有。

<asp:ScriptManager ID="ScriptManager1" runat="server" EnablePartialRendering="true" />
        <div>
            <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="txt" />
                </Triggers>
                <ContentTemplate>
                    <asp:TextBox runat="server" ID="TextBox1" AutoPostBack="true" OnTextChanged="txt_TextChanged"></asp:TextBox>
                    <asp:GridView runat="server" ID="GridView2">
                        <Columns>
                            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" ItemStyle-Font-Size="10px" />
                            <asp:BoundField DataField="regon" HeaderText="Regon" SortExpression="regon" ItemStyle-Font-Size="10px" />
                            <asp:BoundField DataField="nip" HeaderText="NIP" SortExpression="nip" ItemStyle-Font-Size="10px" />
                        </Columns>
                    </asp:GridView>
                </ContentTemplate>
            </asp:UpdatePanel>
        </div>

和代码背后：

protected void Page_Load(object sender, EventArgs e)
    {
        if (!IsPostBack)
        {
             txt.Attributes.Add("onkeyup", "javascript:setTimeout('__doPostBack('txt','')', 0)");
             string SelectCommand = "SELECT * " +
                 "  FROM client_inf WHERE amount > 1000";
             conn.Open();
             OleDbDataAdapter da = new OleDbDataAdapter(SelectCommand, conn);
             DataSet ds = new DataSet();
             da.Fill(ds);
             GridView1.DataSource = ds.Tables[0];
             GridView1.DataBind();
             conn.Close();
        }
    }
     protected void txt_TextChanged(object sender, EventArgs e)
    {
        if (txt.Text != "")
        {
            string SelectCommand = "SELECT * " +
                 "  FROM client_inf WHERE client_name Like '" + txt.Text + "%'"
             conn.Open();
             OleDbDataAdapter da = new OleDbDataAdapter(SelectCommand, conn);
             DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds.Tables[0];
            GridView1.DataBind();
            conn.Close();
        }
    }

http://www.infosearchshop.com/21-gridview-search-as search-as-you-type-with-ajax

Answer 1

我建议更新AsyncPostBackTrigger，如下所示，以将textbox = TextBox1的ID与AutoPostBack参考匹配，但是控件需要在UpdatePanel

之外

<asp:AsyncPostBackTrigger ControlID ="TextBox1" EventName ="TextChanged" />

我还建议尝试使用PostBackTrigger。这主要用于UpdatePanel内部的控件，该控件使完整的帖子向后

<asp:PostBackTrigger ControlID="TextBox1" />

Answer 2

textbox的ID和 gridview的ID 不匹配。

<div>
            <asp:UpdatePanel ID="UpdatePanel1" runat="server" UpdateMode="Conditional">
                <Triggers>
                    <asp:AsyncPostBackTrigger ControlID="txt" />
                </Triggers>
                <ContentTemplate>
                    <asp:TextBox runat="server" ID="txt" AutoPostBack="true" OnTextChanged="txt_TextChanged"></asp:TextBox>
                    <asp:GridView runat="server" ID="GridView1">
                        <Columns>
                            <asp:BoundField DataField="Name" HeaderText="Name" SortExpression="Name" ItemStyle-Font-Size="10px" />
                            <asp:BoundField DataField="regon" HeaderText="Regon" SortExpression="regon" ItemStyle-Font-Size="10px" />
                            <asp:BoundField DataField="nip" HeaderText="NIP" SortExpression="nip" ItemStyle-Font-Size="10px" />
                        </Columns>
                    </asp:GridView>
                </ContentTemplate>
            </asp:UpdatePanel>
        </div>

aspx.cs

protected void Page_Load(object sender, EventArgs e)
        {
            if (!IsPostBack)
            {
                txt.Attributes.Add("onkeyup", "javascript:setTimeout('__doPostBack('txt','')', 0)");
                GridView1.DataSource = GetDataSource();
                GridView1.DataBind();
            }
        }
        private DataTable GetDataSource()
        {
            var dt = new DataTable();
            dt.Columns.Add("Name", typeof(string));
            dt.Columns.Add("regon", typeof(string));
            dt.Columns.Add("nip", typeof(string));
            dt.Rows.Add("Name-1", "regon-1", "nip-1");
            dt.Rows.Add("Name-2", "regon-1", "nip-1");
            dt.Rows.Add("Name-3", "regon-1", "nip-1");
            dt.Rows.Add("Name-4", "regon-1", "nip-1");
            dt.Rows.Add("Name-5", "regon-1", "nip-1");
            dt.Rows.Add("Name-6", "regon-1", "nip-1");
            dt.Rows.Add("Name-7", "regon-1", "nip-1");
            return dt;
        }
        protected void txt_TextChanged(object sender, EventArgs e)
        {
            if (txt.Text != "")
            {
                GridView1.DataSource = GetDataSource();
                GridView1.DataBind();
            }
        }