sql statement

Question

0.00/5 (No votes)

See more:

Am developing a software that is surpose to search for a records in a database when it`s referential intergrity are satisfied.By entering a keyword or key the record relating to that key or keyword should pop up.
Am using vb.net 2008 profersional edition.I have design the database in Acces and done the report with the crystal Report and connected to vb.But the only thing left is how to use the SQL (structured query language )to search for a record in the database that is already connected to vb, when a keyword is entered.

1. What are the steps in the codes.

Posted 13-Jul-10 7:39am

Quaicoe

Updated 13-Jul-10 9:35am

v3

Add a Solution

Comments

Sandeep Mewara 13-Jul-10 13:57pm

Before steps, tell us what you have done so far. That would show your proficiency and understanding on the subject.
Have you tried anything so far? Any ground work?

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)

Smithers-Jones · Answer 1 · 2010-07-13T07:50:00

Solution 1

What have you done so far, what is the exact problem? It looks like you don't even know about the basics of selecting a record from a database.

Posted 13-Jul-10 7:50am

Smithers-Jones

Simon_Whale · Answer 2 · 2010-07-13T12:39:00

as previous posters have said you haven't shown what you've tried with

1. SQL code
2. a narrative as you feel that you need help approaching the problem

as it does show that you have a lack of understanding you need to do some research / learning into the subject. buy some books / get some training or even use the internet and look up examples

here's a potential site to start learning from learn a bit of SQL