string to mmm-yy format of time
I need to perform some date operations in ASP.net using C#. 

1)The date i would enter should be of format 'Jul-05' (mmm-yy Format and type-**string**)... 
how can i check with this????
Or how can i validate this with whatever user is entering as a string???

2) After validating that, i need to compare tht with a value in Database(say a column name *buy_period* which has a value (say) 04/31/2007).

How can i write a Query for comparing both?? (as both dates would be of different formats)

Can u pls help me in this ???

string to mmm-yy format of time
===

I need to perform some date operations in ASP.net using C#. 

1)The date i would enter should be of format 'Jul-05' (mmm-yy Format and type-**string**)... 
how can i check with this????
Or how can i validate this with whatever user is entering as a string???

2) After validating that, i need to compare tht with a value in Database(say a column name *buy_period* which has a value (say) 04/31/2007).

How can i write a Query for comparing both?? (as both dates would be of different formats)

Can u pls help me in this ???
