如何使用带有两个参数的SQL Server存储过程填充表适配器

CREATE PROCEDURE GetEmployees
    @DepartmentId INT,
    @Salary DECIMAL(10, 2)
AS
BEGIN
    SELECT * FROM Employees
    WHERE DepartmentId = @DepartmentId AND Salary > @Salary
END

using System;
using System.Data;
using System.Data.SqlClient;

public class Program
{
    public static void Main()
    {
        string connectionString = "YourConnectionString";
        using (SqlConnection connection = new SqlConnection(connectionString))
        {
            SqlCommand command = new SqlCommand("GetEmployees", connection);
            command.CommandType = CommandType.StoredProcedure;

            // 设置存储过程参数
            command.Parameters.AddWithValue("@DepartmentId", 1);
            command.Parameters.AddWithValue("@Salary", 50000);

            SqlDataAdapter adapter = new SqlDataAdapter(command);
            DataTable dataTable = new DataTable();

            // 填充表适配器
            adapter.Fill(dataTable);

            // 处理结果集
            foreach (DataRow row in dataTable.Rows)
            {
                Console.WriteLine(row["EmployeeName"]);
            }
        }
    }
}