how to use the SqlCommand.Parameters thing?

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

bump!

For an insert do this

Code:

---

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

Code:

---

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

SqlCommand cmd = new SqlCommand(sqlString, sqlConnection);

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

---

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

No prob