Instead of
ExecuteNonQuery
, use
ExecuteScalar
- it returns a single value to the caller:
using (SqlConnection sqlCon = new SqlConnection(connectionString))
{
sqlCon.Open();
using (SqlCommand sqlCmd = new SqlCommand("spPeople_AddPerson", sqlCon))
{
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.Parameters.AddWithValue("@FirstName", txtFirstName.Text.Trim());
sqlCmd.Parameters.AddWithValue("@LastName", txtLastName.Text.Trim());
int result = (int) sqlCmd.ExecuteScalar();
...
}
}