C# Tutorials and offshore development in India
    Tutorials   Resources   Forum   Communities   Interview   Jobs   Projects   Offshore Development    
Silverlight Tutorials | Mentor | Code Converter | Articles | Code Factory | Computer Jokes | Members | Peer Appraisal | IT Companies | Bookmarks | Revenue Sharing |


Prizes & Awards
My Profile



Active Members
TodayLast 7 Days more...

New Feature: Community Sites: Create your own .NET community website and start earning from Google AdSense ! It's Free !




Urgent !!!! plzzzzzzzzz if anyone know...


Posted Date: 10 Jul 2006      Total Responses: 1

Posted By: Naveen Gandhi       Member Level: Silver     Points: 2


Hello Friends
I am putting this Question again .. bez i doesn't get any ans of this ..
plzzzzzzzzzz help me regarding this ...

I am using SQL SERVER 2000 as a backend..
and storing the TIMEDATE field.. as a hh:mm am/pm dd/mm/yyyy
but i want to search the date ..
what could i write in the code that will match with it..
as user input is like.. 30 may 2006 or 30 may 06
and what is the parameter used in aspx page to find the date from database..
its urgent plzzzzzz
Regards
Naveen




Responses

Author: srikanth    14 Sep 2006Member Level: BronzeRating:     Points: 2
Hi Naveen,

You can convert the user given date to database date before doing the search operation.

if the user gives the date like "30 may 2006"

string st = "30 may 2006";
DateTime d = Convert.ToDateTime(st);
Response.Write(d.Date);

where d.Date represents the database date format.
you can compare the d.date with database format for getting the data from the database.


Post Reply
You must Sign In to post a response.
Next : Resize image and save it to file system
Previous : DropdownList itemlist data binding in SQL server
Return to Discussion Forum
Post New Message
Category: ASP.NET

Related Messages



dotNet Slackers   BizTalk Adaptors    Web Design

web conferencing

Contact Us    Privacy Policy    Terms Of Use