We have an existing web app 2.0 using AD right now for authentication. The app is used at the moment as a intranet app but now we want users from the net to use it.
What is the best and easiest way to change our app to allow for this?
From the looks of my reading online so far you can't use both forms and windows authentication, correct?
Since we would be moving the app to our DMZ I guess forms authentication would be the ticket but I am sure I will be asked if I could code a way that intranet users won't have to sign in
they could just be recognized. I'm thinking that after they sign in once I could encrypt a cookie on there machine to have them gain access. What do you think of this possibility? Please recommend other solutions.
One more thing to note when you mention your ideas, we already have a users profile setup in our database. So if membership provider pops up then I would have to extend one. Please mention which one you would use: SqlMembershipProvider, ActiveDirectoryMembershipProvider etc.
In my Project there were 3 master page.
one for login
second for Menu
third for All WebForms like NewScore.
i want Login name in all masterpages.
and when login is valid then second menu page will be open.
when we click on menu page then webform open that webform i want login name.
pls help me
I m trying to get values from three tables.
1) its has the sale id and product id
2) it has the product details based on id from 1st table,
3) it has the quantity of product being selected by the query.
My problem is I need to check the count of the product based on various sizes and if its more than 0 i need to display available else sold out.
I tried the following query.
if I remove the count it works well to get the details but If I m gonna get the count it throws error.
any suggestion where this query is wrong??
SELECT SaleProduct_tb.ProductId, Product_tb.BasePrice, Product_tb.SalePrice, Product_tb.PName, Product_tb.Image1, COUNT(ProductSizeQty.Quantity)
FROM SaleProduct_tb INNER JOIN
Product_tb ON SaleProduct_tb.ProductId = Product_tb.ProductId INNER JOIN
ProductSizeQty ON Product_tb.ProductId = ProductSizeQty.ProductId
WHERE (SaleProduct_tb.SaleId = @SaleId) AND (SaleProduct_tb.CatId = @CatId) AND (SaleProduct_tb.SubCatId = @SubCatId) AND
(Product_tb.BrandId = @BrandId) ORDER BY saleProduct_tb.ProductId
after this count is found I will need to check if its more than 0 then the text should be available else not available.
SET NOCOUNT ON
SET CONCAT_NULL_YIELDS_NULL ON
DECLARE @list VARCHAR(8000)
DECLARE @delm VARCHAR(2)
SET @delm = ','
CREATE TABLE #TableToList (value varchar(20))
INSERT #TableToList VALUES ('swati')
INSERT #TableToList VALUES ('ABC')
INSERT #TableToList VALUES ('NIDHI')
INSERT #TableToList VALUES ('XYZ')
SELECT @list = ISNULL(
@list + @delm + CAST(value AS VARCHAR(8000)),
CAST(value AS VARCHAR(8000))
ORDER BY value
DROP TABLE #TableToList
SELECT list = @list
Reasons are not Important but Results are Important.