how to fetch

[dskumar_85]

hai friend's

i am having a table in that i have the field like ( id , name , date),in that i stored

id name date
e123 raj 12/08/2009
e123 raj 12/10/2009
e123 raj 12/12/2009
e124 ram 12/08/2009

like this while fetching the select id ,name,date from tablename where id="@id"

this i retrive by using sqlreader by using while condition by doing this i fetch the last thing only i mean ,if i give id =e123 i fetch the e123,raj,12/12/2009 only ,but i want all the data with id e123.

[sknake]

This sounds like an issue on the application side. Please post the code where you're using the SQL Reader to pull the data back.

[mail2saion]

You need to write a loop through reader. Mostprobably you just read & after that you are doing nothing. Please post your sqlreader full segment.