how to use the SqlCommand.Parameters thing?

[PT Exorcist]

i can add parameters to it..but how do i set if i wanna do a Insert/Delete etc statement in the sql database?

[PT Exorcist]

bump!

[DevGrp]

For an insert do this

string sqlString = "INSERT INTO MyTable(fname, lname, city) VALUES(@fname, @lname, @city)";

SqlCommand cmd = new SqlCommand(sqlString, sqlConnection);

cmd.Parameters.Add("@fname", "Dev");
cmd.Parameters.Add("@lname", "Group");
cmd.Parameters.Add("@city", "Brooklyn");


For a delete

string sqlString = "DELETE FROM MyTable WHERE fname = @fname";

SqlCommand cmd = new SqlCommand(sqlString, sqlConnection);

cmd.Parameters.Add("@fname", "Dev");

[PT Exorcist]

tks by the answer but i've already had figured it out by your web log source code! tks anyways!

[DevGrp]

No prob