searching a row from a database

[jay09]

is there anyway i can search for a particular row in all columns in a database and display them accordingly?

like in a customer table, i have CustomerID, Name, Address

is it possible to search for all the details of a customer?

[acoder]

Which database are you using?

Are you not sure about the SQL or are you using a language to connect to the database and are unsure of the syntax?

PS. moved from Jobs to Misc for the time being.

[jay09]

i'm using the language to connect to a database, i'm actually programming with visual basic 2008
like i have a customer table, containing CustomerID, Name, Address
i want to search for all the details of a particular customer?

[acoder]

The SQL would be simple:

select CustomerID, Name, Address from customer where CustomerID = 123

(replace 123 with the actual ID. How you query the database and deal with the response depends on the language, so I'll pass this thread onto the VB.NET forum where the experts there should be able to help you.

[jay09]

thanks.......i really do appreciate it