Posted on: 9/10/2013 8:50:23 AM | Views : 624

hi,

I have a country table and Models  table in my database.
The application is using a data access layer and table adaptors
I setup a Select query that returns the number of models in each  Country.
problem is it also returns 0 values and they show in the gridview when I bind the data

here is my query in the DAL of the country table
i use not null but it does not work

SELECT        CountryId, [Sort Order], CommonName,  (SELECT COUNT(CountryId) FROM Model WHERE CountryId IS NOT NULL AND Pictures=1 AND (CountryId=Country.CountryId)) AS ModelsWithImages,  ModelId                    FROM            Country ...

Go to the complete details ...