Search results matching tag 'Trigger'

Issue with FormView control inside of TabContainer

chuck-frank — Wed, 12 Aug 2009 04:00:00 GMT

Hello,

I'm having an issue with my formview control and using a tabcontainer. Right now I have a scriptmanger on the masterpage for all pages that are used. I use a treeview control inside of an update panel to control the navigation. This then updates another Update Panel that selects a usercontrol. So from this point the user control should be inside of an update panel. This first sections works perfrectly fine.

So now the formview is inside of an TabContainer in a user control. The data populates correctly, and I have the settings inplace for insert, item, and edit templates. I attempt to place a button on the page and use this to switch between the item view and the edit view templates. When I do this the user control page is removed from the page. I have attempted to wrap the formview as well as the whole template inside of a Update Panel with the approprate triggers. I have attempted to run this with just a formview and button, and it works perfectly. I going to use my test page as a mock and see if I can use an update panel with the formview control. I'm pretty sure that will work as well.

I believe the issue I am having has to do with the TabContainer being used inside of a Update Panel, and the subsequently the formview being inside of that TabContainer.

I can post code if anyone is will to help with my issue. I'm rather new to AJAX(1 week in), and would like to better understand why my formview will not switch properly.

I have attempted to search this forum with no luck :(

Thanks,

Chuck

INSTEAD OF UPDATE Trigger on a View

User45633 — Thu, 06 Aug 2009 04:00:00 GMT

Hello,

I am working on a project that requires that I be able to make changes to a view as though it were a table, and I have concluded that what I need is an INSTEAD OF UPDATE trigger, but my attempts so far to create one have failed. I wanted to see if anyone out there could help me put one together.

Here is the structure of my View:

SELECT     dbo.Addresses.AddressLine1,
    dbo.Addresses.AddressLine2,
    dbo.Addresses.City,
    dbo.Addresses.STProvCode,
    dbo.Addresses.CountRegCode,
    dbo.Addresses.PostalCode,
    dbo.Customer_Addresses.CustomerID AS Customer_Address_CustomerID,
    dbo.Customer_Addresses.AddressID,
    dbo.Customer_Addresses.DateAddressFrom,
    dbo.Customer_Addresses.AddressTypeCode,
    dbo.Ref_Address_Type.AddressTypeCode AS Ref_Address_Type_AddressTypeCode,
    dbo.Ref_Address_Type.AddressTypeDescription,
    dbo.Customers.CustomerID,
    dbo.Customers.FirstName,
    dbo.Customers.MiddleName,
    dbo.Customers.LastName,
    dbo.Customers.SuffixCode,
    dbo.Customers.DateBecameCustomer,
    dbo.Ref_Suffix.SuffixCode AS Ref_Suffix_SuffixCode,
    dbo.Ref_Suffix.SuffixDescription,
    dbo.Ref_STProv.STProvCode AS Ref_STProv_STProvCode,
    dbo.Ref_STProv.STProvDescription,
    dbo.Ref_CountryRegion.CountRegCode AS Ref_CountryRegion_CountRegCode,
    dbo.Ref_CountryRegion.CountRegDescription,
    dbo.Addresses.AddressID AS Addresses_AddressID,
    dbo.Customers.ProjID,
    dbo.Ref_Projects.ProjID AS Ref_Projects_ProjID,
    dbo.Ref_Projects.ProjName,
    dbo.Ref_Projects.ProjLabel,
    dbo.Customers.StatusCode,
    dbo.Customers.AcctStatusCode AS Customers_AcctStatusCode,
    dbo.Customers.Email,
    dbo.Customers.Email2,
    dbo.Customers.Email3,
    dbo.Customers.Phone,
    dbo.Customers.Phone2,
    dbo.Customers.Phone3,
    dbo.Customers.Fax,
    dbo.Customers.EquipWarrantyBeginDate,
    dbo.Addresses.CustomerID AS Addresses_CustomerID,
    dbo.Addresses.LocID,
    dbo.Addresses.HouseType,
    dbo.Addresses.AreaSubdivision,
    dbo.Addresses.OccupancyDate,
    dbo.Addresses.ISWCompDate,
    dbo.Addresses.HomeWarrantyBeginDate,
    dbo.Addresses.NumBedrooms,
    dbo.Addresses.ForeignInsideWireInstalled,
    dbo.Addresses.ForeignSecurityInstalled,
    dbo.Addresses.ForeignCanInstalled,
    dbo.Customers.Notes,
    dbo.Ref_Contact_Status.StatusCode AS Ref_Contact_Status_StatusCode,
    dbo.Ref_Contact_Status.StatusDescription,
    dbo.Ref_Account_Status.AcctStatusCode,
    dbo.Ref_Account_Status.AcctStatusDescription
FROM         dbo.Addresses
    INNER JOIN dbo.Customer_Addresses ON dbo.Addresses.AddressID = dbo.Customer_Addresses.AddressID
    INNER JOIN dbo.Customers ON dbo.Customer_Addresses.CustomerID = dbo.Customers.CustomerID
    INNER JOIN dbo.Ref_Address_Type ON dbo.Customer_Addresses.AddressTypeCode = dbo.Ref_Address_Type.AddressTypeCode
    INNER JOIN dbo.Ref_CountryRegion ON dbo.Addresses.CountRegCode = dbo.Ref_CountryRegion.CountRegCode
    INNER JOIN dbo.Ref_STProv ON dbo.Addresses.STProvCode = dbo.Ref_STProv.STProvCode
    INNER JOIN dbo.Ref_Suffix ON dbo.Customers.SuffixCode = dbo.Ref_Suffix.SuffixCode
    INNER JOIN dbo.Ref_Projects ON dbo.Customers.ProjID = dbo.Ref_Projects.ProjID
    INNER JOIN dbo.Ref_Account_Status ON dbo.Customers.AcctStatusCode = dbo.Ref_Account_Status.AcctStatusCode
    INNER JOIN dbo.Ref_Contact_Status ON dbo.Customers.StatusCode = dbo.Ref_Contact_Status.StatusCode

I was able to put together an INSTEAD OF INSERT trigger to enable me to insert "records" into the view, but I have not been able to create an INSTEAD OF UPDATE trigger that works.

Here is the INSTEAD OF INSERT trigger that I used:

USE [Contact_Management]
GO
/****** Object:  Trigger [dbo].[tr_Customer_View]    Script Date: 07/01/2009 10:00:15 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

ALTER TRIGGER [dbo].[tr_Customer_View] on [dbo].[Customer_View]
INSTEAD OF INSERT
AS
BEGIN

    SET NOCOUNT ON;
    
    insert into Addresses
        select Addresses_CustomerID, LocID, AddressLine1, AddressLine2, City, STProvCode, CountRegCode, PostalCode, HouseType, AreaSubdivision, OccupancyDate, ISWCompDate, HomeWarrantyBeginDate, NumBedrooms, ForeignInsideWireInstalled, ForeignSecurityInstalled, ForeignCanInstalled
        from inserted

    insert into Customers
        select CustomerID, ProjID, StatusCode, Customers_AcctStatusCode, DateBecameCustomer, FirstName, MiddleName, LastName, SuffixCode, Email, Email2, Email3, Phone, Phone2, Phone3, Fax, EquipWarrantyBeginDate, Notes
        from inserted

END

If anyone can help me build an INSTEAD OF UPDATE trigger for use with this view, it would be greatly appreciated.

Thanks,

Tyler

Keep only one record in a table with a certain status

hugonne — Mon, 03 Aug 2009 04:00:00 GMT

Hi all.

I have a table which has a "Status" field. Whenever a record from that table changes its status to 1, which is "Active", I want to automatically chage the rest of the records to 0, which is "Inactive". That way, only one record at a time can be marked as Active. I've tried to accomplish this with a trigger, and it works OK on table inserts, but on updates I can't do, and I get a table mutatin error. I've tried it on before and after trigger types, and haven't been able to make it work.

Any thoughts on how the trigger should be written? Is it possible, or am I gonna have to build a custom SP to insert or update records to that table?

Thanks.

Update Trigger

bcoffey — Mon, 15 Jun 2009 04:00:00 GMT

I currently have the following trigger in place that will move a deleted row of data from one table to another identical table which fires when the user deletes a row:

/****** Object:  Trigger [dbo].[trgTransitListDeleteHistory]    Script Date: 06/15/2009 10:55:50 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
--SET IDENTITY_INSERT ON
--GO
-- =============================================
-- Author:		&lt;Author,,Name&gt;
-- Create date: <Create Date,,>
-- Description:	<Description,,>
-- =============================================
CREATE TRIGGER [dbo].[trgTransitListDeleteHistory]
   ON  [dbo].[tblTransitList]
  FOR DELETE
AS 
BEGIN
	-- SET NOCOUNT ON added to prevent extra result sets from
	-- interfering with SELECT statements.
	SET NOCOUNT ON;

    -- Insert statements for trigger here
INSERT INTO tblTransitListDeleteHistory
SELECT * FROM DELETED

END

I basically would like to do the same thing on an update event, with the exception that I would want to copy the row instead of moving it.  Is this possible via trigger?  Someone is maliciously changing our data.

can't register serialized assembly DLL to mssql 2005

piratejackus — Mon, 15 Jun 2009 04:00:00 GMT

hi i have a project on .net which includes a trigger, written with c#, now after the steps to work with CLR like:

- generates serialization assembly -> on

- Allow unsafe code

- TRUSTWORTHY ON

form the article : http://www.codeproject.com/KB/database/SQLCLR.aspx

i couldn't succeed at last step which is to register my Serialized Assembly DLL to my database. here is what i tried:

CREATE ASSEMBLY [PCTrigger.XmlSerializers] FROM 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\HedeWebService\PCTrigger\bin\Debug\PCTrigger.XmlSerializers.dll'
WITH PERMISSION_SET=EXTERNAL_ACCESS

result:

Msg 6501, Level 16, State 7, Line 6
CREATE ASSEMBLY failed because it could not open the physical file 'C:\Documents and Settings\Administrator\My Documents\Visual Studio 2005\Projects\HedeWebService\PCTrigger\bin\Debug\PCTrigger.XmlSerializers.dll': 5(error not found).

i'm sure that the path of the PCTrigger.XmlSerializers.dll is right. I already read some comments about this error but couln't figure out. also i have another PCTrigger.XmlSerializers.dll file under [samepath]\obj\Debug\PCTrigger.XmlSerializers.dll , but i think i must use the one under \bin. i tried both of them and same result.

need help,thanks.

SQL Server Audit Tables With Membership

r2007 — Tue, 14 Apr 2009 04:00:00 GMT

I would like to make 1 audit table or a copy of each table used for auditing in a SQL Server 2008 database. I found a way to use triggers that will make a copy of the insert/ update into a copy of a table (it would only insert a blank row for a delete) however this approach will not work well for the user table with the membership provider because it is making a update for each page request by updating the lastactivitydate and will grow very large.

What is the best way to implement auditing on all the SQL tables and what is the best way to exclude or conditionally deal with updates to the main user table, not allowing an audit update trigger if it is just updating the lastactivitydate of the user membership table. I would also like to know the record that is deleted from a trigger. I made a custom membership provider for this.

Thanks

Accordion Pane, UpdatePannel Trigger and Control trigger problem

onofalt — Wed, 25 Feb 2009 05:00:00 GMT

Hi boys,

sorry for my english i already try a search on the forum but i don't found any answer.

I'm use Ajax Control Toolkit and i use the Accordion Pane where in content i put an update panel with a roundbutton list and same listitem added at runt-time (at page_load) in contenttemplete area with autopostback="False".

The problem is that Update Pannel has an AsyncPostBackTrigger on roundbottonlist on event SelectedIndexChanged but event don't fire.

P.s. I'm use last stable buld of Ajax Control Tollkit For Asp.net 3.5 Framework

Thanks a lot

Onofalt

button

choong14 — Tue, 17 Feb 2009 05:00:00 GMT

Hi,

I would like to know, if i would like to click zoom button in my webpage, will it be possible to zoom in another applicationinstead of the webpage?

Is it possible to update a control outside of an UpdatePanel?

jamesewelch — Wed, 29 Oct 2008 04:00:00 GMT

I'm using ASP.NET AJAX (VS 2008, v3.5).

I am using the EnableHistory to provide users the ability to use back/forward browerser buttons. That part is working fine. However, my UpdatePanel triggers are outside of the UpdatePanel and I need to update those when I load the view via the ScriptManager's Navigate method.

For example, I have a dropdownlist with a series of values. When the selection change, the UpdatePanel refreshes with new data. When the user clicks the back button, they see the previous view, but the dropdownlist is still set to the other value. So the dropdownlist (trigger) doesn't match the UpdatePanel view.

I've tried clearing the selection, setting the selected index property, and setting item[x].selected=true, but it doesn't appear that the dropdownlist's selection is being updated. The only other way that I know how to do this would be to append some JavaScript code in the updated UpdatePanel to find and change the dropdownlist selectedindex value. However, I'd rather not add these little bits into the mix if I can avoid it.

Anyone have any ideas?

Problem with update panel triger

Skeewe — Mon, 20 Oct 2008 04:00:00 GMT

Hello:

Here is my problem:

UpdatePanel is (suppose to be) triggered by button that is placed in TabContainer. When I try to open page got error:

"A control with ID 'Button1' could not be found for the trigger in UpdatePanel 'UpdatePanel1'" .

Then I tried to remove trigger definition in UpdatePanel1 and try to update it from code: " UpdatePanel1.Update();"

This does not work either because whole page is being post backed. Putting Tab container inside Update Panel is not an option.

I also tried to put TabContainer.FindControl("Button1") on page load but no help...

Anybody knows any solution for this ? Thank you