debug sql with parameters

database , sqlserver , csharp Würzburg, Germany
  • 11 years ago

    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

  • 11 years ago

    I'd recommend creating a trace using SQL Profiler.

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

Post a reply

Enter your message below

Sign in or Join us (it's free).

Contribute

Why not write for us? Or you could submit an event or a user group in your area. Alternatively just tell us what you think!

Our tools

We've got automatic conversion tools to convert C# to VB.NET, VB.NET to C#. Also you can compress javascript and compress css and generate sql connection strings.

“There's no test like production” - Anon