Click here to Skip to main content
15,893,381 members
Please Sign up or sign in to vote.
1.00/5 (1 vote)
See more:
hi... please help me.
i have data in sql written as APR APR-MAY-JUNE-JULY-SEP-AUG-OCT-NOV-DEC-JAN-FEB-MAR-
and i want tto display it in label as APR-MAR-
Posted
Comments
Magic Wonder 14-Sep-15 1:44am    
You mean APR - MAR???
Member 11865955 14-Sep-15 1:46am    
yes
Member 11865955 14-Sep-15 1:46am    
help me sr i m wrking on school fee payment
Magic Wonder 14-Sep-15 1:51am    
Kindly clarify in more details about table structure and data storage.
Member 11865955 14-Sep-15 4:01am    
it simple
that if i selcect april then in textbox1.text=apr-
and then if i select may then in textbox1.text=apr-may-
similarly upto march
and then finally i have inserted value of textbox.text in database

1 solution

This is bad design. If you want to store data monthwise map to a new table that has just the foreign key id and the month in it.
You should not be storing data in this way.
 
Share this answer
 

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