Re: Trigger in asp.net - ASP.NET Discussion Boards

First Prev Next

Re: Trigger in asp.net

Rizwan Bashir24-Sep-11 6:15

Rizwan Bashir

24-Sep-11 6:15

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>]

Re: Trigger in asp.net

Tech Code Freak25-Sep-11 6:13

Tech Code Freak

25-Sep-11 6:13

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.

Re: Trigger in asp.net

Pravin Patil, Mumbai26-Sep-11 1:48

Pravin Patil, Mumbai

26-Sep-11 1:48

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.

Re: Trigger in asp.net

sheemap26-Sep-11 2:06

sheemap

26-Sep-11 2:06

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

Re: Trigger in asp.net

Tech Code Freak26-Sep-11 5:03

Tech Code Freak

26-Sep-11 5:03

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.

Re: Trigger in asp.net

sheemap26-Sep-11 5:35

sheemap

26-Sep-11 5:35

Thanking you

Re: Trigger in asp.net

Pravin Patil, Mumbai26-Sep-11 1:47

Pravin Patil, Mumbai

26-Sep-11 1:47

You first need to understand the trigger.

Here is a brief explanation :
Trigger is native to SQL and not to ASP.NET. Trigger is a code segment in SQL that gets executed when a specified condition is met. There are three types of trigger Inser, Update, Delete trigger. Insert Trigger will be executed when you insert a new row into the table. Same applies to update and delete trigger. So with this much explanation you must be clear that Trigger is the thing that is not called explicitly, rather SQL server will automatically execute your trigger when you insert, update or delete any record from the table.

Coming back to your question :
As you said, you know how to call a stored procedure, so call it as you do. Write a trigger on your desired table for a insert/update/delete operation. When the specified operation is performed in the Stored Procedure, trigger will be automatically fired by SQL.

Important : Trigger is in SQL and not ASP.NET. Trigger can not be executed explicitly as you do Stored Procedure. Trigger is taken care by SQL server.

For further reference :
How to Write Trigger
1. http://msdn.microsoft.com/en-us/library/ms189799.aspx[^]
2. http://www.sqlservercentral.com/Forums/Topic351362-92-1.aspx[^]
3. http://download.oracle.com/docs/cd/B12037_01/server.101/b10759/statements_7004.htm[^]

How Trigger Works
1. http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/47865;pt=47764[^]
2. http://download.oracle.com/docs/cd/B28359_01/appdev.111/b28370/triggers.htm[^]

Hope this helps.
All the best.

I quit being afraid when my first venture failed and the sky didn't fall down.

Re: Trigger in asp.net

sheemap26-Sep-11 1:56

sheemap

26-Sep-11 1:56

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

Re: Trigger in asp.net

Pravin Patil, Mumbai26-Sep-11 18:42

Pravin Patil, Mumbai

26-Sep-11 18:42

Yes for sure, if you do not want any invalid to insert in the database then also you can use the trigger. But again there are two options to do so..

Option 1:
Use the Constraints
1. http://dev.mysql.com/doc/refman/5.0/en/constraint-invalid-data.html[^]
2. http://download.oracle.com/docs/cd/B28359_01/server.111/b28310/general005.htm[^]
3. http://odetocode.com/articles/79.aspx[^]

Option 2:
Use Trigger
1. http://manuals.sybase.com/onlinebooks/group-as/asg1250e/sqlug/@Generic__BookTextView/48841;pt=48327/*[^]
2. Just do the rollback in the trigger to restrict the data

Maintain data integrity: http://ss64.com/ora/syntax-constraints.html[^]

I would recommend you using the first approach, because Triggers are not that easy when it comes to maintainance of the project.

Hope this helps.
All the best.

I quit being afraid when my first venture failed and the sky didn't fall down.

Re: Trigger in asp.net

NikulDarji27-Sep-11 0:41

NikulDarji

27-Sep-11 0:41

[]
May this link helps you.... Smile | :)

AutoCompleteExtender inside ModalPopupExtender

PleaseHelpCP23-Sep-11 19:08

PleaseHelpCP

23-Sep-11 19:08

Can we use AutoCompleteExtender inside ModalPopupExtender?

Re: AutoCompleteExtender inside ModalPopupExtender

Ali Al Omairi(Abu AlHassan)25-Sep-11 20:50

