/ * Discover a bug? V2.1 old version of the inputput parameter of SQLHELPER V3.1! Data Access Application Block 3.1Http://www.gotdotNet.com/Workspaces/Workspace.aspx? Id = C20D12B0-AF52- 402B-9B7C-AAEB21D1F431 - Create the following stored procedure create proc sp_swap @x int out, @ y int outas, if the parameters of Output, the parameters for INPUT, - SQLHELPER V3.1 EXECUTEXXXX cannot be correct The output parameter set @x = @X @x @x @x @x @X @X @x @X @X @X @X = @X - @X @X @X, @ x, @ yfrom (select 1 as idion allselect 2Union allselect 3UNION ALLSELECT 4Union allselect 5) T * /
Using system; using system.xml; using system.data.sqlclient; using system.collections; using microsoft.ApplicationBlocks.Data;
public class Class1 {static void Main (string [] args) {System.Data.SqlClient.SqlConnection sc = new System.Data.SqlClient.SqlConnection ( "Server = devserver; Database = test; User ID = sa; Password = devdos" ); String spname = "sp_swap"; SQLParameter [] spa = SQLHELPERPARETERCACHE.GETSPAAELPARETERCHE.GETSPAAMETERSET (SC, SPNAME); SPA [0] .Value = 3; // must explicitly reset Spa [0] .direction is ParameterDirection.inputoutput // or modify SQLHELPER source program //spa[0].direction = parameterdirection.inputoutput; spa [1] .Value = 5; //spa[1].direction = parameterdirection.inputoutput; DataSet DS = SQLHELPER.EXECUtedataSet (SC, CommandType.StoredProcedure, SPNAME, SPA); PrintDataSet (DS); System.Console.writeline ("Parameter x: {0}", spa [0] .value); System.Console.writeline ("Parameter Y: {0} ", spa [1] .value;} static void printdatan {bi-system.console.writeline (DT.TABLENAME); Foreach (Datacolumn DC IN DT. Columns) {system.console.write (dc.columnname "/ t");} system.console.wri Teline (); DATAROW DR IN DT.ROWS {FOREACH (Datacolumn DC in Dt.columns) {System.Console.write (DR [DC] "/ T");} system.console.writeline (); } //System.console.readline (); //system.console.writeline("/n============================= ======================== ");}}}
