Gridview problem occured after filtering

Question

0.00/5 (No votes)

See more:

after filtering values in gridview its not working correctly..
i hav used follwin code.....

protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedrow = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text.ToString());
}

////cell[1] m taking JOb_ID
its working fine with the first time i binddata() to grid....
but wen i use filtering===>>>>

protected void txttitle_TextChanged(object sender, EventArgs e)
{
string str = txttitle.Text;
da = new SqlDataAdapter("SELECT job_id, jobtitle FROM Job_Details WHERE (jobtitle LIKE '" + str + "%')", con);
DataTable dt = new DataTable();
dt.Clear();
da.Fill(dt);
GridView1.DataSource = dt;
GridView1.DataBind();
}

than if i select any row from gridview its not working and giving firstrow value

Posted 6-Jan-10 22:52pm

amitktkr

Add a Solution

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)

Christian Graus · Answer 1 · 2010-01-06T22:55:00

There is SO much wrong with this code.

wrote:
string str = txttitle.Text;
da = new SqlDataAdapter("SELECT job_id, jobtitle FROM Job_Details WHERE (jobtitle LIKE '" + str + "%')", con);

This code means any user can erase your database, and probably guess how to add users, remove them, etc. Please tell me that your stream of questions relates to something you're writing for fun, and not something anyone is paying for ?

And no, I don't care if you one vote me for giving real advice and telling the truth.

wrote:
protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
{
int selectedrow = Convert.ToInt32(GridView1.SelectedRow.Cells[1].Text.ToString());
}

You do a postback whenever the selection changes, or the text changes ? Really ? This code is useless. It can't ever 'work' if by work you mean anything other than 'assign an integer that is never used and move on'. So you store an int called selectedRow. Why do you expect that to do ANYTHING for you ?