Search GridView With TextBox Problems in Row

Question

0.00/5 (No votes)

See more:

C#

TextBox t = (TextBox)sender;
      var sbFilter = new System.Text.StringBuilder(200);

      //marto gridvie1 sexedavs
      if (t.Text.Length > 0) {
          sbFilter.Append(t.ID + "Like %'").Append(t.Text).Append("'%");

      ObjectDataSource1.FilterExpression = sbFilter.ToString();
      }
      else{
          ObjectDataSource1.FilterExpression = string.Empty;
          ObjectDataSource1.FilterParameters.Clear();

      }

i have this code for Search In GridView in Row but when i use instead of Like "=" it is working perfectly but i have to Search Whole Word i want to Use Like but when i am doing like this It is Erroring mee i tried lots of Combination '% << this one but didn't helped Can anyone Help me?

Posted 11-Dec-15 3:51am

GTR0123

Add a Solution

1 solution

Add a Solution

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

Suvendu Shekhar Giri · Answer 1 · 2015-12-11T04:46:00

Nothing looks wrong to me.
Only concern are-
1. Make sure that you text doesn't exceed 200 characters.
2. Instead you can initialize a StringBuilder object without specifying a limit (if it is not the need of your program)
3. Make sure that your input text doesn't contains special characters like '(single quote)

Hope, these would help resolving your issue.

Else, please share details of the error you are getting so that we can identify the actual issue and will be able to suggest more clear solution.

Thanks.

Search GridView With TextBox Problems in Row

1 solution

Solution 1

Add your solution here

Preview 0

Search GridView With TextBox Problems in Row

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us