in my project i am using stored procedure and i am passing input params,
and i want to get the out put params .if any one knows please tell me



n.thillaiarasu

__________________
N.ThillaiArasu

A simple code example is as below where first parameter is input while the second is output:

SqlParameter[] ParamArr = new SqlParameter[2];

ParamArr[0] = new SqlParameter("@FirstParam", FirstParam);

ParamArr[1] = new SqlParameter("@SecondParam", SecondParam);
ParamArr[1].Direction = ParameterDirection.Output;

Regards
Mike