Data List Delema

[erikkl2000]

Here is what i am tring to do: I want to be redirected to a page other than 'Product.aspx' if a certain selection is made.... Example: if coats happen to be in DepartmentID 3 and the user clicked on that department, how can i be transferred to another page other than the product.aspx?

(What i have got here is a deal that i am trying to get out of this stored procedure, i am 7 months young to vb.net and i am tring to break out of this Alter Procedure cycle some way, and start fresh on another page; In other words i am ok with going through the event untill i get to this page and i would some way like to be directed to another page if a certain item is clicked and at that point focus on that area of sales., Breaking a from the other departents.)

NOTE: If i am not asking the question correctly please ask me any questoins!
Is there an IF, END STATEMENT that can be in the code behind file?



Thank you



==================================

Here is the binding code

================================

<a href='Product.aspx?@idDepartment=<%# DataBinder.Eval(Container.DataItem, "DepartmentID") %>'>



<%# DataBinder.Eval(Container.DataItem, "ProductName") %>



==================Here is the stored procedure=====================



ALTER PROCEDURE procRetrieveDept

@idDepartment int

AS

SELECT * FROM Department

WHERE DepartmentID = @idDepartment







=================================================

vb.file

=====================================================

cmdRetrieveDept.Parameters("@idDepartment").Value = _

Request("idDept")