retrieve data

[singhanand2009]

how could i retrieve data from database for a particular field. example- i have got a table having id as primary key, password, and other entity. how could i retrieve only one colum such as id.

[kunal pawar]

what is ur requirement exactly, can u explain more briefly

As u said u want to retrive just 1 column then give ur column name in SELECT which retrives just one column

for eg.

Select field name FRom table name

[DrBunchman]

Hi singhanand2009,

You don't really give enough detail in your post for me to give you exact advice. What language are you using (VB.NET, C# etc) ? Which database platform are you using (MySQL, SQL Server, Access etc) ?

In general you retreive data from a database by using a query which says something like:

SELECT id FROM table WHERE id = somevalue

There is a tutorial here: http://www.w3schools.com/sql/default.asp I suggest you go through it then come back to the relevant forum with any future questions.

Remember to include as much detail as possible in any future posts.

Hope this helps,

Dr B