Hai Bhasker,

if suppose i ve the request_id FK column depends travel_request table.

create table travel_request

(

request_id int identity PK

)

create table onward_journey

(

onward_journey_id int identity,

request_id int FK references travel_request(request_id),

departuredate datetime,

from_place varchar(10),

to_place varchar(10),

travel_mode...

Hai friends

i ve three tables like

create table users

(

user_id int,

username varchar(10),

password varchar(10)

)

insert into users values('0001','ram','ram@123')

if the person enter the travel purpose on my web page automatcially store the information on...

hai friend,

actually i ve two tables

like

create table student

(

attendence datetime,

name varchar(10),

student_id varchar(20)

)

insert into student values ('02-07-2013', 'A')

insert into student values ('03-07-2013', 'A')

insert into student values ('04-07-2013', 'A')

insert into student...

Hai Hanshi,

i ve 3 tables .

users:

=========

create table users

(

user_id varchar(100) primary key,

username bvarchar(100),

password varchar(100),

designation varchar(10)

)

insert into users values('0002','ram','ramki@123','progrmmer')

insert into users values('0006','ra','rai@123','Accounts')

travel_request:

===========

...

Hai Hanshi,

if its one value means your code is correct.

but i ve many items there so how to...

hai friend,

if suppose choose the first row of the table,

create table journey

(

journey_id int identity,

depdate datetime,

fromplace varchar(20),

toplace varchar(20),

mode nvarchar(20),

seattype nvarchar(20),

)

insert into journey (deapdate,fromplace,toplace,mode,seattype) values ('2013-05-13', 'chennai','Banglore','air','Business')

insert into...

Hai...

insert into journey '2013-05-10','chennai','Mumbai','Air','Business','2'

insert into journey '2013-05-12','Mumbai','chennai','Air','Business','2'

insert into journey '2013-05-14','chennai','Banglore','Air','Business','2'

insert into journey '2013-05-16','Banglore','Chennai','Air','Business','2'

insert into journey '2013-05-18','chennai','Chennai','Local','Local Travel','2'

if suppose wanna update 10th may-13 data's depends...

Hai ,

Then How call update and insert in that procedure

its simple do nothing while i making new entry.

hai ,

I m deleted entire entries and make the new entry via asp.net it wont be work

Hai BhaskarShetty,

Your code Was working When i was making new entry it wont accepted on asp.background.

the procedure wont allow first entry?

Hai friend,

I need the output of

insert into journey values('20-05-2013','bankok','London','Air')

insert into journey values('21-05-2013','London','USA','Air')

insert into journey values('22-05-2013','USA','London','Air')

these insertion ll execeuted successfully.

now i m trying insert

insert into journey values('10-05-2013','bankok','London','Air')...

ya i need it:)

in my dd1(mode of travel) has air,bus,car,train

if choose air ===> (dd2)ll display 2 options

economy,

business

train ==>

sleeper,

semi sleeper,

II...

dis for reaport purpose......