How Do I Search Emp Details Providing Partial Name?

Question

0.00/5 (No votes)

See more:

Hi,
i am using winforms(C#) for developing employee details of an organization. I have used groupbox for search criteria which has ID and name. I am able to get the details if i provide whole of first name and search.But my problem is to get all the names displayed based on only part of name given(not whole name).For example, when i give "Da" i textbox all the names starting with Da(david,daniel etc)should be displayed.

May anyone pls help me.

Posted 28-Jun-15 17:45pm

Member 11793580

Add a Solution

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

sasanka sekhar panda · Answer 1 · 2015-06-28T18:20:00

Solution 2

You can use like operator as demonstrated in solution 1.

If you want suggest append textbox then see below Article...

Autosuggest TextBox from database column in Windows Forms[^]

Posted 28-Jun-15 18:20pm

sasanka sekhar panda

Comments

Member 11793580 29-Jun-15 0:28am

i have done this but always "no record" message is displayed.

sasanka sekhar panda 29-Jun-15 0:29am

can u please share ur code so that i can find out the mistake..

Member 11793580 29-Jun-15 0:43am

Load event code

MySqlCommand cmd = new MySqlCommand("SELECT Fellow_name FROM table_name");
MySqlDataReader reader = cmd.ExecuteReader();
AutoCompleteStringCollection MyCollection = new AutoCompleteStringCollection();
while (reader.Read())
{
MyCollection.Add(reader.GetString(0));
}
txtSearch1.AutoCompleteCustomSource = MyCollection;

sasanka sekhar panda 29-Jun-15 1:32am

AutoCompleteSource CustomSource
AutoCompleteMode SuggestAppend

Did u set all the above properties of txtSearch1.

Member 11793580 29-Jun-15 1:34am

Yes i have done

Member 11793580 29-Jun-15 1:35am

Anything wrong with my code?

sasanka sekhar panda 29-Jun-15 1:36am

Exactly where you are facing the issue in autosuggestion or in search??

Member 11793580 29-Jun-15 1:39am

Both
while running the application by typing text in textbox i am not able to get autosuggestion and search criteria also

Member 11793580 29-Jun-15 1:40am

Should any assembly reference be added

sasanka sekhar panda 29-Jun-15 1:42am

did you get any compile time error???

sasanka sekhar panda 29-Jun-15 1:40am

MySqlCommand cmd = new MySqlCommand("SELECT Fellow_name FROM table_name");
You are not passing the connection string MySqlCommand what's the reason??
where is your connection string??

Put a break point in ur while loop and check its executing or not ??

Member 11793580 29-Jun-15 1:45am

string ConString=ConfigurationManager.ConnectionStrings["ConString"].ConnectionString;

In this line....it is showing red mark for configurationManager...thts d reason i removed connection string.

sasanka sekhar panda 29-Jun-15 1:50am

go to your project..right click on reference..Add reference-->Assembles-->Framework-->
Choose System.confugration-->

Use this in form as Using System.confugration
Namespace: System.Configuration
Assembly: System.Configuration (in System.Configuration.dll)

The above namespace and assembly is required for ConfigurationManager class

Member 11793580 29-Jun-15 2:11am

Ya i have done but still not able to get.

sasanka sekhar panda 29-Jun-15 3:04am

please explain the exact problem, now u are facing!!! quick..

sasanka sekhar panda 29-Jun-15 3:06am

now you are getting the red mark on ConfigurationManager class or not??

Member 11793580 29-Jun-15 3:11am

Now i am not getting red mark and also there are no errors

Member 11793580 29-Jun-15 3:14am

When i enter text in textbox and click on search button it is directly showing as "No record Found". but i am able to get the desired result if i provide whole of the fellow name.

sasanka sekhar panda 29-Jun-15 3:31am

it means your autosuggestion is working properly...search button is not working..
So plz share the code inside search button

sasanka sekhar panda 30-Jun-15 0:20am

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

This get datatable method return a empty datatable..so check this method first..

Member 11793580 29-Jun-15 22:59pm

This i have already shared above. Neway can you please figure it out now

Member 11793580 30-Jun-15 0:29am

What exactly do u want me to check out? I mean with what can i replace?

sasanka sekhar panda 30-Jun-15 1:52am

check why ur datatable have no rows..
First run that query directly to ur database and see the result..Its matching with ur datatable result or not

Member 11793580 30-Jun-15 2:00am

When i run it in database it is displaying zero rows. but "select* from table_name" is giving all the rows

sasanka sekhar panda 30-Jun-15 2:20am

"select * from table_name where S_ID = 'give the value of S_id' OR Fellow_name = 'give the value Fellow_name ' and check the query in db..

Member 11793580 30-Jun-15 2:34am

Still zero rows are fetched.Any problem with datatable

sasanka sekhar panda 30-Jun-15 2:55am

no whats the S_id or Fellow_name u r passing that is not present in db..simple..

Member 11793580 30-Jun-15 2:59am

it is there in database because when i execute
"select * from table_name;" all the rows are displayed

sasanka sekhar panda 30-Jun-15 3:03am

share the query what u executed..

Mehdi Gholam · Answer 2 · 2015-06-28T18:12:00

Solution 1

Usually the 3rd party WinForm controls handle partial searching for you, if not then you can:

1) If you are using a database, then query by using a % operator on a like : select * from tablename where column like '%da%'
2) If you have in memory collections then use a loop or LINQ and string compare with Contains(): stringvalue.Contains("da");

Posted 28-Jun-15 18:12pm

Mehdi Gholam

Comments

Member 11793580 29-Jun-15 0:35am

Actually i have to serach based on ID and name.
My previous query was "select * from table_name where S_ID = '" + txtSearch.Text + "' OR Fellow_name = '" + txtSearch1.Text + "'"..which searches using both name and ID.
How do i modify this query?

Mehdi Gholam 29-Jun-15 0:41am

Try : Fellow_name = '%" + txtSearch1.Text + "%'"

NOTE : your query is subject to sql injection attacks use parameter based queries.

Member 11793580 29-Jun-15 1:01am

Sorry to say that i am not able to get the solution yet.Thanks for the note,i'll c to it