jo

jo

  • NA
  • 8
  • 0

show sql with parms for debugging

Jun 18 2009 6:10 AM

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

Answers (1)