I got a datecolumn Exp_Date in an sql table.I want to display only records of current date in a gridview.I am using sqldatasource to bind to the gridview.In html what should i give in the selectcommand like
selectcommand="Select * from mytable where Exp_Date>=getdate"?????

its very urgent....

Regards,
AMR

Functions DATEPART and GETDATE are you friends.

http://msdn2.microsoft.com/en-us/library/ms174420.aspx
http://msdn2.microsoft.com/en-us/library/ms188383.aspx

Weico,

I want to use getdate() function in sqldatasource's selectcommand like
select * from sometable where datecol>='<%DateTime.Parse(DateTime.Now.ToShortDat eString()%>' in HTML page i.e UI page.But instead of the above i shall use ServerSide dateTime using GetDate().How to get records in a gridview using GETDATE();

Thanks in Advance and Thanks for Replying Buddy :)

AMR

I don't understand. Calling Getdate() directly in your SELECT statement should return you the current date on the SQL Server. Maybe I missed something.

================================================== =========
Read this if you want to know how to get a correct reply for your question:
http://www.catb.org/~esr/faqs/smart-questions.html
================================================== =========
.: Wrox Technical Editor / Author :.
Wrox Books 24 x 7
================================================== =========