five different sql query in gridview five rows as a textbox or lable

Question

HiiASPNET SQL2005I need to get five different sql query in gridview five rows as a textbox or lable ex SELECT  COUNT FROM table1 WHERE CATEGORYcat1SELECT  COUNT FROM table2 WHERE CATEGORYcat2SELECT  COUNT FROM table3 WHERE CATEGORYcat3SELECT  COUNT FROM table4 WHERE CATEGORYcat4SELECT  COUNT FROM table5 WHERE CATEGORYcat5 gridview CATEGORY COUNT LASTUPDATEcat1         1242    132016cat2         1242    132016cat3         1242    132016cat4         1242

manvendra45 · Accepted Answer

make a stored procedure to get all the count table data with cateory name and bind gridview with eval as catcountdata CREATE Procedure getallcountwithcatasbeginSELECT 39cat139  as cat  count as countdata FROM table1 WHERE CATEGORY39cat139union allselect 39Cat239 as cat count as countdata  FROM table2 WHERE CATEGORY39cat239union allselect 39Cat339 as cat count as countdata   FROM table3 WHERE CATEGORY39cat339union allselect 39cat439 as cat count as countdata   FROM table4 WHERE CATEGORY39cat439union allselect 39cat539 as cat count as countdata   FROM table5 WHERE CATEGORY39cat539endif you want find last updated time tha u  will have to add one filed updatetime and fill this field when any update u  have done and select last one last updated time and pass this every tablei have change above stored procedure to get catcountdataupdatetime CREATE Procedure getallcountwithcatasbegindeclare  catupdatetim

five different sql query in gridview five rows as a textbox or lable

Company

Explore

Follow us

Contact Us