public void Setup()
{
   TdConnection cn = new TdConnection();
   cn.ConnectionString = "Data Source=Teradata1;User ID=ab;Password=ab;";
            
   String empTable = "CREATE TABLE EmployeeTable(CustID char(6), CustName char(50))";
   String spText   = "REPLACE PROCEDURE LookupCustomerName " + 
                     "( in varCustID char(6), out varCustName char(50))" +
                     "BEGIN" +
                     "Select CustName into varCustName from EmployeeTable where CustID = varCustID;" +
                     "END;";
   try
   {
       cn.Open();
       TdCommand cmd = cn.CreateCommand();
            
       cmd.CommandText = empTable;
       cmd.ExecuteNonQuery();
            
       cmd.CommandText = spText;
       cmd.ExecuteNonQuery();
   }
   finally
   {
       // Close the session to Teradata
       cn.Close();
   }
}

public String LookupCustomerName(String customerId)
{
    String customerName = null;
    TdConnection cn = new TdConnection();
    cn.ConnectionString = "Data Source=Teradata1;User ID=ab;Password=ab;";
    
    Setup();
    
    try
    {
        cn.Open();
        
        // Initialize TdCommand
        TdCommand cmd = cn.CreateCommand();
        
        //CommandText is set to Stored Procedure name, in this case,
        //.NET Data Provider will generate the CALL statement.
        cmd.CommandText = "LookupCustomerName";
        
        //CommandText is set below to user specified CALL statement. To run the
        //example with the below CALL statement, uncomment the below line where 
        //CommandText is set to the CALL statement and comment out the previous 
        //CommandText set to the Stored Procedure name.
        //cmd.CommandText = "Call LookupCustomerName (?,?)";
        
        cmd.CommandType = CommandType.StoredProcedure;
        
        // Create Input Parameter
        TdParameter InParm = cmd.CreateParameter();
        InParm.Direction = ParameterDirection.Input;
        InParm.DbType = DbType.String;
        InParm.Size = 6;
        InParm.Value = customerId;
        cmd.Parameters.Add(InParm);
        
        // Create Output Parameter.
        TdParameter OutParm = cmd.CreateParameter();
        OutParm.Direction = ParameterDirection.Output;
        
        // Specify the output parameter name.
        
        // If parameter name is not specified, then 
        // the .NET Data Provider will retrieve the
        // name of out arguments from the Teradata RDMS
        OutParm.ParameterName = "CustomerName";
        OutParm.DbType = DbType.String; 
        OutParm.Size = 50; 
        cmd.Parameters.Add(OutParm); 
        
        cmd.ExecuteNonQuery();
        
        customerName = OutParm.Value;
    } 
    finally
    {
        // Close the session to Teradata
        cn.Close();
    }
    
    return customerName;
}