一个小函数，快来帮帮我

Question

public int FindByReaderID()
        {
            int penaltyID;
            try
            {
                cn.Open();
                SqlCommand cmd = new SqlCommand();
                cmd.Connection = cn;
                cmd.CommandText = "select max(penaltyID) from penalty";
                penaltyID = cmd.ExecuteNonQuery() + 1;
                cn.Close();
                return penaltyID;
            }
            catch (SqlException ex)
            {
                //System.Diagnostics.Debug.Print(ex.Message);
                cn.Close();
                return 0;
            }
        }我这个方法应该有问题，我想利用这个方法获得sql语句的值，就是max(penaltyID)的值，请问如何编程？高手指导一下吧~

Answer 1

            int penaltyID = 0;
            string sql = "select max(penaltyID) from penalty";
            SqlConnection conn = new SqlConnection("这里是数据库连接字符串");
            conn.Open();
            SqlCommand com = new SqlCommand(sql, conn);
            penaltyID = (int)com.ExecuteScalar();              
            com.Dispose();
            conn.Close();
            conn.Dispose();
            return penaltyID;