How Do I Display All Names Of Employees By Providing Partial Name?

Question

0.00/5 (No votes)

See more:

when i give whole of fellow name search function is doing well.The problem is when i give partial fellow name it is always displaying "no record". Can anyone please help me out.This is really urgent.My coding is in C#(winforms)

Posted 29-Jun-15 18:25pm

Member 11793580

Updated 1-Jul-15 20:36pm

v2

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)

Abhipal Singh · Answer 1 · 2015-06-29T18:54:00

Solution 1

The code you provided is prone to SQL injection. Always use Parameters.Add() to add parameters/dynamic values to your SqlCommand object. However, I think you helper(MySqlHelper) does not support that. You can change your helper if you want your code to be more secure.

Coming back to the problem you are facing:
You are not using wild card characters(%) in your search query. Replace the SQLCommand query with the one given below:

C#

DataTable dtSearch = VMR.MySqlHelper.GetDataTable("select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%" + txtSearch1.Text + "%'");

Posted 29-Jun-15 18:54pm

Abhipal Singh

Comments

Member 11793580 30-Jun-15 1:39am

Thanks for the response.
I replaced the query with the one u have given but it is not displaying names when i give part of name.
I have used parameters in insert code.

Abhipal Singh 30-Jun-15 2:36am

Can you provide sample data from your database and also, the input you are giving in the textbox.

Abhipal Singh 30-Jun-15 2:52am

select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%A-Z%';

In the above query you have hardcoded A-Z which is incorrect. You need to replace it with txtSearch1.Text as suggested in the solution.

To test the query replace the 'A-Z' with 'da' as given below:
select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name like '%da%';

Member 11793580 30-Jun-15 2:55am

But if i mention %da% it will give only those two names.I want search criteria on all of the names in the database i.e., names starting from A till Z.

Abhipal Singh 30-Jun-15 3:02am

All the names will start from albhabets I believe. That means it is not a filter at all.

The query in Solution will handle this situation. You can keep your textbox as empty and click on search and you will get all the names.

Member 11793580 30-Jun-15 3:13am

It is giving error as..Can't connect to localdatabase, table_name doesn't exist

Abhipal Singh 30-Jun-15 5:22am

This is a different issue related with db connection. Looks like you have broke something

Member 11793580 2-Jul-15 0:02am

I have fixed it. But the problem is i am not able to run the query through code. It is working fine when i execute it in DB

Abhipal Singh 2-Jul-15 0:49am

And what is the problem you are getting now?

As this is a seperate problem, I suggest you to mark this as an answer and write a seperate Question with the details description of the issue/error you are facing now.

Member 11793580 2-Jul-15 1:00am

I have fixed that error. Now the problem is i am not able to get the list of names when i give part of a name i.e., when i give "da" in textbox it should display all the names starting with "da". I am able to get this in database but not through code.