I need help creating a search screen

Question

Hello Everyone! I need help on a project that I am working on; I am a new VB 2005 user and this is my first project. I have a search form where I have 6 comboboxes and a From date textbox and a To date textbox I have also added a datagridview.

I want to be able to create a search by selecting any value from the comboboxes and populate the data into the datagrid.

I have Priority, status, district, application, group, and assignee.

Any help will be greatly appreciated

Mahesh Chand · Answer

You create a stored procedure that takes parameters for each search filter. If parameter value is null ignore the filter in stored procedure. On UI if value of the field is not valid (emply or null) pass that as null to SP and get the results.