How make a code for below requirement?

Rocky Rocky

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?

4 Replies

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

Rocky Rocky13y ago
Hai Friend,

after login my page directly goes to "default2.aspx"

when i m started entered the text in(travel purpose) request id ll be created ,
depends upon the request id "travel request pannel "

DEPARTURE DATE:
FROM:
TO :
like all COLUMN ARE DISPLAYED IN GRIDVIEW by pressing "ADD"

1) IF THE travel purpose column is null (i.e no request id is generated gridview column ll be shown no record found)

2)one more think after added the details i choose "save" means ll redirect into "Home.aspx"
in "travel draft pannel" the entire ll shown.
now i choose the draft redirect into "viewdraft.aspx" its for what i ve entered the textbox and grid view table ll show
suppose in that save items added new departure dates doesn't reflect on grid view when i choose save then i can get the value?

how to solve 2 these pages as per my requirements to change on "public void binddata()"?
0
saravana kumar13y ago
From Whre you are inserting new request? is it from that page it self? If grid is not binded properly means call that Gridview binding method onceagain in button click event..
0
Rocky Rocky13y ago
Hai saravannan,

i wanna to get the gridview of my travel.aspx when i choose new request form my grid view ll shown empty(no record found) but its showing of before travel request id
further requirements i had attached my code here. plz refer and let me back
0
saravana kumar13y ago

What is mean by current request_id. If you want to bind data in gridview means what is the crieteria for that?
0