المساعد الشخصي الرقمي

مشاهدة النسخة كاملة : debug sql with parameters



C# Programming
06-18-2009, 02:21 PM
Hi,

i use VS2008 and SQLServer 2005.

How can i debug a sql-statement, that includes parameters like this ?

string sqlstatement = "INSERT INTO artikel (nr,text1,text2)" +
"VALUES" +
"( @parm1, " +
" @parm2, " +
" @parm3 " +
" " +
" )";
SqlCommand sqlins = new SqlCommand(sqlstatement, con);
sqlins.Parameters.Add("@parm1", SqlDbType.NVarChar).Value = var1;
sqlins.Parameters.Add("@parm2", SqlDbType.Int).Value = var2;
sqlins.Parameters.Add("@parm3", SqlDbType.Int).Value = var3;
sqlins.ExecuteNonQuery();

so, how can i see the statement, that will be sent to the sql-server ?

bye jogi