AspdotnetCodes.com
Search
Articles
Books
Resources
Asp.Net News
Downloads
Free Tech Magazines
Asp.Net Web Hosting
Archives
Softwares
Newsletter
Suggest Us
Link to Us
Feeds Subscription
Articles
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 asp.net 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 Web Applications Development
Windows 8: 50 Questions and Answers You Need to Make a Decision (Normally $9.95)
Speech Technology Magazine