Insert using stored procedure in mulitple table in C# -

alter procedure [dbo].[sp_createprocess]    @type varchar(50),--0    @hospitalid varchar(50),--1    @patientid varchar(50) ,--2    @preauthorization varchar(50) ,--3    @status varchar(50) ,--4    @amount varchar(50) ,--5    @amtwords varchar(500) ,--6    @apptrt varchar(50) ,--7    @typetrt varchar(50) ,--8    @ailname varchar(100) ,--9    @ailcode varchar(50) ,--10    @roomtype varchar(50) ,--11    @roomrent varchar(50) ,--12    @signature varchar(50) ,--13    @processby varchar(50) ,--14    @corpscheme varchar(50) ,--15    @insurancediv varchar(50) ,--16    @drrmk varchar(50) ,--17    @created_date datetime ,--18    @modified_date datetime ,--19    @created_by varchar(50) ,--20    @modified_by varchar(50) ,--21    @cormk varchar(100) ,--22    @remark varchar(1500) ,--23    @createdby varchar(50) ,--24    @modifiedby varchar(50) ,--25    @createddate datetime ,--26    @modifieddate datetime, --27    @userrole int --28 begin     if @type = 'insertprocess'     begin         insert patient_process_status values         (             @hospitalid,             @patientid,             @preauthorization,             @status,             @ailname,             @ailcode,             @roomtype,             @roomrent,             @signature,             @processby,             @corpscheme,             @insurancediv,             @drrmk,             current_timestamp,             current_timestamp,             @created_by,             @modified_by         )          update dbo.usercommunication set roleid=@userrole         patientid=@patientid  ,  hospitalid=@hospitalid          update pd_patients set lastupdatedrole=@userrole         patientid=@patientid ,  hospitalid=@hospitalid          insert postenhancetbl values         (             @patientid,             @hospitalid,             @amount,             @amtwords,             @apptrt,             @typetrt ,             @cormk,             @remark,             @createdby,             @modifiedby,             current_timestamp,             current_timestamp         )      end      if @type='gettpadetails'     begin         select ps.*,lastupdatedrole patient_process_status ps         left join pd_patients pd on ps.patientid=pd.patientid  ,  ps.hospitalid=pd.hospitalid         ps.patientid=@patientid  ,  ps.hospitalid=@hospitalid     end end 

this error get:

**

the above code sql server 2014 stored procedure want join 2 tables , insert form value in 2 tables.

please me resolve issue , let me know why facing error of string datetime conversion

the problem here passing string type datetime parameter , failing convert string datetime.

check parameters , make sure pass datetime format parameter value or can use convert in sql server side convert parameter proper , valid datetime format.

you try using datetime variablename instead of string variablename.

hope helps.