why sql delete query is not working
<p>I have a table <code>table1</code> with fields <code>id(int)</code>, <code>name(nchar)</code>, <code>grade(real)</code>.
The following code isn't working. There are no errors or warnings. The code executes well but the number of affected rows = 0.</p>

<p>MsSql Server</p>

<pre><code>sqlConnection1.Open();
SqlCommand cmd = new SqlCommand("Delete from [table1] where [id] = 1", sqlConnection1);
int c = cmd.ExecuteNonQuery();
sqlConnection1.Close();
</code></pre>

<p>All other queries are working well.</p>
