Member Avatar for 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.

  • 3 Contributors
  • 2 Replies
  • 75 Views
  • 1 Day Discussion Span
  • Latest Post Latest Post by mail2saion
Member Avatar for 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.

Member Avatar for 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.

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.