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 GetCustomer(SqlConnection connection,
');
document.write(' int customerId)
');
document.write(' {
');
document.write(' SqlCommand command = new SqlCommand(connection);
');
document.write('
');
document.write(' command.CommandText = "GetCustomer";
');
document.write(' command.CommandType = CommandType.StoredProcedure;
');
document.write('
');
document.write(' command.Parameters.Add("@CustomerID", SqlDbType.Int);
');
document.write(' command.Parameters["@CustomerID"] = customerId;
');
document.write('
');
document.write(' return command;
');
document.write(' }
');
document.write('}');