exception error hanling problem

Question

0.00/5 (No votes)

See more:

Win2008

C#

table.DefaultView.RowFilter = "" + comboBox1.Text + " like '" + txtSearch.Text + "%'";

this my code when i five 0 in my search box it shows some error like this Troubleshooting Exceptions: System.Data.EvaluateException i understood there is some problem in the query near **like** now how shud i write my query? to search/filter even zeros?

Posted 23-May-12 23:24pm

Member 8983639

Updated 23-May-12 23:26pm

Prasad_Kulkarni

v2

Add a Solution

Comments

Oshtri Deka 24-May-12 5:34am

"when i five 0"
What?

Member 8983639 24-May-12 5:44am

when i enter 0 into the serachbox der is a problem i mean with decimals its working only for alphabets

Sandeep Mewara 24-May-12 5:55am

What is the EXACT error. Sharing 'somehting like' does not help.

Further, did you check what you get the rowfilter expression once line is executed?

Member 8983639 24-May-12 6:10am

here rowfilter is not working when i enter a interger value into textbox to search

Satish32 24-May-12 6:26am

Would you send the exact RowFilter value for which its breaking.

Member 8983639 24-May-12 7:56am

actually data is in integers so i used int.parse for interger columns and for other columns went with the same code

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)

Raja Soosai · Answer 1 · 2012-05-24T00:31:00

Solution 1

Hi,

Please confirm the table has a column in the value of comboBox1.Text

Your query is correct.

Thanks,
Raja S

Posted 24-May-12 0:31am

Raja Soosai

Comments

Member 8983639 24-May-12 7:55am

yaa got it thanq