在GRIDVIEW中搜索 [英] SEARCH IN GRIDVIEW

问题描述

我正在尝试添加文本框，并且基于我在文本框中输入的值应该在gridview中进行.

这是我正在使用的代码

Hi,

i am trying to add a text box and based on the value i give in text box search should be done in gridview.

here is the code i am using

Partial Class _Default
    Inherits System.Web.UI.Page
    Dim str As String = ConfigurationManager.ConnectionStrings("constring").ConnectionString
    Dim sqlcon As New SqlConnection(str)
    Dim ds As New DataSet
    Protected Sub txtserach_TextChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles txtsearch.TextChanged
        Dim sqladapt As New SqlDataAdapter
        If txtsearch.Text = "" Then
            ''sqladapt = New SqlDataAdapter("SELECT * from Card_type", sqlcon)
            ''ds = New DataSet
            ''sqladapt.Fill(ds, "1")
            ''gdvsearch.DataSource = ds.Tables("1")
            sqladapt = New SqlDataAdapter("SELECT * from Card_type", sqlcon)
            sqladapt.Fill(ds)
            gdvsearch.DataSource = ds
            gdvsearch.DataBind()
        Else
            Dim sqlda As New SqlDataAdapter("SELECT * FROM Card_type WHERE membership_type like ''" + txtsearch.Text + "%''", sqlcon)
            ds = New DataSet
            sqlda.Fill(ds)
            gdvsearch.DataSource = ds
            gdvsearch.DataBind()
        End If
    End Sub

    Protected Sub Page_Load(ByVal sender As Object, ByVal e As System.EventArgs) Handles Me.Load
        Dim sqladapt As New SqlDataAdapter
        sqladapt = New SqlDataAdapter("SELECT * from Card_type", sqlcon)
        sqladapt.Fill(ds)
        gdvsearch.DataSource = ds
        gdvsearch.DataBind()
    End Sub

End Class

但是我得到结果，但是只有在输入字符串并单击Enter之后，我才想在ETXTBOX中输入值后立即在GRIDVIEW中显示


谢谢

But i am getting the result but only after i enter the string and click enter BUT I WANT TO DISPLAY IN GRIDVIEW AS SOON AS THE VALUE IS ENTERED IN ETXTBOX


THANKS IN ADVANCE

推荐答案

将以下内容添加到您的Page_Load

Add following to your Page_Load

txtserach.AutoPostBack = true

或在设计时将AutoPostBack设置为true.

但是我认为这对用户来说不是一个很好的体验，因为页面将刷新以从服务器获取数据.

按照我的看法，您应该想到一些ajax或jquery替代方法.

or set AutoPostBack to true at design time.

But I think it''s not a good experience for users, as page will refresh to get the data from server.

As per me, you should think of some ajax or jquery alternatives.

在您的ASPX文件中..设置textsearch的此属性
AutoPostBack ="true"

如果有帮助，请对此答案进行投票

in your ASPX file.. set this property of textsearch
AutoPostBack="true"

please vote this answer if it helps

为此使用Ajax AutoComplete Extender.


http://www.asp.net/ajax/ajaxcontroltoolkit/samples/autocomplete/autocomplete.aspx


如果有帮助，请投票.

Use Ajax AutoComplete Extender for this.


http://www.asp.net/ajax/ajaxcontroltoolkit/samples/autocomplete/autocomplete.aspx


Please Vote if this helps you.

这篇关于在GRIDVIEW中搜索的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！