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

Hai Friends,

I ve the asp.net page like below

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.

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).

1 Reply

Know the answer? Post it — somebody with the same question will find it here.

Prasenjit Dey13y ago
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