Line 23: }
Line 24: DataRow dr = Cnn.FillRow("Select Active, Productname,SubCategoryId from Products where ProductId='" + Request.QueryString["ProductId"] + "'");
Line 25: productname = Convert.ToString(dr["Productname"]);
Line 26: Session["SubCategoryId"] = Convert.ToString(dr["SubCategoryId"]);
Line 27: DataTable dt = Cnn.FillTable("select * from Products P join (select M.MainCategoryName,S.SubCategoryName,S.SubCategoryId from MainCategory M join SubCategory S on M.MainCategoryId=S.MainCategoryId)Sub on Sub.SubCategoryId=P.SubCategoryId and Active=1 where P.ProductName='" + productname + "' and P.ProductId !='" + Request.QueryString["ProductId"] + "'", "Detail");
|