如何传递getdate()的参数 [英] how to pass parameters for getdate( )
本文介绍了如何传递getdate()的参数的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!
问题描述
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十进制(15,4),
@booking_date datetime
AS
插入预订(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)
结束
这是我的商店程序
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 ());
所以我在这里如何通过参数。 for getdate()...
解决方案
更正了你的sql代码
CREATE PROCEDURE dbo.usp_booking_insert
@ user_id int ,
@ journey_place varchar ( 50 ),
@ pickup_address varchar ( 250 ),
@ pickupDate datetime ,
@ return_address varchar (< span class =code-digit> 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
插入 进入预订(user_id,journey_pla ce,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 )
结束
更正了你的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 ());
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
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()...
解决方案
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());
这篇关于如何传递getdate()的参数的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!
查看全文