how to use procedure in asp.net

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