Fetch record by time ASC

In addition to what @nitin sir said, AM/PM are only for display purpose, if you have datetime datatype, you can display it in various format to what user want to view.

 

You can google for parameterized query like

Use parameterized query in msaccess using c#

 

You will get plenty of resources.

 

Hope we had clarified enough.

 

Good Luck 

Hi Amit,

 

I have created two fields, one for date and another for time because the insertion of the date is automatic but time has to entered by the user.

If I keep the field as datetime and Format as Medium Time, then I get the exact format what I have choose for the data entry as AM or PM. but at the time of fetch the record, it does not show only time but date and time together. that's why I will have to change the entire structure.

 

can you please explain a query with both example of concatination and parameterized? as I am not used to 'technical' words. I have learnt most of from net and based on trial and error. :)))

 

Thank You

 

Mayank Jani

Hey

 

It was a good practice to use datetime fields as datetime and not as text, if you are doing so then you are loosing many datatype structures and functionality like sorting and arithmetic operations.

 

You should consider the below points

1.change datatype to datetime instead of text

 

2. Avoid inserting DateTime.Now.ToShortDate(), use DateTime.Now 

 

3. Avoid building query using string concatination instead use parameterized query.