无法从表格中显示最高工资（测试）

Question

我有一张桌子，我无法从中选择最高工资。这是我的代码...con.Open();SqlCommand cmd = new SqlCommand("SELECT MAX(salary) AS MAximumSalary FROM test", con);cmd.ExecuteNonQuery();    DataTable dt = new DataTable();SqlDataAdapter sda = new SqlDataAdapter(cmd);sda.Fill(dt);count =Convert.ToInt32(dt.Rows.Count.ToString());con.Close();MessageBox.Show("Maximum salary is" +count);这是我的数据库：-name     salarya       10000b       31000c       17000

Answer 1

using (SqlCommand cmd = new SqlCommand("SELECT MAX(salary) FROM test"), con)

{

    int maxSalary = (int)cmd.ExecuteScalar();

}

Answer 2

con.Open();

SqlCommand cmd = new SqlCommand("SELECT max(salary) FROM test"), con);

count = (int)cmd.ExecuteScalar();

con.Close();

MessageBox.Show("Maximum salary is" +count);