public static bool ExecutarProcedure(string sql, List<Parametro> Parameters, IDbConnection cn, IDbTransaction tr)
{
FbConnection _cn = (FbConnection)cn;
FbTransaction _tr = (FbTransaction)tr;
FbCommand cmd = new FbCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = sql;
cmd.Connection = _cn;
if (tr != null)
cmd.Transaction = _tr;
foreach (Parametro par in Parameters)
{
cmd.Parameters.AddWithValue(par.nome, par.valor);
}
return (cmd.ExecuteNonQuery() > 0);
}
On 7/20/06, Le roy Arnaud <[EMAIL PROTECTED]> wrote:
hello try to this :
cmd.CommandType = CommandType.StoredProcedure;
-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys -- and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Firebird-net-provider mailing list
Firebird-net-provider@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
------------------------------------------------------------------------- Take Surveys. Earn Cash. Influence the Future of IT Join SourceForge.net's Techsay panel and you'll get the chance to share your opinions on IT & business topics through brief surveys -- and earn cash http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________ Firebird-net-provider mailing list Firebird-net-provider@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/firebird-net-provider
