i need trigger function for update. if a change value of a column in one table. The value of different column from the second table should update the value in the third table.
View 18 RepliesAn external application come to my database for inserting row in a Sql server table.I have a web application on my own, and I want on each insert in this table, do some treatement server side.My idea is to create a trigger on insert on the table, and then call appropriate function
View 2 RepliesI have a print button and I want to trigger the modalpopupextender and trigger the server side Button1_Click Sub.The print button calls a function that constructs a html table with the values of the gridview selected row.How can I open the modalpopupextender and trigger the server side function at the same time with the same button?
View 2 RepliesIf I use trigger, I do not need the table to determine cascade update?
View 3 RepliesI have a Wherehouse app where I have my Inventory table wich has columns like id, code, description,Price1, Price2,Price3 and another table wich is orderdetail with columns id, ordernum, code, quantity.
I recenlty add the columns Price1, Price2,Price3 into orderdetail and I need to populate those columns on the background beacuse users are not allow to see the prices.( I´ts has to be populate when the user insert a new item into the orderdetail table)
I´m usig Sql Server 2000 developer editon.
Data from the server subscription cannot trigger table trigger
View 2 RepliesI am building a system for a school project. I currently have several Update Panels on the page that have many different controls on them. I also have a single Label control that i use to display messages to the user. I would like to have this label within an update panel also but there are literally hundreds of triggers that would require it to be updated and i dont want to type an absurd number of triggers for this one control.Is there a way for me to have this one panel update regardless of what happens?
View 2 RepliesI have update panel , in update panel i have one button control which exposes onlientClick event ( it dosent have click event to do postback to server).
and i have one updateprogress panel. So my problem is though i'm performing operation on client side , internally the async event is firing and making updateprogress panel to act (having rotation gif image) which i dont want , as it rotates for 10-15 sec more even after the operation at client side is done !
Here's my scenario:
I'm using the ASP.Net Membership provider, but I don't want to allow system administrators to DELETE any users. Instead, I simply want to mark them as locked out (aspnet_Membership.IsLockedOut) of the system so they can't log in when an administrator assigns them to a role titled "Inactive". Make sense? Right now my trigger isn't throwing any errors, but it's not working either. Here's my trigger (which is on the aspnet_UsersInRoles table):
[Code]....
As far as I can see there are only client events on this container, and I need to update a gridview when the user changes tabs.
View 2 RepliesWhat changes to the function below are needed to achieve those requirements:- If you pass the same date, then 1 will be returned as the number of days- Return '5' when passing 18.10.2010 to 22.10.2010 (Mo-Fr.)- Return '0.5' when passing same date with (n) hours difference e.g. from 18.10.2010 08:00:00 and 18.10.10 12:00:00 (maybe I should ask start a new threand for this last one)
[Code]....
as seen from the title my sql doesnt update the data that has been inserted by my function. But in my function it works perfectly as it returns '1' when i executenonquery. however it only works when i insert a record which has a date later than today's date. which is weird as there is no validation in that page and if there were to have a validation, it would not run the function.
View 10 RepliesCan I trigger a javascript function from a validator?Or, can I trigger a javascript function when validators are validated? Before, while, or after?
View 1 RepliesI have created a usercontrol to capture education details, it contains 5 textboxes and an functionto insert that values into my db. I have added the usercontrol 5 times to a page. I have a button on my aspx page which I want to be able to click and call the function to insert the values.
View 2 RepliesI want to trigger my javascript modalpopup with a function show. Is this possible?
[Code]....
I have 2 asp:DropdownLists with an OnSelectedIndexChanged attribute. When that is triggered I would like to run a jquery funtion that would let the user know the data is being processed. How do I jump to my jquery function and is there a way I don't have to use the unique id?
<asp:DropDownList ID="ddlFirst" runat="server" OnSelectedIndexChanged="ddlChange">
asp:ListItem>All</asp:ListItem>
<asp:ListItem>None</asp:ListItem>
</asp:DropDownList>
[code]...
I have a ModalPopupExtender that needs to be hidden whenever the user clicks anywhere else on the page, window, or scrollbar. I have a function and it works if i set it to a div tag but what about when the user clicks the windows scrollbar?
function HideList() {$find("<%=ModalPopupExtender1.BehaviorID%>").hide();
i can populate cascading dropdownlist by using webservice now. but may i know how do i trigger function while selectedindex changed? (without using auto postback...)
View 3 RepliesI have an ASP.NET document, with an Image element within it. I created a mouseover function on this image element and it's working fine. The question is: If the mouse is ALREADY over the element when the document loads itself, the mouseover function doesn't trigger (I need to mouseout and then mouseover again in order to trigger it). Is there any way to check in the $(document).ready function if the mouse is already on top of this element? and if yes- trigger the mouseover function.
View 2 RepliesWhat need to change in asp.net application if web server update from IIS6 to IIS7?
View 2 RepliesUser selects a date from the date-picker and the date is put into a text-box.
But when i choose a date some date should check another text box date and give me the difference. The selection-change event does not fire (as expected).
protected void dtpleavestartdate_SelectionChanged(object sender, EventArgs e)
{
string a = "NO CHANGE";
a = a + dtpenddate.SelectedDate.Subtract(dtpleavestartdate.SelectedDate).ToString();
Response.Write("<script>alert('" + a +"')</script>");
}
I have an asp:TextBox with asp:RegularExpressionValidator to validate if it's a number. Obviously an onchange event will be attached to this textbox while rendering. Also I add a change event at $(document).ready to make some calculation when the value is changed.
<asp:TextBox id="myText" runat="server" />
<asp:regularexpressionvalidator id="myRev" ControlToValidate="myText" runat="server">*</asp:regularexpressionvalidator>
$(document).ready(function(){
$('[id$=myText]').bind('change',function(){
//do something........
and found that all of event.fromElement,event.toElement,event.srcElement are null which causes the exception.
is there an easy way to update a user control from another user control? i have a input box and a submit button. the user inputs a code, hits sumbit and based on the code, points are applied to thier score (another user control). the points are applied to the score in the database but don't show up on the page display until i hit refresh. is there an easy way to update the control on submit?
protected void btn_Add_Coupon_Click(object sender, EventArgs e)
{
try
{
SqlDataSourceTEST.DataSourceMode = SqlDataSourceMode.DataReader;
IDataReader Reader = (IDataReader)SqlDataSourceTEST.Select(DataSourceSelectArguments.Empty);
if (Reader.Read())
{
int iPoints = 0;
iPoints = (int)Reader["Points"];
if (iPoints > 0)
{
Profile.TimesVisited = Profile.TimesVisited + iPoints;
lblcoup.Text = iPoints.ToString() + " have been added to your score!";
}
else
{
lblcoup.Text = "Coupon Code Not Valid";
}
}
Reader.Close();
Reader.Dispose();
}
catch (Exception ex)
{
}
}
I have an UpdatePanel with ContentTemplate specified. When page loads, user can do some AJAX work in other part of the page. Then, after that work is finished, I would like to update only content inside UpdatePanel, but without pressing any buttons etc. I should be done automatically using JavaScript when previously started AJAX work finishes. How to do it without manual clicking on the trigger button?
EDIT:
Ok, I've followed that _doPostBack rule, and whole page is posted.
<asp:UpdatePanel ID="panelAttachments" runat="server">
<ContentTemplate>
........
</ContentTemplate>
</asp:UpdatePanel>
<input type="text" name="test" onchange="__doPostBack('<%=panelAttachments.UniqueID %>',''); return false;" />
</td>
Code Example:
$(document).ready(function() {
txtchangefunction();
});
function txtchangefunction(
$(".textCssClass").change(function () {
....});
or $(".textCssClass").bind('change', function())
both work for Chrome etc. but not IE8. no console error comes out.