display a particular record

[ola123]

hello there,

here is the problem.
I have created some asp pages and linked it to a database. I know how to display the records using gridview, but what i want to know how to do is display ONE record.
Say for example i type the id of a record and click find, it should locate and display only that particular record.

if there is someone who could let me know how to do that i would greatly appreciate it.

thanks in advance
a working example, some line of codes or tutorials would be nice.

thanks again
B2DB

 

[Tarwn]

This sounds like your using ASP.Net. If that is the case you may want to try: forum855

If you are using classic ASP, then we need more detail on what you mean by a gridview.

-T

 

[tyt2000]

Simple.

Just edit your SELECT statement in your GridView and add a WHERE clause.

Example:
"SELECT ID, First_Name FROM Employees WHERE ID = 19"

This SQL statement only gives you one record based on the ID inputted in the WHERE clause.

Here is a useful resource:

http://www.w3schools.com/sql/sql_where.asp

I hope this helps...

- Thamer