Gridview and Textbox by using where condition

Question

0.00/5 (No votes)

See more:

Hi Sir,

I am Rakesh P.

I have a simple issue about Gridview and Textbox .

I have table "EMP" in database. now I have textbox and button & Gridview ON PAGE

I want to display result for particular empid in gridview when i enter empid in text box . I tried to implement it by using where clause but it shows error that textbox can't bound with gv

Please help me ...

-Rakesh

Posted 16-Jul-12 3:01am

Rectus

Add a Solution

Comments

Karthik Harve 16-Jul-12 9:03am

Can you show your code?

Sandeep Mewara 16-Jul-12 9:59am

Why a repost:
http://www.codeproject.com/Questions/422368/Gridview-and-Textbox-by-using-where-condition

3 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)

Prasad_Kulkarni · Answer 1 · 2012-07-16T03:06:00

Please refer following threads:

This thread will show you how to search through all columns of ASP.NET GridView Data and show only those data which satisfies the search text: How to search through GridView records[^]

This example describes how to use GridView Filtering or Filter Gridview with DropDownList: GridView Filter Expression with DropDownList ASP.NET[^]

ASP.NET GridView Filtering[^]

Also have a look on this CP Article, this will give you a Custom control derived from GridView, implements filtering, custom Top pager, and custom Bottom pager.
Custom GridView with Paging and Filtering[^]

..and some more:
Filterable Grid for ASP.NET[^]
ASP.NET GridView with search option (SearchableGridView)[^]

Display Large Amount of Data in GridView with Search Functionality[^]
ASP.NET GridView with search option (SearchableGridView)[^]
GridView Multiple Filter AJAX Control[^]

Mohamed Mitwalli · Answer 2 · 2012-07-16T03:23:00

Solution 2

Hi ,
Check this
how to search the records using textbox[^]
Best Regards
M.Mitwalli

Posted 16-Jul-12 3:23am

Mohamed Mitwalli

Suman Zalodiya · Answer 3 · 2012-07-16T03:55:00

Hi Rectus,

Please try like this

protected void Button1_Click(object sender, EventArgs e)
    {
        SqlConnection Cn = new SqlConnection("server=OM-PC;database=master;uid=SA;pwd=123");
        
        string query="SELECT * FROM DEPT WHERE DNO="+ Convert.ToInt32(TextBox1.Text);

        //if your department number contains any character 
        string query="SELECT * FROM DEPT WHERE DNO='"+ Convert.ToInt32(TextBox1.Text)+"'";

        SqlCommand Cmd = new SqlCommand(query, Cn);
        Cn.Open();
        SqlDataReader Dr = Cmd.ExecuteReader();
        GridView1.DataSource = Dr;
        GridView1.DataBind();
        Dr.Close();
        Cn.Close();

    }
}

I hope this will help you in your problem. Please make it resolved if it helps you.

Thanks and Regards
Suman Zalodiya

Gridview and Textbox by using where condition

3 solutions

Solution 1

Solution 2

Solution 3

Add your solution here

Preview 0