Declare and initialize an SAConnection object.

SAConnection conn = new SAConnection(
    "Data Source=SQL Anywhere 12 Demo" );

Open the connection.

conn.Open();

Add an SACommand object to define and execute a SQL statement. The following code uses the CommandType property to identify the statement as a stored procedure.

SACommand cmd = new SACommand( "ShowProductInfo",
    conn );
cmd.CommandType = CommandType.StoredProcedure;

If you do not specify the CommandType property, then you must use a question mark as a placeholder for parameters, as follows:

SACommand cmd = new SACommand(
    "call ShowProductInfo(?)", conn );
cmd.CommandType = CommandType.Text;

Add an SAParameter object to define the parameters for the stored procedure. You must create a new SAParameter object for each parameter the stored procedure requires.

SAParameter param = cmd.CreateParameter();
param.SADbType = SADbType.Int32;
param.Direction = ParameterDirection.Input;
param.Value = 301;
cmd.Parameters.Add( param );

For more information about the Parameter object, see SAParameter class.

Call the ExecuteReader method to return the DataReader object. The Get methods are used to return the results in the specified data type.

SADataReader reader = cmd.ExecuteReader();
reader.Read();
int ID = reader.GetInt32(0);
string name = reader.GetString(1);
string description = reader.GetString(2);
decimal price = reader.GetDecimal(6); 

Close the SADataReader and SAConnection objects.

reader.Close();
conn.Close();