CREATE PROCEDURE hycount
(
@rscount int output
)
AS
select @rscount= count(*) from hy
GOSqlParameter res=new SqlParameter("@rscount",SqlDbType.Int);
res.Direction=ParameterDirection.Output;
cmd.Parameters.Add(res);res.Value就是返回值。
(
@rscount int output
)
AS
select @rscount= count(*) from hy
GOSqlParameter res=new SqlParameter("@rscount",SqlDbType.Int);
res.Direction=ParameterDirection.Output;
cmd.Parameters.Add(res);res.Value就是返回值。
cmd.CommandType = CommandType.StoreProcedure;cmd.Parameter.Add("@Return", SqlDbType.Int);
cmd.Parameter[0].Direction = ParameterDirection.Return;conn.Open();
cmd.Exenonquery();
i = cmd.Parameter[0].Value;
conn.Close();
MyConn.Open();
SqlCommand mdo = new SqlCommand("person_manager_add",MyConn);
mdo.CommandType = CommandType.StoredProcedure;
mdo.Parameters.Add("@employee_id",employee_id.Text.Trim());
mdo.Parameters.Add("@name",name.Text.Trim());
mdo.Parameters.Add("@sch_area",sch_area.SelectedValue.Trim());
mdo.Parameters.Add("@gender",gender.SelectedValue.Trim());
mdo.Parameters.Add("@politics",politics.SelectedValue.Trim());
mdo.Parameters.Add("@politics_time",politics_time.Text.Trim());
mdo.Parameters.Add("@tel",tel.Text.Trim());
mdo.Parameters.Add("@email",email.Text.Trim());
mdo.Parameters.Add("@re",re.Text.Trim()); mdo.Parameters.Add("@RetVal",SqlDbType.Int);
mdo.Parameters["@RetVal"].Direction=ParameterDirection.ReturnValue;
mdo.ExecuteNonQuery();
if (Convert.ToInt32(mdo.Parameters["@RetVal"].Value)==-1)
{
Response.Write("<script language=javascript>alert('该教师在数据库中已经存在,添加无效!');history.back()</script>");
}
else
{
Response.Redirect("alert.aspx?msg=添加员工资料成功!&url=person.aspx");
} MyConn.Close();
cmd.CommandType = CommandType.StoreProcedure;cmd.Parameters.Add("@Return", SqlDbType.Int);
cmd.Parameters[0].Direction = ParameterDirection.Return;conn.Open();
cmd.Exenonquery();
i = cmd.Parameter[0].Value;
conn.Close();