Tryangled Dev

There are several ways to use ADO.NET to call a stored procedure and to get
back return values and return parameters, including:

•Use a DataSet object to gather the returned rows and to work with these rows in addition to the return values and the return parameters.
•Use a DataReader object to gather the returned rows, to move through these rows, and then to gather return values and return parameters.
•Use the ExecuteScalar method to return the value from the first column of the results’ first row with the return values and the return parameters. This is most useful with aggregate functions.
•Use the ExecuteNonQuery method to return only the return parameters and the return values. Any returned rows are discarded. This is most useful for executing action queries.

A relay is a service that allows you to send email. It is usually a full fledged mail server, or can be a specialized SMTP Service. Some examples of a mail server include Microsoft Exchange, IMail by IPSwitch, or Mail Enable by Mail Enable. An example of a SMTP service is the SMTP Service installed that can be installed with IIS. SWM sends email to a relay server, and the relay server is responsible for delivering the email to the final destination. When sending email to a relay server, you must have protocol permissions to use that server. Because of SPAM problems, relay servers are normally locked down, either by IPAddress or by some type of username/password authentication. Relaying errors are the most common problems when programmatically sending emails. If you ever see an exception that reads something like “550 Permission Denied”, this is usually a relay error, and you need to talk to your mail server administrator about proper permissions.