This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(89.60000000000001, 64%, 18%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EAT%3C/text%3E%3C/svg%3E)
I am using the EXACT same query in SQL Server Management Studio (2014) as I am in my C# program, but I get different results. How is this possible?
My Query:
SELECT tblWTHistory.Date, tblWTHistory.EstCompDate, tblOperator.BadgeID, tblOperator.OperatorName, tblWTHistory.WONum, tblWTHistory.WOType, tblWTHistory.PartNum, tblWTHistory.CellReceivedQty, tblWTHistory.OpNum,
tblWorkCenter.WorkCenterName, tblWorkType.WorkTypeName, tblWTHistory.WorkQty, tblWTStatus.StatusName, tblWTHistory.ReasonID, tblWTReasons.ReasonName, tblWTHistory.Rework, tblWTHistory.OpComment
FROM tblWTHistory INNER JOIN
tblWTReasons ON tblWTHistory.ReasonID = tblWTReasons.ReasonID INNER JOIN
tblWTStatus ON tblWTHistory.StatusID = tblWTStatus.StatusID INNER JOIN
tblWorkType ON tblWTHistory.WorkTypeID = tblWorkType.WorkTypeID INNER JOIN
tblWorkCenter ON tblWTHistory.WorkCenterID = tblWorkCenter.WorkCenterID INNER JOIN
tblOperator ON tblWTHistory.OperatorID = tblOperator.OperatorID
WHERE (tblWTHistory.CellReceivedQty > 0) AND (FORMAT(tblWTHistory.EstCompDate, 'yyyy-MM-dd') >= '2025-02-10') AND (FORMAT(tblWTHistory.EstCompDate, 'yyyy-MM-dd') <= '2025-02-13') AND (tblWTHistory.WOType = 'WO') AND
(tblWTHistory.WONum = '1858974')
ORDER BY tblWTHistory.PartNum, tblWTHistory.WONum, tblWTHistory.OpNum, tblWTHistory.StatusID, tblWTHistory.OperatorID, tblWTHistory.Date
C# Code:
string sSQL = "" Same query as above
SqlCommand myCmd = new SqlCommand(sSQL, myConnection);
SqlDataReader dr = myCmd.ExecuteReader();
When I loop through the dr I get 3 records while the "Results" pane in SSMS gives me the correct 4 records.
Anyone else ever run into a problem like this?
Query got all chopped up when I submitted the question. Anyway same query, different results
Is the loop correct?
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(51.2, 62%, 14%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EHY%3C/text%3E%3C/svg%3E)
Hi, @Alvord, Timothy. Welcome to Microsoft Q&A.
In my test, the query results of the database are consistent with those of the C# code.
Please check:
SQL Server and Microsoft.Data.SqlClient versions to avoid version issues.string connectionString = "...";
string query = @"
SELECT tblWTHistory.Date, tblWTHistory.EstCompDate, tblOperator.BadgeID, tblOperator.OperatorName, tblWTHistory.WONum, tblWTHistory.WOType, tblWTHistory.PartNum, tblWTHistory.CellReceivedQty, tblWTHistory.OpNum, tblWorkCenter.WorkCenterName, tblWorkType.WorkTypeName, tblWTHistory.WorkQty, tblWTStatus.StatusName, tblWTHistory.ReasonID, tblWTReasons.ReasonName, tblWTHistory.Rework, tblWTHistory.OpComment
FROM tblWTHistory
INNER JOIN tblWTReasons ON tblWTHistory.ReasonID = tblWTReasons.ReasonID
INNER JOIN tblWTStatus ON tblWTHistory.StatusID = tblWTStatus.StatusID
INNER JOIN tblWorkType ON tblWTHistory.WorkTypeID = tblWorkType.WorkTypeID
INNER JOIN tblWorkCenter ON tblWTHistory.WorkCenterID = tblWorkCenter.WorkCenterID
INNER JOIN tblOperator ON tblWTHistory.OperatorID = tblOperator.OperatorID
WHERE (tblWTHistory.CellReceivedQty > 0)
AND (FORMAT(tblWTHistory.EstCompDate, 'yyyy-MM-dd') >= '2025-02-10')
AND (FORMAT(tblWTHistory.EstCompDate, 'yyyy-MM-dd') <= '2025-02-13')
AND (tblWTHistory.WOType = 'WO')
AND (tblWTHistory.WONum = '1858974')
ORDER BY tblWTHistory.PartNum, tblWTHistory.WONum, tblWTHistory.OpNum, tblWTHistory.StatusID, tblWTHistory.OperatorID, tblWTHistory.Date";
using (SqlConnection connection = new SqlConnection(connectionString))
{
SqlCommand command = new SqlCommand(query, connection);
connection.Open();
using (SqlDataReader reader = command.ExecuteReader())
{
DataTable dataTable = new DataTable();
dataTable.Load(reader);
foreach (DataRow row in dataTable.Rows)
{
Console.WriteLine($"{row["Date"]}, {row["EstCompDate"]}, {row["BadgeID"]}, {row["OperatorName"]}, {row["WONum"]}, {row["WOType"]}, {row["PartNum"]}, {row["CellReceivedQty"]}, {row["OpNum"]}, {row["WorkCenterName"]}, {row["WorkTypeName"]}, {row["WorkQty"]}, {row["StatusName"]}, {row["ReasonID"]}, {row["ReasonName"]}, {row["Rework"]}, {row["OpComment"]}");
}
}
}
At the same time, if the problem still cannot be eliminated, please provide these 4 records for testing (Note: the records could reproduce the problem but avoid sensitive information).
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(211.20000000000002, 61%, 30%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EBS%3C/text%3E%3C/svg%3E)
I would guess either, they are not the same, probably one of the compare literals is different or the loop logic is wrong.