SEARCH IN GRIDVIEW

Question

1.00/5 (1 vote)

See more:

SQL-Server-2005

, +

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

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

Posted 22-Sep-10 23:09pm

anupama962010

Add a Solution

4 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Prerak Patel · Answer 1 · 2010-09-22T23:22:00

Solution 1

Add following to your Page_Load

txtserach.AutoPostBack = true

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.

Posted 22-Sep-10 23:22pm

Prerak Patel

Updated 22-Sep-10 23:23pm

v2

MalikRizwan · Answer 2 · 2010-09-22T23:22:00

Solution 2

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

please vote this answer if it helps

Posted 22-Sep-10 23:22pm

MalikRizwan

NMehta83 · Answer 3 · 2010-09-22T23:26:00

Solution 3

Use Ajax AutoComplete Extender for this.

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

Please Vote if this helps you.

Posted 22-Sep-10 23:26pm

NMehta83

anupama962010 · Answer 4 · 2010-09-24T01:37:00

Solution 4

is there any other solution other than ajax control

Posted 24-Sep-10 1:37am

anupama962010

Comments

MalikRizwan 24-Sep-10 9:52am

yes there is if you use client based (javascript) for text change event and on each key pressed pass value to iframe and in that iframe have your grid...to show tabular data.. but i dont understand why would you want to use anything else than ajax.. I suggest you to do it like this
<asp:updatepanel runat="server" updatemode="Conditional">
<contenttemplate>
-- put your textbox and gridview here..

don't forget to drag scriptmanager on top of your page...

and don't forget to add Ajax extension in your project... this is all you have to do with ajax thing.. it will solve your problem...

anupama962010 25-Sep-10 1:32am

yaa i know its simple using ajax but for auto complete extender it is asking to crreate some asmx page and calling it which i did but remained unsuccessful can u help me with any userdefined code other than the example given in tutorials