Idataparameter calls the Stored Procedure

Public String generateexamepaper (string papertype, string driverid, string macaddr)
{
Int I;
Idataparameter [] idata = new sqlparameter [4];
Idata [0] = new sqlparameter ("@ papertype", papertype );
Idata [1] = new sqlparameter ("@ driverid", driverid );
Idata [2] = new sqlparameter ("@ macaddr", macaddr );
Idata [3] = new sqlparameter ("@ sreturn", sqldbtype. Char, 50, parameterdirection. Output, false, 0, 0, String. Empty, datarowversion. Default, null );
String AAA = "";
I = dbhelpersql. runprocedureparout ("pro_generateexamepaper", idata, out AAA). tostring ();

Return AAA;

}

/// <Summary>
/// Run the stored procedure and return the number of affected rows
/// </Summary>
/// <Param name = "storedprocname"> stored procedure name </param>
/// <Param name = "Parameters"> Number of Stored Procedure partitions </param>
/// <Param name = "rowsaffected"> Number of affected rows </param>

/// <Param name = "rowsaffected"> return output value </param>

/// <Returns> </returns>
Public static int runprocedure (string storedprocname, idataparameter [] parameters, out int rowsaffected, out Str)
{
Using (sqlconnection connection = new sqlconnection (connectionstring ))
{
Int result;
Connection. open ();
Sqlcommand command = buildintcommand (connection, storedprocname, parameters );
Rowsaffected = command. executenonquery ();
Result = (INT) command. Parameters ["returnvalue"]. value;
STR = (INT) command. Parameters ["@ sreturn"]. value;
Return result;
}
}

Idataparameter calls the Stored Procedure