Click here to Skip to main content
15,892,059 members
Please Sign up or sign in to vote.
4.00/5 (1 vote)
See more:
CREATE PROCEDURE dbo.usp_booking_insert
	@user_id int,
	@journey_place varchar(50),
	@pickup_address varchar(250),
	@return_address varchar(250),
	@service_id int,
	@vehicle_id int,
	@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



this is my store procedure

C#
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("getdate()", txtpickup_calenderri.Text);
     cmd.Parameters.AddWithValue("@pickup_address", txtpickup_address.Text);
     cmd.Parameters.AddWithValue("getdate()", 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());




so here how can i pass the parameters. for getdate()...
Posted

1 solution

corrected your sql code

SQL
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
C#
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());
 
Share this answer
 
v2

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900