SqlCommand Parameterized query problems

[benson.wong]

such as the following code :
...
string insertsql="INSERT INTO table (id,name) VALUES (@id,@name)";
SqlCommand cmd=new SqlCommand(insertsql,connection);
cmd.Parameters.Add(@id,1);
cmd.Parameters.Add(@name,"benson");

cmd.ExecuteNonQuery();

How do I get a real SQL? cmd.CommandText get "INSERT INTO table (id,name)
VALUES (@id,@name)",
I hope to have "INSERT INTO table (id,name) VALUES (1,'benson')"

[Hasan Prog]

15 Kasım 2009 Pazar 04:43:04 UTC+2 tarihinde benson.wong yazdı:

Hi Benson
try please;

string insertsql = "INSERT INTO table (id,name) VALUES (@id,@name)";

SqlCommand cmd = new SqlCommand(insertsql, connection);

cmd.CommandText = CommandType.Text;
cmd.Parameters.Add(@id, 1);
cmd.Parameters.Add(@name, "benson");