|
|
as we call stored procedure in asp.net page same as how we call any trigger of sql in asp.net page
i created trigger but wanted to use that in application
Thanks for prompt reply
rizvan sivally
|
|
|
|
|
Dear I already said you can not call Trigger explicitly. Have you read provided link? Better to ask question you must read first about Triggers how it works and why it's required
Parwej Ahamad
|
|
|
|
|
my question is that how to use the trigger in asp.net application
meaning that path or connection string or any query to execute the trigger in web application
rizvan sivally
|
|
|
|
|
which type of trigger this is ? Lets say it is on update then update any record when you want it triggered
Rizwan Bashir
<a href="http://www.alm-soft.com/">ALM Soft</a>[<a href="http://www.alm-soft.com/" target="_blank" title="New Window">^</a>]
|
|
|
|
|
Sir i created trigger(insert,update,delete) as we can call stored procedure(insert,update,delete table)
but the question is how we use this trigger in web application as we created in sql server to fire them.
rizvan sivally
|
|
|
|
|
so your triggers are not Database oriented, basically a code in asp.net is required to be run lets say every one hour , if it is so then use Timer which will be run on background and wont require any one to browse the page to trigger it like window service.
check this for timer ( the last post on this page)http://forums.asp.net/t/1187287.aspx/1[^]
Rizwan Bashir
<a href="http://www.alm-soft.com/">ALM Soft</a>[<a href="http://www.alm-soft.com/" target="_blank" title="New Window">^</a>]
|
|
|
|
|
As the name suggests - 'Trigger', these triggers are automatically fired. And according to my knowledge, one cannot fire the trigger explicitly.
That means, they get automatically fired when the task for which they have been made occurs. i.e. when some data is inserted / updated / deleted in the table.
For eg. If you have made an insert trigger on a table, it will be fired only when some data is inserted in it..and so on. You don't have to call / fire these triggers in your code.
|
|
|
|
|
You do not need to use the triggers through ASP.Net. They will be automatically fired by SQL.
I quit being afraid when my first venture failed and the sky didn't fall down.
|
|
|
|
|
the next question is that
is that possible to restrict to insert,update and delete data by trigger in the database and in web application
if possible
then what will be query of the trigger
rizvan sivally
|
|
|
|
|
Yes, It is possible to restrict DML by triggers.
You said that you have already made triggers. Then you only have to edit them and add your logic for restricting some action. It must be in if-else construct. If the action is not valid according to your logic, then just add 'Rollback Transaction' in your if construct! And you're done!
You have just restricted the invalid DML!
Enjoy!
For further details, Visit this[^]
modified 26-Sep-11 11:20am.
|
|
|
|
|
|
|
Thanks alot sir
as we know what ever we put the message in the trigger it will show after action is fired in database.
now question is that is trigger also restrict any data to insert,delete or update in database as well as for webapplication
Thnaking you again
rizvan sivally
|
|
|
|
|
|
[]
May this link helps you.... 
|
|
|
|
|
Can we use AutoCompleteExtender inside ModalPopupExtender?
|
|
|
|
|
The auto complete list of the AutoCompleteExtender won't appear because it has a z-index value less than the modal popup for the ModalPopupExtender. You can fix this by setting the value of the z-index to a greater value just when the list is shown.
<ajax:AutoCompleteExtender ID="ace" runat="server" OnClientShown="ShowOptions">
</ajax:AutoCompleteExtender>
<script language="javascript" type="text/javascript">
function ShowOptions(sentder, args) {
sender._completionListElement.style.zIndex = 10003; // or greater than modal popup
}
</script>
Help people,so poeple can help you.
|
|
|
|
|
hi
I have a problem who put data from SqlDataSource in dropdownlist
|
|
|
|
|
It was the Tinkleberry Fairy
If your actions inspire others to dream more, learn more, do more and become more, you are a leader." - John Quincy Adams
You must accept one of two basic premises: Either we are alone in the universe, or we are not alone in the universe. And either way, the implications are staggering” - Wernher von Braun
|
|
|
|
|
It could have been anybody.
Who has access to your system?
Was it that guy from the greengrocers?
Seriously, how can we possibly answer that, we don't have 24 hour global surveillance (Although the hamsters seem to know far more than they should).
------------------------------------
I will never again mention that I was the poster of the One Millionth Lounge Post, nor that it was complete drivel. Dalek Dave
CCC Link[ ^]
Trolls[ ^]
|
|
|
|
|
I fell off the chair laughing at this one........ OP would have certainly got the answer..
I quit being afraid when my first venture failed and the sky didn't fall down.
|
|
|
|
|
Hello,
I have 2 Windows servers on LAN with Win2k and win2k3 server respectively.
When using Win2k with IIS 5.0 I am able to develope new Websites with Visual Studio 2008 and 2010 and put the files on the server directly, by using the http option when creating a new solution.
This is unfortunately not the case when using Win2k3 with IIS 6.0. The message I receive is something like "Front Page extensions are not installed on IIS". But this is not true, they are installed as I see on Windows Components under "Add/Remove Programmes"
Any hint I found on the Internet, in MS's website, googling etc. didn't help. Maybe someone here has an advice for me?
Thanks in advance.
|
|
|
|
|
I am data binding to many FormView controls using EF entity instances, but I have to resort to this ridiculous kludge in order to achieve what I want without using EntityDataSource controls:
propertyHeaderSection.DataSource = new List<PropertyDetailsModel> { _propertyDetails }
I suspect I will have to derive my own control from FormView and enable it to accept an almost POCO as a data source. Where do I start?
|
|
|
|
|
Hi
I have a repeater control and I used array list as the data source.
This array has only one field and it's a number to be used as the identification.
how can i format the image server control url in my data repeater to show the right image with right Id!
thank you so much
Here is my source code:
List<int> lstID = new List<int>();
var query2 = context.Offers.Select(p => new { itemId = p.OfferId }).Skip(1).Take(6).ToList();
foreach (var item in query2)
{
lstID.Add(item.itemId);
}
RepeaterOthers.DataSource = lstID;
RepeaterOthers.DataBind();
and here is where i'd like to use that offerId:
<asp:Repeater ID="RepeaterOthers" runat="server">
<ItemTemplate>
<asp:Image ID="ImageFront" runat="server" ImageUrl="~/images/{0}.jpg" />
</ItemTemplate>
</asp:Repeater>
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
