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

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     salary

a       10000

b       31000

c       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);