ASP.NET中调用存储过程,返回一个临时表
SqlConnection conn=new SqlConnection(server=.;uid=sa;pwd=sa;database=yourdatabase)
SqlCommand cmd=new SqlCommand(libsearch,conn);
cmd.CommandType = CommandType.StoredProcedure;//指示libsearch为存储过程
cmd.Parameters.Add(@nameSqlDbType.Char,20);
cmd.Parameters[@name].Value=传入name的值
cmd.Parameters.Add(@member_no,SqlDbType.Int,4);
cmd.Parameters[@member_no].Value=传入member_no的值
cmd.Parameters.Add(@loancount,SqlDbType.Int,4);
cmd.Parameters[@loancount].Direction=ParameterDirection.Output; cmd.ExcuteNonQuery();//执行存储过程
string loancount=cmd.Parameters[@loancount].Value.ToString()
//得到值.
只要注意存储过程中声明了几个传入参数就必须传入几个值就行了.