Community discussion forum

debug sql with parameters

• • Reply

  5 months ago

  by jogisarge

  jogi sarge

  Würzburg, Germany

  Joined 0 month

  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 was sent to the sql-server ?

  Gruß jogi

  Post was edited on 18/06/2009 09:56:40 Report abuse
• • Reply

  5 months ago

  by TimL

  Tim Leung

  Berkshire, United Kingdom

  Joined 2 years ago

  I'd recommend creating a trace using SQL Profiler.

  http://msdn.microsoft.com/en-us/library/ms181091.aspx

  Report abuse