hi
i have 2 procedure in my DB
1-
CREATE PROCEDURE SP_GetTableCode @Key varchar(50) AS BEGIN SET NOCOUNT ON;
select T_Code from tradeTable where Keyword= @Key END
2-
CREATE PROCEDURE SP_GetDetails @T_Code int AS BEGIN SET NOCOUNT ON;
if @T_Code = 1 begin select * from HotelTable end else
if @T_Code = 2 begin select * from tranigtable endEND
i want use this procedure in my web site and show tables in my page how i can do it?
can you help me it is very important to me
tanx alot