public void Save(long contactID) { // // Create a command object to invoke the stored procedure // SqlCommand cmd = new SqlCommand("net_contact_email_save", ConnectionManager.GetConnection()); cmd.Transaction = ConnectionManager.GetTransaction(); cmd.CommandType = CommandType.StoredProcedure; // // Input parameters // cmd.Parameters.Add(new SqlParameter("@contactID", SqlDbType.BigInt)).Direction = ParameterDirection.Input; cmd.Parameters.Add(new SqlParameter("@email", SqlDbType.NVarChar, UDDI.Constants.Lengths.Email)).Direction = ParameterDirection.Input; cmd.Parameters.Add(new SqlParameter("@useType", SqlDbType.NVarChar, UDDI.Constants.Lengths.UseType)).Direction = ParameterDirection.Input; // // Set parameter values // SqlParameterAccessor parmacc = new SqlParameterAccessor(cmd.Parameters); parmacc.SetLong("@contactID", contactID); parmacc.SetString("@email", Value); parmacc.SetString("@useType", UseType); cmd.ExecuteNonQuery(); }