C# create a search option

Question

1.00/5 (2 votes)

See more:

Need help with search option in Windows form.

What I have tried:

I am trying to figure out how to add a search feature to a windows form. I have a combobox with three options. Code, Name, City. When you choose one, I need another box to open to enter search criteria and then return values in a grid format.  I have seen examples on the getting the grid setup, but cannot figure out the search part. Any ideas / examples would be appreciated.

Posted 22-May-19 7:28am

MIDCOPC

Updated 22-May-19 19:51pm

RickZeeland

v2

Add a Solution

Comments

F-ES Sitecore 22-May-19 14:19pm

There isn't enough information to help. How you search depends on where the data is. Is it in files? One file? XML? A database? The registry? The internet?

MIDCOPC 22-May-19 14:47pm

Data is in an MySQL database.

ZurdoDev 22-May-19 15:17pm

Where are you stuck?

MIDCOPC 22-May-19 15:34pm

I don't know where start to create the search options. I have the combobox working.

// Create the Search List
private void LoadSearchList()
{
List<string> SearchList = new List<string>
{
"Code",
"Name",
"City"
};

AccountSearchListValue.DataSource = SearchList;

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

RickZeeland · Answer 1 · 2019-05-22T09:48:00

Solution 1

Here is a basic article on how to connect and query MySQL database with the SELECT command:
Connect C# to MySQL[^]
More information about SQL here: SQL SELECT Statement[^]

Posted 22-May-19 9:48am

RickZeeland

Comments

MIDCOPC 22-May-19 15:53pm

Thank Rick. I am already connected to the database.

MIDCOPC · Answer 2 · 2019-05-22T13:45:00

Solution 2

I was able to figure this out.

Posted 22-May-19 13:45pm

MIDCOPC

Jatinath · Answer 3 · 2019-05-22T19:52:00

Solution 3

Hi,

suppose you have combobox1 with values 'Code', 'Name', 'City' and Textbox2/Combobox2 for enter searchValue.

on TextBox2/ComboBox2 TextChange event you can check for selected combobox1 value like Code or other and according you can query in DataBase for possible values to show in grid.

Hope this will help you.

**Mark as Answer if found useful.

Regards,
Jatinath

Posted 22-May-19 19:52pm

Jatinath

Comments

Jatinath 27-May-19 9:22am

why my answer is downvoted? if I have tried to answer and it near or related to asked questions then why?