TECHNOLOGIES
FORUMS
JOBS
BOOKS
EVENTS
INTERVIEWS
Live
MORE
LEARN
Training
CAREER
MEMBERS
VIDEOS
NEWS
BLOGS
Sign Up
Login
No unread comment.
View All Comments
No unread message.
View All Messages
No unread notification.
View All Notifications
Answers
Post
An Article
A Blog
A News
A Video
An EBook
An Interview Question
Ask Question
Forums
Monthly Leaders
Forum guidelines
Rocky Rocky
NA
317
152.3k
How to make code for these requirement?
Jul 4 2013 2:57 AM
Hai friends,
in my deatils.aspx page i ve two asp panels i.e
1)empdeatils
2)traveldetails
1)in my empdetails panel consists of
i)empdetails column
username,
designation,
department,
userid,
reporting
these information fetch the database and display into screen(already done)
ii)requirements column
travel purpose,
total amount
these information ve enter by user.
it ll store on the table travel_request its structure is
create table travel_request
(
request_id int identity primary key,
user_id varchar(100) foreign key references users(user_id)
purpose_travel varchar(100),
total_amount varchar(10)
)
2)travel details panel consists(already done)
departuredate,
from,
to,
travel mode
add(button after added the details ll show on grid view)
above the information ll store on onward_journey table thats structure is
create table onward_journey
(
onward_journey_id int identity,
request_id int foreign key references travel_request(request_id),
departuredate datetime,
from varchar(100),
to varchar(100),
travel mode varchar(100)
)
now my requirement is
1)when users logged and enter the travel purpose,total amount ll store on travel_request table i.e request_id ll created
depends upon that request_id onward_journey fields would be store the details.
2) how to store the onward_joureny details depends on request_id?
3) how to show that users only see request ?
Reply
Answers (
0
)
unsigned integer help
Integer in a textbox becomes zero