How to update records of a table automatically based on date - ASP.NET Discussion Boards

Re: update global.asax variable from javascript

Petr Pechovic10-Dec-09 10:36

10-Dec-09 10:36

Hi Munteanu,

Create a page or a web service to increase your value. Use AJAX request to call the page/web service. For the web service you can use generated proxy javascript classes to call it. For the page you can use for example jquery to call it. http://docs.jquery.com/Ajax

Petr Pechovic

my latest articles:
Web Page Loading in Steps - ASP.NET Solution[^]
Buttons, Message Box and Confirm Box in ASP.NET 3.5[^]

Re: update global.asax variable from javascript

Munteanu Ciprian10-Dec-09 18:17

Munteanu Ciprian

10-Dec-09 18:17

Can you give me an example please? (with some code)

Re: update global.asax variable from javascript

Petr Pechovic10-Dec-09 19:58

Petr Pechovic

10-Dec-09 19:58

Hi,

just create ASP.NET page. On page_load increment your value.

public partial class my_page : System.Web.UI.Page {

        protected void Page_Load(object sender, EventArgs e) {
            // increment your value
        }
    }

from the JavaScript call your page:

$.get('my_page.aspx');

Petr Pechovic

my latest articles:
Web Page Loading in Steps - ASP.NET Solution[^]
Buttons, Message Box and Confirm Box in ASP.NET 3.5[^]

Re: update global.asax variable from javascript

Munteanu Ciprian11-Dec-09 1:46

Munteanu Ciprian

11-Dec-09 1:46

Are you sure this is the correct way to call the page in javascript: "$.get('my_page.aspx');"? I've tried and it's not working...

Re: update global.asax variable from javascript

Petr Pechovic11-Dec-09 2:48

Petr Pechovic

11-Dec-09 2:48

yes

you have to download the jQuery library and add the script reference to it. It's just one file. Here: jQuery mini[^]

Petr Pechovic

my latest articles:
Web Page Loading in Steps - ASP.NET Solution[^]
Buttons, Message Box and Confirm Box in ASP.NET 3.5[^]

Re: update global.asax variable from javascript

Munteanu Ciprian11-Dec-09 2:53

Munteanu Ciprian

11-Dec-09 2:53

And how do I add the script reference and where should I put the file?

Re: update global.asax variable from javascript

Munteanu Ciprian11-Dec-09 3:15

Munteanu Ciprian

11-Dec-09 3:15

I've done it! Thanks a lot for your time and help!

How to update records of a table automatically based on date

Krishhhhhhhhhhhhhh10-Dec-09 7:11

Krishhhhhhhhhhhhhh

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

Richard MacCutchan

10-Dec-09 7:24

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

Re: CROSSPOST

Krishhhhhhhhhhhhhh10-Dec-09 7:31

Krishhhhhhhhhhhhhh

10-Dec-09 7:31

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

Re: CROSSPOST

Richard MacCutchan10-Dec-09 7:35

Richard MacCutchan

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.

Re: CROSSPOST

Krishhhhhhhhhhhhhh10-Dec-09 7:41

Krishhhhhhhhhhhhhh

10-Dec-09 7:41

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

Re: CROSSPOST

Richard MacCutchan10-Dec-09 7:52

Richard MacCutchan

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.

Re: CROSSPOST

Krishhhhhhhhhhhhhh10-Dec-09 7:55

Krishhhhhhhhhhhhhh

10-Dec-09 7:55

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

Re: CROSSPOST

Richard MacCutchan10-Dec-09 7:58

Richard MacCutchan

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.

Re: CROSSPOST

Krishhhhhhhhhhhhhh10-Dec-09 8:06

Krishhhhhhhhhhhhhh

10-Dec-09 8:06

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

Re: CROSSPOST

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 | :)

Re: CROSSPOST

Bassam Saoud10-Dec-09 8:41

Bassam Saoud

10-Dec-09 8:41

I answerd your question Smile | :)

Re: CROSSPOST

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

Re: CROSSPOST

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

Krishhhhhhhhhhhhhh

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

Re: Send an auto mail

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

Re: Send an auto mail

Krishhhhhhhhhhhhhh10-Dec-09 7:08

Krishhhhhhhhhhhhhh

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?

Re: Send an auto mail

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.

Re: Send an auto mail

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

Use Ctrl+Left/Right to switch messages, Ctrl+Up/Down to switch threads, Ctrl+Shift+Left/Right to switch pages.