Insert command through Stored Procedure

Try like this. but i didn't check below code.
pls replace <TABLE_NAME> to ur table name.

CREATE PROCEDURE InsertRec 

(

@TRAINER_NAME varchar(50),

@SUBJECT varchar(100) ,

@START_DATE_TIME datetime ,

@END_DATE_TIME datetime ,

@LOCATION varchar(100) ,

@CREATE_DATE datetime ,

@MODIFIED_DATE datetime , 

@ISACTIVE bit ,



@ID int OUTPUT

)

AS

BEGIN



INSERT INTO <TABLE NAME>(@TRAINER_NAME,@SUBJECT,@START_DATE_TIME,@END_DATE_TIME,

@LOCATION,@CREATE_DATE,@MODIFIED_DATE

)



SELECT @ID=max(TRAINING_ID) from <TABLE_NAME> 



END

GO

Thanks,
Seen

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

@ Sucharitha , u want to insert data using 3 tier or 1 tier ???

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

create procedure sp_ProductDetaile
@product_id int,
@Productname varchar(90)
as
Begin
insert into Product_details (productid,product_Name)
values
(@product_id,@Productname)
end
Go

sriram

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

CREATE PROCEDURE insertTLtask
(
@TRAINER_NAME varchar(50),

@SUBJECT varchar(100) ,

@START_DATE_TIME datetime ,

@END_DATE_TIME datetime ,

@LOCATION varchar(100) ,

@CREATE_DATE datetime ,

@MODIFIED_DATE datetime ,

@ISACTIVE bit ,
@ID int OUTPUT

)
AS
BEGIN
INSERT INTO <TABLE NAME>(@TRAINER_NAME,@SUBJECT,@START_DATE_TIME,@END_DATE_TIME,@LOCATION,@CREATE_DATE,@MODIFIED_DATE) values(Column_name ,Column_name,Column_name,Column_name,Column_name,Column_name,)



END

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

INSERT INTO <TABLE NAME>(@TRAINER_NAME,@SUBJECT,@START_DATE_TIME,@END_DATE_TIME,@LOCATION,@CREATE_DATE,@MODIFIED_DATE) values(TRAINER_NAME,SUBJECT,START_DATE_TIME,END_DATE_TIME,LOCATION,CREATE_DATE,MODIFIED_DATE )

replace command in S>P

ER sandeep chourasia
sandeepchrs@yahoo.com (on facebook)
http://www.aspnetcodes.com/

Rrana, if this helps please login to Mark As Answer. | Alert Moderator

CREATE PROCEDURE <procname>
(
@TRAINER_NAME varchar(50),
@SUBJECT varchar(100) ,
@START_DATE_TIME datetime ,
@END_DATE_TIME datetime ,
@LOCATION varchar(100) ,
@CREATE_DATE datetime ,
@MODIFIED_DATE datetime ,
@ISACTIVE bit,
@TRAINING_ID int OUTPUT
)
AS
BEGIN

INSERT INTO <TABLE NAME>(TRAINER_NAME,SUBJECT,START_DATE_TIME,END_DATE_TIME,LOCATION,CREATE_DATE,MODIFIED_DATE,ISACTIVE)
values(@TRAINER_NAME,@SUBJECT,@START_DATE_TIME,@END_DATE_TIME,
@LOCATION,@CREATE_DATE,@MODIFIED_DATE,@ISACTIVE)


SELECT @TRAINING_ID=max(TRAINING_ID) from <TABLE_NAME>

SELECT @TRAINING_ID 'TRAINING_ID'

END



SqlConnection conn = new SqlConnection(constring);
conn.Open();
SqlCommand cmd = null;
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("TRAINER_NAME", SqlDbType.VarChar).Value = sTrainerName;
cmd.Parameters.Add("SUBJECT", SqlDbType.VarChar).Value = sSubject;
cmd.Parameters.Add("START_DATE_TIME", SqlDbType.Datetime).Value = startDate;
cmd.Parameters.Add("END_DATE_TIME", SqlDbType.Datetime).Value = endDate;
cmd.Parameters.Add("LOCATION", SqlDbType.VarChar).Value = sLocation;
cmd.Parameters.Add("CREATE_DATE", SqlDbType.Datetime).Value = createDate;
cmd.Parameters.Add("MODIFIED_DATE", SqlDbType.Datetime).Value = modifyDate;
cmd.Parameters.Add("ISACTIVE",SqlDbType.Bit).Value = 0;
cmd.Parameters["TRAINING_ID"].Direction = ParameterDirection.Output;
TRAINING_ID = cmd.Parameters["TRAINING_ID"].Value;
cmd.ExecuteNonQuery();
conn.Close();

Rrana, if this helps please login to Mark As Answer. | Alert Moderator