ASP.NET

10-Dec-09 7:11

Am using MS sql server 2005 database.

Table has 3 columns:
1)Id
2)Status
3)ExpireDate

If Expire Date is today then status has to become false otherwise true.
It has to done automatically. How to do it?

Please help me

CROSSPOST

Richard MacCutchan10-Dec-09 7:24

10-Dec-09 7:24

This was already posted in the General Database forum. Please post in one forum only.

Krishhhhhhhhhhhhhh10-Dec-09 7:31

10-Dec-09 7:31

No one has answered for this question yet. If anybody knows answer it

Richard MacCutchan10-Dec-09 7:35

10-Dec-09 7:35

Krishhhhhhhhhhhhhh wrote:
No one has answered for this question yet. If anybody knows answer it

Be patient, this site isn't set up to provide immediate answers.

Krishhhhhhhhhhhhhh10-Dec-09 7:41

10-Dec-09 7:41

Then y u r there? I think To check cross post only?

Richard MacCutchan10-Dec-09 7:52

10-Dec-09 7:52

No, I'm looking for questions to answer, but when I read the same question more than once I (like many others here) point out that you are abusing the forums. There is a protocol to be followed here and maybe if you are new you are not aware of it. Read the guidelines[^] for more information.

Krishhhhhhhhhhhhhh10-Dec-09 7:55

10-Dec-09 7:55

I am not new to this. Check ur database since how long am using this. then talk to me.

Richard MacCutchan10-Dec-09 7:58

10-Dec-09 7:58

Krishhhhhhhhhhhhhh wrote:
I am not new to this.

Then you have no excuse for
i) Crossposting
ii) Not knowing the guidleines
iii) being rude.

Krishhhhhhhhhhhhhh10-Dec-09 8:06

10-Dec-09 8:06

I won't excuse u people for
i) irresponsible
ii) For not answering my questions
iii) wasting my time

Bassam Saoud10-Dec-09 8:41

Bassam Saoud

10-Dec-09 8:41

He is right that you are cross posting (bad boy!)and you are right that he found the time to mention that you are crossposting but cant find the time to answer the question Smile | :)

Bassam Saoud10-Dec-09 8:41

Bassam Saoud

10-Dec-09 8:41

I answerd your question Smile | :)

Ashfield10-Dec-09 21:04

Ashfield

10-Dec-09 21:04

Krishhhhhhhhhhhhhh wrote:
i) irresponsible

In what way?

Krishhhhhhhhhhhhhh wrote:
ii) For not answering my questions

It has been aswered. Also remember that nobody here is paid to answer questions, they do so out of kindness

Krishhhhhhhhhhhhhh wrote:
) wasting my time

Well don't bother posting any more questions, particularly when you are so rude.

Bob
Ashfield Consultants Ltd
Proud to be a 2009 Code Project MVP

Abhijit Jana11-Dec-09 1:40

Abhijit Jana

11-Dec-09 1:40

Hi,
Please don't be rude. Here every one try to help each other. So be polite while asking question or seeking for help.

Thanks !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Send an auto mail

Krishhhhhhhhhhhhhh10-Dec-09 6:57

10-Dec-09 6:57

I am working with asp.net and MS sql server 2005. I want send an automatic mail to those status is incomplete(In my database table one column has data like either "complete" or "incomplete").
When the status is "incomplete",then send a mail daily once to "so and so email id".

Please help me

Abhishek Sur10-Dec-09 7:04

Abhishek Sur

10-Dec-09 7:04

Yes... But what is the problem with it.

You might use your website easily to send mails daily... Wink | ;)

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Krishhhhhhhhhhhhhh10-Dec-09 7:08

10-Dec-09 7:08

How to do that?
Is it necessary to visit my website daily. If not plz tell me how to do that?

sashidhar10-Dec-09 19:02

sashidhar

10-Dec-09 19:02

Why Dont You Go For Sql Jobs..!
or
You Can create a windows application for sending the mail and add this application to task scheduller ..!if you are using windows operating system..! Thumbs Up | :thumbsup:

LatestArticle :Log4Net
Why Do Some People Forget To Mark as Answer .If It Helps.

Abhishek Sur10-Dec-09 21:39

Abhishek Sur

10-Dec-09 21:39

This should be the perfect one for you

Simulate a Windows Service using ASP.NET to run scheduled jobs[^]

You dont require windows service / Schedule tasks to do this ..

Cheers. Rose | [Rose]

Abhishek Sur
Don't forget to click "Good Answer" if you like this Solution.
My Latest Articles-->
Simplify Code Using NDepend
Basics of Bing Search API using .NET
Microsoft Bing MAP using Javascript

Abhijit Jana11-Dec-09 1:46

Abhijit Jana

11-Dec-09 1:46

Krishhhhhhhhhhhhhh wrote:
How to do that?

I have provided you one Ref. Which will help you to go ahead.

Krishhhhhhhhhhhhhh wrote:
Is it necessary to visit my website daily.

No !

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.

Abhijit Jana11-Dec-09 1:45

Abhijit Jana

11-Dec-09 1:45

As you are using SQL Server 2005, you can easily use SQL Server Job agent to schedule and send mail from SQL Server itself which is one of the easiest task that you can do.
Here is one of the ref. that you can use :
Sending Mail using SQL Server 2005[^]

Another option is to use Windows Service. Use some TimerDelegate to monitor your DB in regular manner and based on the condition sends mail to the user.

Thanks

Abhijit Jana | Codeproject MVP
Web Site : abhijitjana.net
Don't forget to click "Good Answer" on the post(s) that helped you.