Ali Al Omairi(Abu AlHassan)

25-Sep-11 20:50

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.

XML

<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.

DropDownList

reyhane ramezanian23-Sep-11 6:02

reyhane ramezanian

23-Sep-11 6:02

hi
I have a problem who put data from SqlDataSource in dropdownlist

Re: DropDownList

TheGreatAndPowerfulOz23-Sep-11 6:24

TheGreatAndPowerfulOz

23-Sep-11 6:24

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

Re: DropDownList

Dalek Dave25-Sep-11 21:40

Dalek Dave

25-Sep-11 21:40

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[^]

Re: DropDownList

Pravin Patil, Mumbai26-Sep-11 1:51

Pravin Patil, Mumbai

26-Sep-11 1:51

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.

Creating a new Website Solution by using http doesn't work

nstk23-Sep-11 0:57

nstk

23-Sep-11 0:57

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.

On data binding EntityObjects to a FormView.

Brady Kelly22-Sep-11 22:46

Brady Kelly

22-Sep-11 22:46

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?

format a string in Data Repeater (list array as a data source)

Farhad Eft22-Sep-11 20:25

Farhad Eft

22-Sep-11 20:25

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>

Re: format a string in Data Repeater (list array as a data source)

Parwej Ahamad22-Sep-11 23:20

Parwej Ahamad

22-Sep-11 23:20

ASP.NET

<asp:Image ID="ImageFront" runat="server" ImageUrl='<%# String.Format("~/images/{0}.jpg", Container.DataItem) %>' />

I haven't tested but this should be work. If doesn't work the let me know.

Thanks

Parwej Ahamad

Re: format a string in Data Repeater (list array as a data source)

Farhad Eft22-Sep-11 23:37

Farhad Eft

22-Sep-11 23:37

thank u so much man! it worked!

recently i lost my old projects files that i programmed before now i know nothing without it! lol

Re: format a string in Data Repeater (list array as a data source)

Parwej Ahamad22-Sep-11 23:41

Parwej Ahamad

22-Sep-11 23:41

Your Welcome!

Parwej Ahamad

Issue with modalpopup on master page.

shock58922-Sep-11 19:23

shock589

22-Sep-11 19:23

Hi....

I am working on modalpopup on master page and i am trying to call it from a content page.
On master page i hv used a modal popup on master page as--

<asp:modalpopupextender id="mpePattern" runat="server" okcontrolid="btnOkay" cancelcontrolid="btnCancel"
="" popupcontrolid="pnlPopup" targetcontrolid="hiddenTargetControlForModalPopup" backgroundcssclass="modal" behaviorid="programmaticModalPopupBehavior" popupdraghandlecontrolid="PopupHeader" drag="true" dropshadow="true">

The issue is that when i try to find out the id or make object of this modal popup in Javascript ..it says null..

i have tried $find('mpePattern').show() as well as
documen.getElementById('mpePattern') but nothing working out....please help...

Gourav Kaila

Re: Issue with modalpopup on master page.

Parwej Ahamad22-Sep-11 23:24

Parwej Ahamad

22-Sep-11 23:24

Because your Modal Popup control is inside the master page control. So first you have to find Masterpage control then Modal Popup control. OR just go to page view source see the actual rendered Madalpopup control id.

Parwej Ahamad

Re: Issue with modalpopup on master page.

jagdish Bhandari23-Sep-11 1:16

jagdish Bhandari

23-Sep-11 1:16

Hi Gourav,

If you want to open ModalPopupExtender from the content pages using javascript, Use BehaviourID in place of ID.

Like that

<asp:ModalPopupExtender ID="mpePattern" runat="server" OkControlID="btnOkay" CancelControlID="btnCancel"
PopupControlID="pnlPopup" TargetControlID="hiddenTargetControlForModalPopup"
BackgroundCssClass="modal" BehaviorID="programmaticModalPopupBehavior" PopupDragHandleControlID="PopupHeader" Drag="true" DropShadow="true">

Javascript call:

$find('programmaticModalPopupBehavior').show();

I hope it will work.

Last Visit: 31-Dec-99 18:00 Last Update: 24-Apr-24 12:58

Refresh

ᐊ Prev 1...608 609 610 611612613 614 615 616 617 Next ᐅ

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