0

Say we have a query where I will add some parameters

For Ex: 

 SqlCommand cmd = new SqlCommand("insert into Table(UserName, Password, Country, Email) values(@UserName, @Password, @Country, @Email)", con);

 cmd.Parameters.AddWithValue("@UserName", User.UserName);
 cmd.Parameters.AddWithValue("@Password", User.Password);
 cmd.Parameters.AddWithValue("@Country", User.Country);
 cmd.Parameters.AddWithValue("@Email", User.Email);

Something like this.

Now I want to display the query result like

insert into Table(UserName, Password, Country, Email) 
values('Test1', '1234', 'India', 'abc@xyz.com')

The values shown will be the parameters that I added.

As far as I know in php when we echo the query and run it in browser we will get the value of parameters. But is there any possibilities here?.

marc_s
  • 732,580
  • 175
  • 1,330
  • 1,459
NewBie
  • 67
  • 3
  • 11

1 Answers1

1

SQL command text and parameters are send to sql server separately, you can't get the final sql statement using SqlCommand, try using SQL Profiler.

Damith
  • 62,401
  • 13
  • 102
  • 153