document.write('using System;
');
document.write('using System.Data;
');
document.write('using System.Data.SqlClient;
');
document.write('
');
document.write('public class Commands
');
document.write('{
');
document.write(' public SqlCommand GetCustomerName(SqlConnection connection, int customerId)
');
document.write(' {
');
document.write(' SqlCommand command = new SqlCommand(connection);
');
document.write('
');
document.write(' command.CommandText = "GetCustomerName";
');
document.write(' command.CommandType = CommandType.StoredProcedure;
');
document.write('
');
document.write(' command.Parameters.Add("@CustomerID", SqlDbType.Int);
');
document.write(' command.Parameters.Add("@FirstName", SqlDbType.NVarChar, 30);
');
document.write(' command.Parameters.Add("@LastName", SqlDbType.NVarChar, 30);
');
document.write('
');
document.write(' command.Parameters["@CustomerID"] = customerId;
');
document.write('
');
document.write(' command.Parameters["@FirstName"].Direction = ParameterDirection.Output;
');
document.write(' command.Parameters["@LastName"].Direction = ParameterDirection.Output;
');
document.write('
');
document.write(' return command;
');
document.write(' }
');
document.write('
');
document.write(' public void EndGetCustomerName(SqlCommand command,
');
document.write(' out string firstName, out string lastName)
');
document.write(' {
');
document.write(' firstName = (string) command.Parameters["@FirstName"].Value;
');
document.write(' lastName = (string) command.Parameters["@LastName"].Value;
');
document.write(' }
');
document.write('}');