sql-server store procedure,how can insert data in database

Posted by Umeshdwivedi under ASP.NET on 5/27/2011 | Points: 10 | Views : 7489 | Status : [Member] | Replies : 3
hi to all,
any body tell me store procedure step by step,i want to insert data in database by the store procedure
pls tell me step by step

Latest Technology Trainer
And Part time software consultant



Responses

Posted by: Raja on: 5/27/2011 [Member] Starter | Points: 25

Up
0
Down
For how to's like this and many more, Sheo has recently written a very nice .NET How to's series, get it from http://www.itfunda.com/Howto and Insert has been covered at http://www.itfunda.com/how-to-insert-records-into-the-database/Free/126.

Now for your question, download the attached application from http://www.dotnetfunda.com/articles/article71.aspx and search for Insert method in PersonDAL3.cs class. The stored procedure should be in the database.

Hope this will help.

Thanks

Regards,
Raja, USA

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

Posted by: Mshivainfo on: 5/31/2011 [Member] Starter | Points: 25

Up
0
Down
Create Proc InsertEmp_SP(@Emp_Id varchar(20),@Emp_Name varchar(200),@Department varchar(50))
As
Begin

Insert into EmpMstr(EmpId,EmpName,Dept) Values (@Emp_Id,@Emp_Name,@Department)

End

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

Posted by: Lakn2 on: 5/31/2011 [Member] Starter | Points: 25

Up
0
Down
syntax for storedprocedure
create procedure procedurename
(@arg1 datatype,
@arg2 datatype,
....
)
as
begin
insert into tablename(val1,val2,val3....) values(@arg1,@arg2...)
end

Thanks&Regards
LakshmiNarayana Nalluri.

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

Login to post response