|
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>
|
|
|
|
|
<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
|
|
|
|
|
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
|
|
|
|
|
Your Welcome!
Parwej Ahamad
|
|
|
|
|
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
|
|
|
|
|
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
|
|
|
|
|
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.
|
|
|
|
|
Hi,
When I tried to implement the code from this forum to display data in the excel from a webpage, I am getting weird results. I am wondering if you could direct me to correct the problem? I thank you for your help.
The code is :
HttpResponse response = HttpContext.Current.Response;
response.Clear();
response.Charset = "";
//MAKE THE CONTENT TYPE TO EXCEL FORMAT.
response.ContentType = "application/vnd.ms-excel";
response.AddHeader("Content-Disposition", "attachment;filename=\"" + filename + ".xls\"");
// CREATE A STRING WRITER.
using (StringWriter sw = new StringWriter())
{
using (HtmlTextWriter htw = new HtmlTextWriter(sw))
{
// INSTANTIATE A DATAGRID.
GridView dg = new GridView();
dg.DataSource = ds.Tables[0];
dg.DataBind();
dg.RenderControl(htw);
//STYLE TO FORMAT NUMBERS TO STRING.
string style1 = @" .textmode { mso-number-format:\@; } ";
response.Write(sw.ToString());
response.Write(style1);
//response.Flush();
HttpContext.Current.ApplicationInstance.CompleteRequest();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
ds:is the dataset
and filename is the name of the filename.
However, the file contains data as below:
"
"
MonthYearUSERIDApplicationNumOfReturns"
"
08/2011userid12010"
"
08/2011userid22010"
"
08/2011userid32009"
"
08/2011userid42010"
"
"
.textmode { mso-number-format:\@; }
<title>
" Untitled Page"
I am wondering what wrong with my code. Any help is greatly appreciated. Thank you.
|
|
|
|
|
General 
News 
Suggestion 
Question 
Bug 
Answer 
Joke 
Praise 
Rant 
Admin 
Submit an article or tip
