|
Dear Sir,
I am new to asp.net and sql server 2005. I am working on a multi level marketing website in asp.net. In this i had made a binary tree in sql server table. Now I have to write a query to access the record of particular node including its left and right child. Please help me out.....
|
|
|
|
|
Hi
I am hosting a website for my client developed in C# 3.5 framework. Application has all valid Urls generated. however this site was previously developed in PHP which allowed double quotes in Urls.
now within asp.net I am unable to handle double quotes requests in url from different search engines.
Can any one please help me out to handle double quote problems in url so it is redirected to any specific Url ?
details are
windows 2003 server with IIS 6
Dotnet Framework 3.5
Some sites adviced about changing the some registry and restarting machine but nothing helped.
is there any way to block or redirect those urls ?
Thanks in advance
Best Regards
Rizwan Bashir
|
|
|
|
|
|
This is my site and one of many urls, I dont have this deal on my website nor I did generated this Url but I do get this requests from different IP Addresses
http://www.nobrainerdeals.com/deal/Astar_32"_LCD_TV_Display_with_Stand/[^]
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>]
|
|
|
|
|
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
|
|
|
|
|
|
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
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
