command.CommandText and parameters

's Computer Specifications

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

's Computer Specifications

Hi Sam,

Do you mean the command.CommandText ?

Pipo

<(E-Mail Removed)> schreef in bericht
news:(E-Mail Removed)...
> 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
>

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How to read commandtext after added parameters?	Eric	Microsoft VB .NET	9	28th Oct 2010 12:29 AM
Why using command parameters?	BLUE	Microsoft ADO .NET	4	9th Jun 2007 01:50 PM
Re: Why using command parameters?	Nicholas Paldino [.NET/C# MVP]	Microsoft C# .NET	0	8th Jun 2007 06:32 PM
ADODB.Command.CommandText Issue	Kyle Jedrusiak	Microsoft Access ADP SQL Server	7	4th Jul 2005 08:06 AM
ADODB.Command.CommandText Issue	Kyle Jedrusiak	Microsoft Access Form Coding	2	27th Apr 2005 04:42 PM