Skip to content
  • Categories
  • Recent
  • Tags
  • Popular
  • World
  • Users
  • Groups
Skins
  • Light
  • Cerulean
  • Cosmo
  • Flatly
  • Journal
  • Litera
  • Lumen
  • Lux
  • Materia
  • Minty
  • Morph
  • Pulse
  • Sandstone
  • Simplex
  • Sketchy
  • Spacelab
  • United
  • Yeti
  • Zephyr
  • Dark
  • Cyborg
  • Darkly
  • Quartz
  • Slate
  • Solar
  • Superhero
  • Vapor

  • Default (No Skin)
  • No Skin
Collapse
Code Project
  1. Home
  2. Web Development
  3. ASP.NET
  4. Send an auto mail

Send an auto mail

Scheduled Pinned Locked Moved ASP.NET
databasecsharpasp-netsql-serversysadmin
8 Posts 5 Posters 0 Views 1 Watching
  • Oldest to Newest
  • Newest to Oldest
  • Most Votes
Reply
  • Reply as topic
Log in to reply
This topic has been deleted. Only users with topic management privileges can see it.
  • K Offline
    K Offline
    Krishhhhhhhhhhhhhh
    wrote on last edited by
    #1

    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

    A A F 3 Replies Last reply
    0
    • K Krishhhhhhhhhhhhhh

      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

      A Offline
      A Offline
      Abhishek Sur
      wrote on last edited by
      #2

      Yes... But what is the problem with it. You might use your website easily to send mails daily... ;)

      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

      K 1 Reply Last reply
      0
      • A Abhishek Sur

        Yes... But what is the problem with it. You might use your website easily to send mails daily... ;)

        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

        K Offline
        K Offline
        Krishhhhhhhhhhhhhh
        wrote on last edited by
        #3

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

        S A A 3 Replies Last reply
        0
        • K Krishhhhhhhhhhhhhh

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

          S Offline
          S Offline
          sashidhar
          wrote on last edited by
          #4

          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..!:thumbsup:

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

          1 Reply Last reply
          0
          • K Krishhhhhhhhhhhhhh

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

            A Offline
            A Offline
            Abhishek Sur
            wrote on last edited by
            #5

            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:

            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

            1 Reply Last reply
            0
            • K Krishhhhhhhhhhhhhh

              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

              A Offline
              A Offline
              Abhijit Jana
              wrote on last edited by
              #6

              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.

              1 Reply Last reply
              0
              • K Krishhhhhhhhhhhhhh

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

                A Offline
                A Offline
                Abhijit Jana
                wrote on last edited by
                #7

                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 ! :-D

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

                1 Reply Last reply
                0
                • K Krishhhhhhhhhhhhhh

                  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

                  F Offline
                  F Offline
                  farogh haider
                  wrote on last edited by
                  #8

                  Hi, If you want to send mail automatically without open website, you should create jobs and scheduler in sqlserver which will run everytime

                  Farogh Haider Web developer

                  1 Reply Last reply
                  0
                  Reply
                  • Reply as topic
                  Log in to reply
                  • Oldest to Newest
                  • Newest to Oldest
                  • Most Votes


                  • Login

                  • Don't have an account? Register

                  • Login or register to search.
                  • First post
                    Last post
                  0
                  • Categories
                  • Recent
                  • Tags
                  • Popular
                  • World
                  • Users
                  • Groups