ASP.NET

23-Sep-11 21:44

hiiiiiii to al one canl

any one can hep me that i wanted to set trigger in asp.net web page by sql server

how to call that trigger in web page

please help me to sort out this problem

rizvan sivally

Parwej Ahamad23-Sep-11 21:54

Parwej Ahamad

23-Sep-11 21:54

As per my knowledge Trigger is execute itself based on DML and DML. So you can not call explicitly.

http://msdn.microsoft.com/en-us/library/ms189799.aspx[^]

Parwej Ahamad

sheemap23-Sep-11 22:01

23-Sep-11 22:01

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

Parwej Ahamad23-Sep-11 22:03

Parwej Ahamad

23-Sep-11 22:03

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

sheemap23-Sep-11 22:11

23-Sep-11 22:11

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

Rizwan Bashir24-Sep-11 4:47

Rizwan Bashir

24-Sep-11 4:47

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

sheemap24-Sep-11 5:04

24-Sep-11 5:04

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

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

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.

Pravin Patil, Mumbai26-Sep-11 1:48

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.

sheemap26-Sep-11 2:06

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

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.

sheemap26-Sep-11 5:35

26-Sep-11 5:35

Thanking you

Pravin Patil, Mumbai26-Sep-11 1:47

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.

sheemap26-Sep-11 1:56

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

Pravin Patil, Mumbai26-Sep-11 18:42

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.

AutoCompleteExtender inside ModalPopupExtender

NikulDarji27-Sep-11 0:41

NikulDarji

27-Sep-11 0:41

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

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