我有一張桌子，我無法從中選擇最高工資。這是我的代碼...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
2 回答
隔江千里
TA貢獻1906條經驗 獲得超10個贊
using (SqlCommand cmd = new SqlCommand("SELECT MAX(salary) FROM test"), con)
{
int maxSalary = (int)cmd.ExecuteScalar();
}
PIPIONE
TA貢獻1829條經驗 獲得超9個贊
con.Open();
SqlCommand cmd = new SqlCommand("SELECT max(salary) FROM test"), con);
count = (int)cmd.ExecuteScalar();
con.Close();
MessageBox.Show("Maximum salary is" +count);
- 2 回答
- 0 關注
- 179 瀏覽
添加回答
舉報
0/150
提交
取消