Asp.Net News
Free Tech Magazines
Asp.Net Web Hosting
Suggest Us
Link to Us
Feeds Subscription
Questions & Answers
Tips & Tricks
 how to write the querry for 6 months or for 1 year
Posted by charan on  3/29/2010 8:57:23 AM Category: ADO.NET
Add to my favorites
Email to friend
hi, iam using with c# with sql server databae

the table fields are

username nvarchar
startdate datetime
enddate datetime
paytype int
reminder int

while registering the user will selects the startdate and enddate and the pay type is 6months or 1year and he will select the reminder before 10days
then if he selects for 6months then before 10days i have to send email. if he selects for 1year i have to send for every 6months before 10 days
then how to write the querry for this condition please give the example which helps me.

Post Your Reply Post New Question

 Viewer's Reply
This Question has 0 replies.

Sponsored by
Introduction to Software Development
The Art & Science of JavaScript - Free 100 Page Preview!
Build Your Own ASP.NET 3.5 Web Site Using C# & VB, 3rd Edition - Free 219 Page Preview!