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() 
//得到值. 
只要注意存储过程中声明了几个传入参数就必须传入几个值就行了.

转载于:https://www.cnblogs.com/wyh0801/archive/2012/12/07/2807581.html