Click here to Skip to main content
15,883,705 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
See more: , +
Hi can you help me ?
I had problem in my project .i create one registration form for entering the details and it works clearly my problem is on selecting data from that database to my data grid view i want to select some field to grid view on the base of reference no(the field i created in sql) like FROM that reff no TO reff no . i didn't know the query so please help me. i used C# asmy language .
Posted
Comments
arindamrudra 3-Nov-10 5:44am    
Your question is not pretty clear and what you have done post some of your relevant code and what is the error you are getting post that clearly.

1 solution

Hi,

Plese use "between" operator.

SELECT * FROM TABLE_NAME WHERE ID BETWEEN 10 AND 100 


"ID" is an column defined in "TABLE_NAME" table. Replace 10 and 100 by your custom range.
 
Share this answer
 
Comments
sevenbell 3-Nov-10 5:51am    
Thank you for your valuable answer .i tried it and i got the out put .
Arindam Tewary 3-Nov-10 5:56am    
Then why it is downvoted???
Dalek Dave 3-Nov-10 6:37am    
Upvote to correct!
Arindam Tewary 3-Nov-10 6:48am    
Thanks Dalek :)

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900