Functions of a stored procedure

You can add a record to a table, retrieve the ID of the newly added record, and add the ID to another table. The public void add () method in the class ()
{
Int rowsaffected;
Sqlparameter [] parameters = {
New sqlparameter ("@ dtitle", _ dtitle ),
New sqlparameter ("@ DContent", _ DContent ),
New sqlparameter ("@ username", _ username ),
New sqlparameter ("@ ddate", _ ddate ),
New sqlparameter ("@ dispublic", _ dispublic ),
New sqlparameter ("@ realname", _ realname ),
New sqlparameter ("@ dnumber", "0 "),
New sqlparameter ("@ diarytype", _ diarytype ),
New sqlparameter ("@ disdel", "0 "),
New sqlparameter ("@ mtype", _ myknowid ),
New sqlparameter ("@ isinknow", _ isinknow)
};
SDH. runprocedure ("[adddiary]", parameters, out rowsaffected);} operations in the database

alter procedure [DBO]. [adddiary]
(@ dtitle varchar (250),
@ DContent text,
@ username nvarchar (256),
@ ddate int,
@ dispublic int,
@ realname nvarchar (256),
@ dnumber int,
@ diarytype int,
@ disdel int,
@ mtype int,
@ isinknow INT)
as
declare @ newid int
begin
If @ isinknow = 0
begin
insert into ds_diary (dtitle, DContent, username, ddate, dispublic, realname, dnumber, diarytype, disdel) values (@ dtitle, @ DContent, @ username, @ ddate, @ dispublic, @ realname, @ dnumber, @ diarytype, @ disdel)
end
else
begin
insert into ds_diary (dtitle, DContent, username, ddate, dispublic, realname, dnumber, diarytype, disdel) values (@ dtitle, @ DContent, @ username, @ ddate, @ dispublic, @ realname, @ dnumber, @ diarytype, @ disdel)
select @ newid = (select @ identity)
insert into ds_myknow (mtype, contentid, isqa, username) vaues (@ mtype, @ newid, '0 ', @ username)
end endselect @ identity is a new auto-increment id