C#中SQL查询结果无法写入HolEmpName文本框问题求助

Hey Matt, let's break down why your HolEmpName textbox is staying empty even though your C# code has no syntax errors. Since you're working with the Employees and Holidays tables, I'll focus on the most likely culprits tied to that setup:

This is the #1 reason for empty textboxes in this scenario. Double-check your JOIN logic between Employees and Holidays—maybe you're using a mismatched key (like EmployeeID vs EmpID) or your WHERE clause is filtering out all results.

Test this easily: Copy your exact SQL query into your database tool (like SSMS) and replace any parameters with hardcoded values. For example, if your query looks like this:

SELECT e.EmpName 
FROM Employees e
INNER JOIN Holidays h ON e.EmployeeID = h.EmployeeID
WHERE h.HolidayDate = '2024-01-01'

Plug in that date (or whatever parameter you're using) and see if any rows pop up. If not, your query is the problem, not your C# code.

Even if the query returns data, you might be skipping a step when retrieving it. Common mistakes here include:

• Using ExecuteScalar() when your query returns multiple columns (it only grabs the first value of the first row)
• Forgetting to call Read() on your SqlDataReader before accessing values
• Not handling cases where no rows are returned

Here's a corrected example of reading results properly:

using (var connection = new SqlConnection(yourConnectionString))
{
    connection.Open();
    var query = "SELECT e.EmpName FROM Employees e JOIN Holidays h ON e.EmployeeID = h.EmployeeID WHERE h.HolidayID = @HolidayID";
    using (var cmd = new SqlCommand(query, connection))
    {
        cmd.Parameters.AddWithValue("@HolidayID", selectedHolidayId);
        using (var reader = cmd.ExecuteReader())
        {
            // Make sure we actually have a row to read
            if (reader.Read())
            {
                HolEmpName.Text = Convert.ToString(reader["EmpName"]);
            }
            else
            {
                // Optional: Tell the user no match was found
                HolEmpName.Text = "No assigned employee";
            }
        }
    }
}

If the EmpName field in Employees allows nulls, calling ToString() directly on a null value will throw an exception (and if you're swallowing exceptions silently, you won't see this happen).

Instead, use Convert.ToString()—it safely handles nulls by returning an empty string:

HolEmpName.Text = Convert.ToString(reader["EmpName"]);

If you're running your database query in a background thread (like with Task.Run()), directly setting HolEmpName.Text will cause a cross-thread access issue. This might not throw an error if CheckForIllegalCrossThreadCalls is disabled, but it won't update the UI either.

Fix this by marshalling the update back to the UI thread with Invoke:

// Inside your background task, after retrieving the employee name
this.Invoke((Action)(() => {
    HolEmpName.Text = retrievedEmployeeName;
}));

Double-check that your parameter names match exactly what's in your SQL query (some databases are case-sensitive) and that you're passing the correct data type. For example, if HolidayID is an integer, don't pass a string value—this can cause implicit conversion issues that return no results.

Example of correct parameter setup:

cmd.Parameters.Add("@HolidayID", SqlDbType.Int).Value = selectedHolidayId;

内容的提问来源于stack exchange，提问作者Matt