SQL Server :: Trigger Operations Application Code
Dec 6, 2010I have many operations in the database that need to trigger asp.net applicaton code with service broker in sql server 2005
View 5 RepliesI have many operations in the database that need to trigger asp.net applicaton code with service broker in sql server 2005
View 5 RepliesData from the server subscription cannot trigger table trigger
View 2 RepliesHow can we log user operations for a asp.net application. Further what is the approach for saving the log data ?
View 3 RepliesI recently purchased a new domain for the sole purpose of hosting all the static content on a separate server and delegate CPU intensive operation like thumbnail creation on a different pool. Now I would like to do some operations on images uploaded to that remote server : creating thumbnails or updating the image if we need to. Should I download the images to my server, modify them there and then upload them back to the remote server or should I try to create web-services to manipulate the images?One of my solution was to provide an interface to upload and manipulate the images in the new domain, by leaving the old domain when it comes time to work on images, but I find it kind of awkward.I would like to keep the new domain cookie free. How would that affect my ability to restrict any random user to use the web-services if I decide to go that way?
View 1 RepliesHow do I ensure and enforce that all write operations to my MS SQL Server DB are transactions-based?
The reason I want to do this is that the DB contains financial account data and operations that fail halfway through some set of changes should not be able to mess up the database by mistake or by crashing.
The application is written in ASP.NET C#.
Edit:
There is a DAL but it does not (yet) require transactions for changes.We wrote the DAL ourselves. We did not use ORM.
I know how to perform one transaction from ASP.NET.
I want to ensure that all changes are made in transaction form so that if the application throws some exception in the middle, there will be no change to the database.
Today my client has asked me to do Data Base Log,that is if any change done like,Insert or Edit or delete that has to be viewable in Log Report,if somebody did even a Small change that also has to be keep track and has to display in Log Report,like the recent activity is so and so and so and so person has done this.
View 1 RepliesI am trying to write some code where it sets the imageUrl of an ASP Image from the codebehind (on a timer), but it does not change it on my screen (its changing in debug view). I assume this is because I need to postback everytime I change the image. Problem is, I cant trigger the postback from CodeBehind so that it will change. How do I do that?
[Code]....
I am so used to win32 forms -- Just started again with ASP websites.
Situation: I have a web application which shows errors and where you can accept those error messages. I also have a service, which checks errors from a system and sets the error messages in the database. When I accept an error in the web application, i would like the service to know which error message has been accepted, so that it can do some other actions. My guess is that this could be done through some sort of trigger, but i can't figure out how.
View 1 RepliesI want to trigger a client application when a button in the browser is pressed. I want o have a button in the browser that says "Record sound". When its clicked a client app starts recording the sound (in this case a call via Skype). How can I do this? Or perhaps there already is a browser based application/plugin that does this?
View 1 RepliesI am using an AJAX CollapsiblePanelExtender for several sections of a form. I can collapse a panel programatically using the following 2 lines:
ajaxCollapsiblePanelExtender1.Collapsed = true;
ajaxCollapsiblePanelExtender1.ClientState = "true";
However, the expand/collapse animation does not play as when the Expand/CollapseControlID is clicked. It simply appears in the collapsed state. Is it possible to trigger this animation programatically?
I have a javascript script that displays an overlay Processing Screen when user submits the form. I have the Javascript onClientClick event. Since this is a form I need to do validation and I dont want the screen to come up while I do the validation. It should only come up once the validation is successful. Validation is done server side. I need to do something when the validation is successful only then the processing screen should come up. Cause once the validation is successful the page is redirected to other page and it takes lot of time until the other page comes up.
View 2 RepliesI have a graphical user interface for my company product.I want to secure the data being sent back and forth between client and server.
Is SSL one of the options? some1 tell me the steps on how to implement it in my application code.
Do i need to buy the certificate or can i make it.. which is the best choice?
I am logging in using FormsAuthenticationTicket as follows:
Session["userName"] = UserName.Text;
Session["password"] = Password.Text;
Session["domain"] = Domain.Text; [code]....
How to do trigger a javascript code after client validation?
View 6 RepliesAnyway i'm using RegularExpressionValidator and CompareValidator to check on textbox errors.
Now when i press a button it will go to my code and i will then try to detect for RegularExpressionValidator or CompareValidator errors by doing:
If not RegularExpressionValidator.IsValid
Now the question is if there is a way to bind the button with the validators so it will not trigger the code if the expressions are wrong.
I would have goggled it but i don't know exactly what to write on the search box.So i get un-useful results.
I feel like a neewbie for this question but I can not make my linkbutton to trigger when created from code behind.What am I missing here?
this is what I got.
[Code]....
Is it possible to substitute submit button which triggers QueryExtender filtering by a code?
how would you do it?
I have a web page that I am trying to use modal popup extender with aLink button as trigger (Code Below). When I execute the code and click on the link button (TargetId) the parameter for graying out the page below the popup works but I do not see the ModalPopup panel
[Code]....
I have UpdatePanel with GridView and i want register posback triger for index changing and asyncpostback for pagging and sorting.
When registering AsyncPostback (with event) and Postback in one control i have ASP event.
How go around this problem? , dynami register triggers mayby is a solution but i can`t unregister triger.
I am building service failure notification system which notifies customers and management whenever there is a delay in the service. How can I use SQL SERVER trigger to send an email to a group of people when I add an alert in the alert database table using c#.
View 3 RepliesAn external application come to my database for inserting row in a Sql server table.I have a web application on my own, and I want on each insert in this table, do some treatement server side.My idea is to create a trigger on insert on the table, and then call appropriate function
View 2 RepliesI'm creating an application that's supposed to first add a record to table1, and then get the ID from that record to use when adding a record to table2, to be able to associate these two records with eachother.
The user gets to type in some values that goes to table1, and some values that goes to table2, but before the insert statement for table2 is executed i need the ID from the recently added record in table1. Some dude told me to use a trigger for the autopopulate purpose, but does that really work when i also need to save some values that's user input, and when those values doesn't get saved in table1?
Are there any other way to do this or can i send values to a trigger?
i want to create a trigger after i insert record in table1 and in trigger there will be an update sentece which updates x column in table2 so i have a stored procedure like insert into Table1(a,b,c) values(1,2,3)select @@identity then my trigger should update table 2 update table2 set x=5 where id=@a @a parameter must come from my insert stored procedure's select @@identity line how can i create a trigger like this? this will be my first trigger so i dont know anything about them after creating trigger i think i should control if it execute successfully or not in my insert stored procedure so if it works successfully my insert is ok but if trigger doesnt work my insert sentence shouldnt work
View 7 RepliesIf I use trigger, I do not need the table to determine cascade update?
View 3 RepliesI M little bit confuse that Presently i m using SQL server 2005 and for data access i m using Store procedure but now i want to use trigger first thing about trigger is:-
1. what is the benefit of using trigger over store procedure?
2. Is Performance is effected if i use trigger i mean that is my site work fast or is it much secure.
i need trigger function for update. if a change value of a column in one table. The value of different column from the second table should update the value in the third table.
View 18 Replies