How to show grid view empty when i make new request?

Question

Hai Friends,

I ve the asp.net page like below

<asp:pannel=1>

travel_purpose = textbox
total_amount = textbox

these information ll store on my table in "travel_request"

table structure:
================

create table travel_request

(
request_id int identity,
user_id varchar(100),
travel_purpose varchar(100),
toatal_amount varchar(20)

)

i made here when the person is entered to fill above text box request_id ll be generated.

<asp:pannel=2>

departure date =textbox
from_place = textbox
to_place = textbox
travel_mode = textbox
request_id "visible=false" = text box
ADD(button) (after pressing these button above details ll show on grid view).

these deatils ll stored on

create table onward_journey

(
journey_id int identity,
request_id int references travel_request(request_id),
departuredate datetime,
from_palce varchar(20),
To_place varchar(20),
travel_mode varchar(20)
)

so i made the query for displaying gridviews:
==============================================

select * from onward_journey where request_id = IDENT_CURRENT('Travel_request')

now the problem is when i try to made new request that time also gridview contains last request_id value.

above query is the problem......
i need the solution when i make new request grid ll show "empty" (i.e doesnt show previous value of request).

Prasenjit Dey · Answer

As per your question I think " travel_request " is your master table. And data in this table is already inserted. So when you want to show IDENT_CURRENT column then may be it is showing the last inserted record in " travel_request " table. So if you want to show record of 2nd table i.e. " onward_journey " and you need the primary key of " travel_request " table then why don't you directly put the value of that primary key instead of " IDENT_CURRENT "! Because you know the primary key at the time of insert. If you want to show record of last entry of " onward_journey ", then just set the " IDENT_CURRENT " of primary key of that table