repadmin /replsummaryOutput:
Microsoft AX 2012, X++, C#, SQL server, SSRS, Java, JavaFX, Oracle, PL/SQL, Delphi - codes examples, step-by-step tutorials, experiences.
Friday, March 13, 2020
Monday, March 9, 2020
C# - How call stored proc with output/return parameter ?
public static string GetStatistics() {
string value = "";
SqlCommand command = DB.SPPrepare( "GetStatisticsAsString" );
command.Parameters.Add( new SqlParameter( "@catalog", "HYG" ) );
command.Parameters.Add( new SqlParameter( "@catalogDSO", "MYDSO" ) );
SqlParameter par = new SqlParameter( "@output", System.Data.SqlDbType.NVarChar, 2048 );
par.Direction = System.Data.ParameterDirection.Output;
command.Parameters.Add( par );
command.ExecuteNonQuery();
value = (string)command.Parameters[ "@output" ].Value;
return value;
}
Monday, March 2, 2020
C# - How to use generic Min(), Max()
shape.Saved_Width = Math.Abs( shape.Points.Max( item => item.Draw_X )-shape.Points.Min( item => item.Draw_X ) );
Subscribe to:
Comments (Atom)
