I am a bit new to web development but I am trying to setup a website where a user can enter in a threshhold that if data that is continually coming into the database reaches a certain level it will send an email. My question is how do I create an event
like this in a C# based web site?
please clarify: what user(s)?: yourself? an i.t. administrator? your website end users? other?
natron61
in a threshhold that if data that is
continually
what threshold?: visits? characters sent?
what data?
define continually ... do you mean something per minute? per second? other?
natron61
coming into the database
what database?: MS SQL Server? other?
natron61
in a C# based web site?
do you mean ASP.NET MVC 4? other?
g.
B-) Please help me by completing my school survey about computer programmers on my website. Thank you!!! Gerry Lowry +1 705-429-7550 wasaga beach, ontario, canada
B-) Please help me by completing my school survey about computer programmers on my website. Thank you!!! Gerry Lowry +1 705-429-7550 wasaga beach, ontario, canada
If the database that you are using supports triggers then this is a good use for an OnInsert trigger. The theshold that the user has entered would be saved in to a table and then when the OnInsert trigger fires the new value could be compared to the one that
the user entered and do whatever you want.
I do know a trigger in the database would be best for this. I was hoping to some how take care of this outside of the database. The database is a third party database that I would rather not add any objects. I have created a separate schema where it stores
my website settings and so forth. Basically want I need is for a user to be able to set a threshold in my schema and then if that threshold gets exceeded at anytime in data that comes from a third party schema then fire off an email.
natron61
0 Points
3 Posts
C# Web Site - Need data driven email alreats
Jan 17, 2013 01:53 PM|LINK
I am a bit new to web development but I am trying to setup a website where a user can enter in a threshhold that if data that is continually coming into the database reaches a certain level it will send an email. My question is how do I create an event like this in a C# based web site?
gerrylowry
All-Star
20513 Points
5712 Posts
Re: C# Web Site - Need data driven email alreats
Jan 18, 2013 02:18 PM|LINK
@ natron61 welcome to forums.asp.net
what technology are you using? ASP.NET MVC 4? other?
TIMTOWTDI =. there is more than one way to do it
BTW, imho, this is worth your time:
http://weblogs.asp.net/gerrylowry/archive/2012/11/10/clarity-is-important-both-in-question-and-in-answer.aspx
please clarify: what user(s)?: yourself? an i.t. administrator? your website end users? other?
what threshold?: visits? characters sent?
what data?
define continually ... do you mean something per minute? per second? other?
what database?: MS SQL Server? other?
do you mean ASP.NET MVC 4? other?
g.
natron61
0 Points
3 Posts
Re: C# Web Site - Need data driven email alreats
Jan 18, 2013 10:49 PM|LINK
I am using Visual Studio 2010 making a Website with C#. That is about as far as I have gotten.
gerrylowry
All-Star
20513 Points
5712 Posts
Re: C# Web Site - Need data driven email alreats
Jan 18, 2013 11:04 PM|LINK
@ natron61
Did you notice my questions to you, above?
The clearer the information you can give, the better the chance that you will get quality answers from your peers here at forums.asp.net.
it seems that you've not gotten very far at all; please correct me if i'm wrong.
it sounds like you're new to the .NET Framework and to c# ... again, please correct me if i'm wrong.
if i'm correct in my assumptions, and if you're willing to invest your time, then imho it's worth your time to
(a) read this: http://wekeroad.com/2009/04/22/i-spose-ill-just-say-it-you-should-learn-mvc
(b) watch the six hours (10 lessons) of pluralsight essential videos that you will find here: http://www.asp.net/mvc
if you need help with c#, you will find tutorials here: http://msdn.microsoft.com/en-us/vstudio/hh341490 "Learn Visual C#"
Bob Tabor's website offers FREE training too: http://www.learnvisualstudio.net/
g.
Paul Linton
Star
13403 Points
2531 Posts
Re: C# Web Site - Need data driven email alreats
Jan 20, 2013 06:41 AM|LINK
natron61
0 Points
3 Posts
Re: C# Web Site - Need data driven email alreats
Jan 21, 2013 08:25 PM|LINK
I do know a trigger in the database would be best for this. I was hoping to some how take care of this outside of the database. The database is a third party database that I would rather not add any objects. I have created a separate schema where it stores my website settings and so forth. Basically want I need is for a user to be able to set a threshold in my schema and then if that threshold gets exceeded at anytime in data that comes from a third party schema then fire off an email.
Paul Linton
Star
13403 Points
2531 Posts
Re: C# Web Site - Need data driven email alreats
Jan 21, 2013 09:33 PM|LINK
If you can't use a trigger then I think that you will have to poll unless the external data provider can notify you that new values are available.