Getting formated SQL

[Emerson Yukio Honda]

With the code below :

SqlParameterDictionary sqlParamDic = new SqlParameterDictionary();

StringBuilder sqlBuilder = new StringBuilder();

string sql;

sqlBuilder.Append( "insert products (product) ");

sqlBuilder.AppendFormat( "values (@name) ", product.Name);

sql = sqlBuilder.ToString();

sqlParamDic.Add( new SqlParameter( "@name", product.Name ) );

SqlHelper.ExecuteNonQuery( GlobalFunctions.GetConnectionString(),
CommandType.Text, sql, sqlParamDic );

How can I get the SQL witch framework used to insert into the database? When
I check at commandtext, its still with the placeholders.

Emerson

[W.G. Ryan eMVP]

You can use the Sql Server profiler to see what the actual values are.

--
W.G. Ryan, MVP

www.tibasolutions.com | www.devbuzz.com | www.knowdotnet.com
"Emerson Yukio Honda" <ki******@yahoo.com.br> wrote in message
news:uR*************@TK2MSFTNGP09.phx.gbl...

With the code below :

SqlParameterDictionary sqlParamDic = new SqlParameterDictionary();

StringBuilder sqlBuilder = new StringBuilder();

string sql;

sqlBuilder.Append( "insert products (product) ");

sqlBuilder.AppendFormat( "values (@name) ", product.Name);

sql = sqlBuilder.ToString();

sqlParamDic.Add( new SqlParameter( "@name", product.Name ) );

SqlHelper.ExecuteNonQuery( GlobalFunctions.GetConnectionString(),
CommandType.Text, sql, sqlParamDic );

How can I get the SQL witch framework used to insert into the database?
When I check at commandtext, its still with the placeholders.

Emerson