command.CommandText and parameters

microsoft.public.dotnet.framework.adonet

7 Nov 2007 5:11 PM

skneife

What is the way for getting the sqlQuery with all params
replacementfrom a command ?
DbCommand command;
SqlParameter sqlParam = new SqlParameter("@param1", "value1");
SqlParameter sqlParam = new SqlParameter("@param1", "value2");
command.CommandText=sqlQuery;
What is the propertoie that provide the sqlQuery string but with all
params replacement ?

Sam

8 Nov 2007 1:51 PM

pipo

Hi Sam,

Do you mean the command.CommandText ?

Pipo

<skne***@gmail.com> schreef in bericht
Show quote

news:1194455503.023124.44740@19g2000hsx.googlegroups.com...
> What is the way for getting the sqlQuery with all params
> replacementfrom a command ?
> DbCommand command;
> SqlParameter sqlParam = new SqlParameter("@param1", "value1");
> SqlParameter sqlParam = new SqlParameter("@param1", "value2");
> command.CommandText=sqlQuery;
> What is the propertoie that provide the sqlQuery string but with all
> params replacement ?
>
> Sam
>