Hii,,
ASP.NET SQL2005
I need to get five different sql query in gridview five rows as a textbox or lable
ex- SELECT COUNT(*) FROM table1 WHERE CATEGORY='cat1'
SELECT COUNT(*) FROM table2 WHERE CATEGORY='cat2'
SELECT COUNT(*) FROM table3 WHERE CATEGORY='cat3'
SELECT COUNT(*) FROM table4 WHERE CATEGORY='cat4'
SELECT COUNT(*) FROM table5 WHERE CATEGORY='cat5'
gridview
CATEGORY COUNT LASTUPDATE
cat1 1242 1/3/2016
cat2 1242 1/3/2016
cat3 1242 1/3/2016
cat4 1242 1/3/2016
cat5 1242 4/3/2016