How make a code for below requirement?
Hai Friends,
I m currently making one web application in that i wanna display details from data base into asp page on grid view.
create table onward_journey
(
onwrd_id int identity,
request_id int foreign key refernces request(reqst_id),
from_place varchar(10),
to_place varchar(10),
trvael_mode varchar(10),
no_of_days varchar(10)
)
insert into onward_journey ('11','chennai','chenai','car','2')
i wanna display display my page on gridview
select
from_place,to_place,travel_mode, no_of_days from travel_request where request_id=IDENT_CURRENT ('request')
when i made new request also its showing old once? how to that and how to show current request_id value?