corrected your sql code
CREATE PROCEDURE dbo.usp_booking_insert
@user_id int,
@journey_place varchar(50),
@pickup_address varchar(250),
@pickupDate datetime,
@return_address varchar(250),
@service_id int,
@vehicle_id int,
@returnDate datetime,
@mode_of_payment varchar(50),
@status varchar(5),
@starting_km decimal(15,4),
@ending_km decimal(15,4),
@booking_date datetime
AS
insert into booking (user_id,journey_place,pickup_date,pickup_address,return_date,return_address,service_id,vehicle_id,mode_of_payment,status,starting_km,ending_km,booking_date)
values (@uid,@journey_place,getdate(),@pickup_address,getdate(),@return_address,@service_id,@vehicle_id,@mode_of_payment,'true',0,0,@booking_date)
End
corrected your C# code
cmd.CommandText = "usp_booking_insert";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@user_id", ddluname.SelectedValue);
cmd.Parameters.AddWithValue("@journey_place", txtjplace.Text);
cmd.Parameters.AddWithValue("@pickupDate", txtpickup_calenderri.Text);
cmd.Parameters.AddWithValue("@pickup_address", txtpickup_address.Text);
cmd.Parameters.AddWithValue("@returnDate", txtreturndate.Text);
cmd.Parameters.AddWithValue("@return_address", txtreturn_address.Text);
cmd.Parameters.AddWithValue("@service_id", ddlsname.SelectedValue);
cmd.Parameters.AddWithValue("@vehicle_id", ddlvehicles.SelectedValue);
cmd.Parameters.AddWithValue("@mode_of_payment", rdbtnpayment.SelectedValue);
cmd.Parameters.AddWithValue("@booking_date", System.DateTime.Now.ToString());