Friday, 13 September 2013

very strange issue; different results from same table

very strange issue; different results from same table

I am binding a gridview with some column from a database table, but it
shows different results in Pane and in Gridview. see the attachted images.


see the marked records why they are different, although they are comming
from the same table.
But yes for binding gridview I am using this query
SELECT mtblbuilding_budget_data.building_id,
mtblbuilding_budget_data.building_name,
mtblbuilding_budget_data.sanctioned_dpr,
mtblbuilding_budget_data.sanctioned_contract,
mtblblock.block_name
FROM mtblbuilding_budget_data
LEFT JOIN mtblblock
ON mtblblock.block_id = mtblbuilding_budget_data.block_id
WHERE mtblbuilding_budget_data.sfti_id = @SFTI_Id
AND mtblbuilding_budget_data.spmu_id = @SPMU_Id
ORDER BY mtblbuilding_budget_data.block_id

No comments:

Post a Comment