how to insert a row into database

Question

hi...

i've one table called thoughts
in that i've two fields
date and thoughts

now in front end that is in .aspx page C# code
there's one textbox and one submit button.
when i enter text into textbox it should save
in thought table with the date..
the date should be in increment order..

i.e if i enter the data one time today then today's date.
if i enter the date two times tommorrows date
if i enter the date three times day after tommorrow's date..

actually i want to enter the thoughts for one year that is
365 thoughts and i want to retrive the thought by date..

Please help me..

vinnu · Answer

thanks for reply.. but first how to insert .. where dates must be in increment order...

Krishna Garad · Answer

If you have problame in showing the records actually just in manner you can enter the values in table but when retrieving those record then get those on the basis of some condition like select record in asc/desc order.