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