Searching Sql database

Question

0.00/5 (No votes)

See more:

SQL-Server-2008

Hey. i have a menu control with items that i put in manually. It is not bound to the database. I also have a checkboxlist control with items that i again put in manually and is also not bound to the database. I do have the required tables in the database for when the user has to input and store the data in the database. But how do i code the search in vb 2010? the database is already quite complex and im trying to avoid putting in too many tables in it. To better the initial question and too add clarity, the menu control has a list of areas that a user has to choose to search for a service provider and the checkboxlist has jobs example tiler, builder etc. When the search button is clicked, the datagrid must show the required information.

thanks

Posted 11-Sep-11 5:49am

thasmeel

Updated 11-Sep-11 5:52am

v3

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)

Pradeep Shukla · Answer 1 · 2011-09-11T08:57:00

Solution 1

You need to write Stored procedure with a search logic to do the search based on the input that user would provide on the form through checklistbox. Read through some of the basic articles on how to create stored proc and putting joins on tables.

Posted 11-Sep-11 8:57am

Pradeep Shukla

Comments

thasmeel 12-Sep-11 8:07am

Im trying to do the stored procedures but im getting endless errors. I have 4 variables: name, phone number, location and skills. those 4 things are to be displayed in the datagrid. I have the same things in the database. How do i code this? Visual studio is also giving me errors with connecting to the database and other stuff. please help. very desperate.

Pradeep Shukla 12-Sep-11 15:53pm

It's a very basic stuff, go through this article: http://www.codeproject.com/KB/cs/simplecodeasp.aspx