使用asp.net显示值在不同表中的GridView中的名称而不是Id

<asp:TemplateField HeaderText="Customer">
    <ItemTemplate>
        <%# GetCustomerName(Eval("CustomerID")) %>
    </ItemTemplate>
</asp:TemplateField>

protected string GetCustomerName(object customerID)
{
    // 查询数据库或其他方式获取客户名称
    // 示例代码：
    string connectionString = "YourConnectionString";
    string query = "SELECT Name FROM Customers WHERE CustomerID = @CustomerID";
    
    using (SqlConnection connection = new SqlConnection(connectionString))
    {
        using (SqlCommand command = new SqlCommand(query, connection))
        {
            command.Parameters.AddWithValue("@CustomerID", customerID);
            connection.Open();
            string customerName = command.ExecuteScalar()?.ToString();
            return customerName;
        }
    }
}