Search Tool in c# windows application

Question

1.00/5 (1 vote)

See more:

Dear Team,

I have a requirement as stated below, Request if you guys can help me achive this.

I want to make a dialog form which searches any database (by passing table name) table and any field in same table and pass the selected value to calling form.

Schenerio is like we have to search employees from database and on selection of any row in grid employee code gets populated in employee code in parent form for update, similarly if i have to dearch departments table then i can use same searcher tool for this departments tables in another form.

In Other way SAP like search window, same window works for all forms.

Vijay

Posted 24-Feb-13 22:48pm

Singh Vijay Kumar

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)

Garth J Lancaster · Answer 1 · 2013-02-24T23:23:00

how about using a 2 column grid on a form ?

In the first column, each row contains the field (name) on which you will allow a query parameter for - this can be populated by reading the meta-data for the table. In the second column, you accept the parameters for each field from the user.

When the users click's 'search', you traverse the grid, and build a select query from any column 1 field name and its column 2 query value/parameter where the column 2 value is non null

do you get what Im saying ?

eg (you have to imaging the '|' line up in the below 'grid'

Departments
=====================
Dept_Name |
Dept_Manager | Fred
Dept_Code | 001
Dept_Type |

builds a query 'select * from departments where Dept_Manager = 'Fred' and Dept_Code = "001";'

You could hard code 'nice names' for the first column if the Column/Field names arent pretty

Ive seen all sorts of complex queries used for this sort of thing to avoid building a sql query string like this (sql injection type attacks), ymmv

'g'