asp.net计算员工平均工资的代码
时间: 2023-08-06 17:26:42 浏览: 44
以下是一个计算员工平均工资的示例代码:
```csharp
using System;
using System.Data.SqlClient;
public partial class Default : System.Web.UI.Page
{
protected void Page_Load(object sender, EventArgs e)
{
// 连接数据库
string connectionString = "Data Source=(local);Initial Catalog=YourDatabase;Integrated Security=True";
using (SqlConnection connection = new SqlConnection(connectionString))
{
// 查询总工资
string queryTotalSalary = "SELECT SUM(Salary) AS TotalSalary FROM Employees";
SqlCommand commandTotalSalary = new SqlCommand(queryTotalSalary, connection);
connection.Open();
int totalSalary = (int)commandTotalSalary.ExecuteScalar();
// 查询员工数量
string queryTotalEmployees = "SELECT COUNT(*) AS TotalEmployees FROM Employees";
SqlCommand commandTotalEmployees = new SqlCommand(queryTotalEmployees, connection);
int totalEmployees = (int)commandTotalEmployees.ExecuteScalar();
// 计算平均工资
int avgSalary = totalSalary / totalEmployees;
// 显示结果
lblResult.Text = "总工资:" + totalSalary.ToString() + "<br />";
lblResult.Text += "员工数量:" + totalEmployees.ToString() + "<br />";
lblResult.Text += "平均工资:" + avgSalary.ToString();
}
}
}
```
请注意,这只是一个简单的示例代码,您需要根据您的实际情况进行调整。另外,此示例使用了 SQL Server 数据库,如果您使用的是其他类型的数据库,代码可能需要进行调整。