16,018,294 members
Sign in
Sign in
Email
Password
Forgot your password?
Sign in with
home
articles
Browse Topics
>
Latest Articles
Top Articles
Posting/Update Guidelines
Article Help Forum
Submit an article or tip
Import GitHub Project
Import your Blog
quick answers
Q&A
Ask a Question
View Unanswered Questions
View All Questions
View C# questions
View C++ questions
View Javascript questions
View Visual Basic questions
View .NET questions
discussions
forums
CodeProject.AI Server
All Message Boards...
Application Lifecycle
>
Running a Business
Sales / Marketing
Collaboration / Beta Testing
Work Issues
Design and Architecture
Artificial Intelligence
ASP.NET
JavaScript
Internet of Things
C / C++ / MFC
>
ATL / WTL / STL
Managed C++/CLI
C#
Free Tools
Objective-C and Swift
Database
Hardware & Devices
>
System Admin
Hosting and Servers
Java
Linux Programming
Python
.NET (Core and Framework)
Android
iOS
Mobile
WPF
Visual Basic
Web Development
Site Bugs / Suggestions
Spam and Abuse Watch
features
features
Competitions
News
The Insider Newsletter
The Daily Build Newsletter
Newsletter archive
Surveys
CodeProject Stuff
community
lounge
Who's Who
Most Valuable Professionals
The Lounge
The CodeProject Blog
Where I Am: Member Photos
The Insider News
The Weird & The Wonderful
help
?
What is 'CodeProject'?
General FAQ
Ask a Question
Bugs and Suggestions
Article Help Forum
About Us
Search within:
Articles
Quick Answers
Messages
Comments by Member 9320578 (Top 9 by date)
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
Show More