C#

leckey wrote:

SqlHelper.ExecuteNonQuery

public static int ExecuteNonQuery(string connectionString, CommandType commandType, string commandText, params SqlParameter[] commandParameters)<br />
		{<br />
			if( connectionString == null || connectionString.Length == 0 ) throw new ArgumentNullException( "connectionString" );<br />
<br />
			// Create & open a SqlConnection, and dispose of it after we are done<br />
			using (SqlConnection connection = new SqlConnection(connectionString))<br />
			{<br />
				connection.Open();<br />
<br />
				// Call the overload that takes a connection in place of the connection string<br />
				return ExecuteNonQuery(connection, commandType, commandText, commandParameters);<br />
			}<br />
		}

public static int ExecuteNonQuery(SqlConnection connection, CommandType commandType, string commandText, params SqlParameter[] commandParameters)<br />
		{	<br />
			if( connection == null ) throw new ArgumentNullException( "connection" );<br />
<br />
			// Create a command and prepare it for execution<br />
			SqlCommand cmd = new SqlCommand();<br />
			bool mustCloseConnection = false;<br />
			PrepareCommand(cmd, connection, (SqlTransaction)null, commandType, commandText, commandParameters, out mustCloseConnection ); RUNS THIS FINE    		<br />
			// Finally, execute the command<br />
			int retval = cmd.ExecuteNonQuery(); GETS STUCK ON THIS<br />
    		<br />
			// Detach the SqlParameters from the command object, so they can be used again<br />
			cmd.Parameters.Clear();<br />
			if( mustCloseConnection )<br />
				connection.Close();<br />
			return retval;<br />
		}

leckey wrote:

I'm not quite sure what you mean by the second part...

Christian Graus wrote:

cmd.Parameters.Add("@trackID", -1);

private object btnAdd_Click(object sender, System.EventArgs e)<br />
		{<br />
			strPartNumberInputReference = txtSearchPart.Text;<br />
			strPartTypeID = ddPartType.SelectedValue;<br />
			SqlCommand cmd = new SqlCommand ("UpdatePart_Step_1_Test3", connectionString);<br />
			cmd.CommandType = CommandType.StoredProcedure;<br />
			cmd.Parameters.Add ("@PartNumber", strPartNumberInputReference);<br />
			cmd.Parameters.Add ("@PartTypeValue", strPartTypeID);<br />
			cmd.Parameters.Add("@ID",SqlDbType.Int);<br />
			cmd.Parameters["@ID"].Direction = ParameterDirection.Output;<br />
			cmd.ExecuteNonQuery();<br />
			return(int) cmd.Parameters["@ID"].Value;<br />
		}

leckey wrote:

SqlParameter param6 = new SqlParameter(@ID, SqlDbType.Int);

static int Main(string[] args)
{
	return 3;
}

<yourappname>
echo %ERRORLEVEL%
pause