Bind search textbox with gridview

Question

0.00/5 (No votes)

See more:

Hello,

I am trying search my grid view using the following code below and I cannot get the gridview to filter results when I type in a value in text box on the client-side.

Any help would be very much appreciated.
Thank you.

C#

protected void Button1_Click(object sender, EventArgs e)
    {
        if (TextBox1.Text == "")
        {

            String constr = ConfigurationManager.ConnectionStrings["cdwConnectionString"].ConnectionString;
            SqlConnection con = new SqlConnection(constr);
            SqlCommand cmd = new SqlCommand("select [description], [role]  from [dbo].[login] where role = @role");
            cmd.Connection = con;
            cmd.Parameters.Add("@role", SqlDbType.NVarChar).Value = TextBox1.Text;
            SqlDataAdapter da = new SqlDataAdapter(cmd);
            DataSet ds = new DataSet();
            da.Fill(ds);
            GridView1.DataSource = ds;
            GridView1.DataBind();
            //TextBox1.Text = "";
        }
    }

ASP.NET

<asp:TextBox ID="TextBox1" runat="server"></asp:TextBox>
    <asp:Button ID="Button1" runat="server" Text="search" onclick="Button1_Click" />
<asp:Button ID="Button2" runat="server" Text="Download Data" onclick="btnExportToExcel_Click" />

<asp:GridView ID="GridView1" runat="server" AutoGenerateColumns="false"
HeaderStyle-BackColor="#7779AF" HeaderStyle-ForeColor="White" onrowdatabound="gvrecords_RowDataBound">

<Columns>
<asp:BoundField DataField="description" HeaderText="UserName" />
<asp:BoundField DataField="role" HeaderText="FirstName" />

</Columns>

</asp:GridView>

Posted 9-Jan-14 1:34am

miss786

Add a Solution

Comments

Gitanjali Singh 9-Jan-14 7:41am

if (TextBox1.Text != String.Empty)
Try this

3 solutions

Solution 2

Try this

if (TextBox1.Text != String.Empty)

Quote:
In .Net pre 2.0, "" creates an object while String.Empty creates no object. So it is more efficient to use String.Empty.

Source of information

.Length == 0 is the fastest option, but .Empty makes for slightly cleaner code.

So "" is pretty equivalent to .Empty, but still not as fast as .Length == 0.

Posted 9-Jan-14 1:44am

Gitanjali Singh

Updated 9-Jan-14 1:50am

v3

Comments

Karthik_Mahalingam 9-Jan-14 9:24am

5! correct

Solution 3

change your condition:-

SQL

if (TextBox1.Text == "")

To

SQL

if (TextBox1.Text != "")

then try still not solved. then revert back with improved question.

Posted 9-Jan-14 1:46am

TrushnaK

Comments

Karthik_Mahalingam 9-Jan-14 9:23am

5! correct

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)

Karthik_Mahalingam · Accepted Answer · 2014-01-09T01:38:00

Solution 1

C#

 if (TextBox1.Text == "")

try this..

C#

if (TextBox1.Text != "")

Posted 9-Jan-14 1:38am

Karthik_Mahalingam

Comments

miss786 9-Jan-14 7:49am

Thank you so much for your reply and pointing out the silly mistake. I got the textbox to filter through your suggestion and updating the query string. Many thanks

if (TextBox1.Text != "")
{

String constr = ConfigurationManager.ConnectionStrings["cdwConnectionString"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
con.Open();
SqlCommand cmd = new SqlCommand("select [description], [role] from [dbo].[login] where role like '%" + TextBox1.Text + "%'");
cmd.Connection = con;
cmd.Parameters.Add("@role", SqlDbType.VarChar).Value = TextBox1.Text;
SqlDataAdapter da = new SqlDataAdapter(cmd);
DataSet ds = new DataSet();
da.Fill(ds);
GridView1.DataSource = ds;
GridView1.DataBind();
//TextBox1.Text = "";
}

Bojjaiah 9-Jan-14 8:00am

When you not getting result, you should debug it. then you can get an error what's the mistake it. Based on your error you can proceed weather post a question/you can solve it.

Karthik_Mahalingam 9-Jan-14 8:05am

welcome miss786 :)