Comments by Liberty Crown Infotech

Liberty Crown Infotech 24-Aug-17 13:24pm View

Thank you for your observation. Kindly show some samples on how to parameterize a query

Liberty Crown Infotech 14-Jul-17 11:49am View

I appreciate your response. My reason is that Total_RecepFee is incremental. The new Total_RecepFee entered must be added to the previous.

Liberty Crown Infotech 19-Nov-16 6:01am View

Please,I dont seem to know how to achieve that, I am having a challenge of mapping each file to a Product in the Product Model.

Liberty Crown Infotech 17-Nov-16 13:42pm View

Thanks for the attempted solution RyanDev. I am sorry for my naivety, I am not a pro on Repeaters. I have remove the foreach base on your advice and it helps. However, I keep getting the same url when clicked on any current Image without any product id value being passed "http://localhost:1051/pages/Product.aspx?id=" Can you give me head up on how to use the if statement to find the right products from folder to match the row i am on?

Liberty Crown Infotech 17-Nov-16 13:13pm View

Thanks for the attempted solution Ryan. Forgive my naivety, I am actually not a Pro on repeaters. I have remove the for each and it is helpful. Now each time I click on the repeater Image I am getting the same url " http://localhost:1051/pages/Product.aspx?id= ". How do I pass id int value into the url depending on the current image from the folder, using the if statement you suggested above?

Liberty Crown Infotech 17-Nov-16 13:11pm View

Deleted

Thanks for the observation Ryan. Forgive my naivety, I am actually not a Pro on repeaters. After removing the for each I was getting an error message. Actually, each product in the db is replicated in a directory. The problem is that I dont know if what I am doing is achievable as I am using Images from the folder for the repeater and I want each of these images to open a Product page created from the db using a productModel.when clicked

Liberty Crown Infotech 9-Nov-16 9:47am View

RyanDev, could you give me more insight into how to achieve making the image url different using the eval code?

Liberty Crown Infotech 7-Nov-16 13:36pm View

I appreciate Ryan. There will be more than a thousand images used by the repeater. How will a hyperlink on a single image tag represent different redirecting pages of each image clicked?

Liberty Crown Infotech 27-Oct-16 7:45am View

I have a textbox and 3 dropdown boxes with an item that could be selected in each of the dropdowns. There are two filtering scenarios I want to be able to achieve. 1.Getting a filtering result after typing a value in the textbox and select values in the next two textboxes leaving out the last one. 2.Getting a filtering after typing a value in the textbox and select values in the other three dropdown boxes to filter out the result. My code below can only produce each of the results one at a time. Can anyone help with modification or new query to be able to achieve the two scenarios?

CREATE proc spSearchProduct
@searchWord1OnMasterPage nvarChar(50),
@searchWord2OnMasterPage nvarChar (50),
@searchWord3OnMasterPage nvarChar (50),
@searchWord4OnMasterPage nvarChar (50)
as
Begin
Select Product.Name,Price,Seller,ProductStreetNo.StrNo,ProductStreet.StreetName from Product
INNER JOIN ProductStreetNo
ON Product.StreetNoID = ProductStreetNo.IDStreetNo
INNER JOIN ProductStreet
ON Product.StreetID = ProductStreet.IDStreet
INNER JOIN ProductState
ON StateID=ProductState.IDState
INNER JOIN ProductCity
ON CityID=ProductCity.IDCity
where

Product.Name Like '%' + @searchWord1OnMasterPage + '%' and

ProductState.StateName Like '%' + @searchWord2OnMasterPage + '%' and

((ProductCity.CityName Like '%' + @searchWord3OnMasterPage + '%' )or
(ProductStreet.StreetName Like '%' + @searchWord4OnMasterPage + '%') or
(ProductStreet.StreetName is null)) and

((ProductCity.CityName Like '%' + @searchWord3OnMasterPage + '%' )or
(ProductStreet.StreetName Like '%' + @searchWord4OnMasterPage + '%') or
(ProductStreet.StreetName is null))

End

Comments by Liberty Crown Infotech (Top 9 by date)