Filter gridview on selectedindex change of textbox

Question

1.00/5 (1 vote)

See more:

I guys, Please can anyone help, i want to filter the content of a gridview on text change in a text box. The gridview have already been populated with data when the page loads.

Thanks

Posted 7-Mar-13 4:39am

ahmedfaruk88

Add a Solution

Comments

joshrduncan2012 7-Mar-13 10:43am

This isn't a question. We need a lot more info as to what exactly you are doing.

ahmedfaruk88 7-Mar-13 10:45am

Am trying to dynamically filter the content of a gridview on text change of textbox. The gridview contains more than 300 rows of data, and it takes the users time when traversing in it looking for a particular employee info with the specified name

[no name] 7-Mar-13 10:51am

That still is not a question. Nor is it a description of the problem that you are having with any code. Please post the code that demonstrates your problem and clearly describe the problem that you are having. Are you getting any errors when you run your filtering code? What errors are they?

ahmedfaruk88 7-Mar-13 10:54am

I am not getting any error, but clueless on how to go about it

[no name] 7-Mar-13 11:19am

Clueless on how to go about what exactly? Creating a textbox text change event? Querying a database? Connecting to a database? Displaying data in a grid? Good luck finding a selectedindex change event for a textbox though.

1 solution

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)

Anurag Sinha V · Answer 1 · 2013-03-07T05:14:00

hi,

guess u can call OnTextChanged event in the codebehind and try to access the gridview from there.
below code might help:

C#

<asp:textbox id="TextBox1" runat="server" autopostback="true" ontextchanged="text" xmlns:asp="#unknown"></asp:textbox>

data access layer:

C#

public DataTable populategridview(int id)
  {
      SqlDataAdapter da = new SqlDataAdapter("select empname from development.dbo.employee where empid='" + id + "'", xconn);
      DataTable dt = new DataTable();
      da.Fill(dt);
      return dt;
  }

Codebehind:

C#

protected void text(object sender, EventArgs e)
{
    DAL obj2 = new DAL();
    int id = Convert.ToInt32(TextBox1.Text);
    DataTable dtnew = obj2.populategridview(id);
    grdview.DataSource = dtnew;
    grdview.DataBind();

}

try to do somethng like above..guess it should work..havent tested it though...:)

regards
anurag