SqlConnection conn = new SqlConnection("CONNECTION HERE"); SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandType = CommandType.StoredProcedure; cmd.CommandText = "sp_abc"; //Create the first parameter SqlParameter firstParam = new SqlParameter("P_Id", SqlDbType.Int); firstParam.Value = 0; //Place your variable firstParam.Direction = ParameterDirection.Input; cmd.Parameters.Add(firstParam); //Parameter 1 //Create the second parameter SqlParameter secondParam = new SqlParameter("ResultRS", SqlDbType.Variant); secondParam.Direction = ParameterDirection.Output; cmd.Parameters.Add(secondParam); //Parameter 2 int count = cmd.ExecuteNonQuery(); Console.WriteLine(secondParam.Value.ToString()); This is correct now, secondParam.Value and you read the value News at http://support.microsoft.com/kb/308621[^]

modified on Monday, January 07, 2008 8:36:36 AM

First, is impossible to "not care" the server, because you write a lot of folders and pictures phisically inside the server. Dry Response -> NOT IN 1 SECOND! The times seems to be ok, but maybe is better if you post the code...

You have to use the cmd.ExecuteReader() and not the cmd.ExecuteNonQuery() - the last method return an int of numbers of rows affected, usually used with insert query or update query (also useful with select count...). Try this: SqlDataReader reader = cmd.ExecuteReader(); reader.Close(); string result = reader["ResultRS"].ToString();

Use the normal I/O operation to read the file inside the SD. Use the object File under the namespace System.IO Byez