Friday, March 9, 2012

how to retrive the value of "@DerivedFileName"

SqlCommand sqlCommand =newSqlCommand(spName, Conn);

sqlCommand.CommandType =CommandType.StoredProcedure;

sqlCommand.Parameters.Add("@.XMLString",SqlDbType.Xml).Value = XMLstring;

sqlCommand.Parameters["@.XMLString"].Direction =ParameterDirection.Input;

sqlCommand.Parameters.Add("@.DerivedFileName",SqlDbType.VarChar,50);

sqlCommand.Parameters["@.DerivedFileName"].Direction =ParameterDirection.Output;

int test = sqlCommand.ExecuteNonQuery();

Use

str = sqlCommand.Parameters["@.DerivedFileName"].Value.ToString();

No comments:

Post a Comment