ExecuteNonQuery()
<p>Hey, this is my (rough)code (DAL)</p>

<pre><code>int i;
// some other declarations

SqlCommand myCmdObject = new SqlCommand("some query");

conn.open();

i = myCmdObject.ExecuteNonQuery();

conn.close();
</code></pre>

<p>so the problem is even though there is a record present on my <code>SELECT</code> query, the value in <code>i</code> remains <code>-1</code></p>

<p>what could be the problem</p>

<p>thanks in advance.</p>
