Calling a DB2 Stored Procedure from .NET

Calling a DB2 Stored Procedure from .NET:


using System.Data.OleDb;
------------------------------------
///I am executing a stored procedure which is returning a DataTable
public DataTable ExecuteDb2Procedure()
{

        OleDbConnection oledbCnn;
        OleDbDataAdapter oledbAdapter;
        OleDbCommand oledbCmd;
        OleDbParameter oledbParam = new OleDbParameter();;
        System.Data.DataTable dt = new DataTable();
        OleDbTransaction oledbTrans;
        string cmdText;

        oledbCnn = new OleDbConnection(System.Configuration.ConfigurationManager.AppSettings["ConnectionString"]);

        cmdText = "{call " + StoredProcedureName + " (";
       
//Here you have to just pass parameter values. Dont pass parameter name  & value. Just pass parameter value. If the parameter is string type place the string inside single quotes.

        cmdText = cmdText + " " + intParameterValue1.ToString() +         ",'" + strParamValue2 + "'," + intParameterValue2.ToString();

        cmdText = cmdText + " ) } ";

oledbCmd = new OleDbCommand(cmdText, oledbCnn);
oledbCmd.CommandTimeout = 60;
oledbAdapter = new OleDbDataAdapter(oledbCmd);

oledbCmd.CommandType = CommandType.Text;
oledbCmd.CommandText = cmdText;
oledbAdapter.SelectCommand = oledbCmd;

try
{
        retval = oledbAdapter.Fill(dt);
}
catch
{
        //Throw exception
}

return dt;
}