Retrieving a single value from a database

Run your stored proc or query and then use the SqlCommand object to call the ExecuteScalar method. This method will return a single value.

//conn is your SqlConnection

SqlCommand cmd = new SqlCommand(("select count(*) from Items", conn);

int items = (int)cmd.ExecuteScalar(); //will return an integer value