Comments by Member 9320578

Member 9320578 9-Jun-16 14:07pm View

I tried this but nothing happens

AFTER UPDATE
AS
SET NOCOUNT ON;
UPDATE si
SET QuoteNumber = a.QuoteNumber
FROM dbo.AccountInfo a
INNER JOIN inserted t ON t.ShippingIdentity = a.ShippingIdentity
INNER JOIN dbo.ShippingInfo si ON si.ShippingIdentity = t.ShippingIdentity

Member 9320578 9-Jun-16 13:00pm View

Thanks for your reply. I got it to stop putting the same QuoteNumber for all the records but it is still putting the QuoteNumber in it's own row instead of where the ShippingIdentity match

ALTER TRIGGER ShippingQuoteNumber
ON ShippingInfo
after UPDATE
AS
BEGIN

UPDATE ShippingInfo SET QuoteNumber = a.QuoteNumber
FROM AccountInfo a
INNER JOIN inserted t ON t.ShippingIdentity = a.ShippingIdentity
END

Member 9320578 9-Jun-16 12:45pm View

When I used the UPDATE it changed all the records in the ShippingInfo table to the same QuoteNumber instead of just the record where ShippingIdentity == QuoteNumber on the same record.

ALTER TRIGGER [dbo].[ShippingQuoteNumber]
ON [dbo].[ShippingInfo]
FOR INSERT
AS
BEGIN

UPDATE ShippingInfo SET QuoteNumber = a.QuoteNumber
FROM AccountInfo a
INNER JOIN inserted t ON t.ShippingIdentity = a.ShippingIdentity
END

Member 9320578 6-Jun-16 22:01pm View

Now User is show something wrong with it. Message says: Cannot Access non-static property 'User' in static context

Member 9320578 6-Jun-16 19:33pm View

Deleted

I have another issue I was wondering if you could help with? Someone offered a solution but it not what I'm trying to do, or I just not seeing it right. This is the link: http://www.codeproject.com/Questions/1104742/Im-trying-to-redirect-user-to-page-depending-on-ro I'm trying to go directly to a page depending on the role as soon as I click the login button.

Member 9320578 6-Jun-16 19:28pm View

Thank you! I had to tweak it a little bit, but it works because of your answer. Thank you!!!!!

Member 9320578 6-Jun-16 11:19am View

I'm trying to use the example on the Roles.IsUserInRole Method (String) (System.Web.Security)[^] link, but the word Identity is has message"Cannot resolve symbol" I'm using the Login feature from he tool box, so I don't know if that is causing the problem. Would you have an idea why 'Identity' is lite up in red?

Member 9320578 2-Jun-16 20:59pm View

I'm not using MVC. ASP.NET 4.0 I appreciate your reply but the thing is I don't know whether I should use the ASP.NET Configuration or not. I don't want to but then I'm stuck on the security part. Do you have any suggestions on how to start this project?

Member 9320578 2-Jun-16 19:35pm View

Hello,

I'm trying to do the same for my site. Have different roles redirect to a particular page. I'm very new to this and I can't find any tutorials to show me how to do this. Would you be able to let me know how to do this time of login? Did you use the ASP.NET Configuration or did you make your own database tables? Any help would be appreciated, Thanks

Comments by Member 9320578 (Top 9 by date)