Dear sir,
I want to know how to count items/products using stored procedure in Asp.net C#.
Example : i am using repeater control to display Categories.
Categories
-------------
Shoes : 2
Paint : 7
Skirts : 204
Abaya : 1
Burka : 6
-------------------------------
I have Written stored procedure "GetItemCount" but how to call it in c# code i do not know plz help me.
it is working fine Query showing result as per my desire.
SELECT id, category, ( SELECT COUNT(id) FROM entry_table WHERE
category.id = entry_table.cat_id) as cnt FROM category
plz check screen-shot below.
http://www.fzkdesign.com/img/item-count.jpg
-------------------
<asp:HyperLink ID="HyperLink2">
<%#DataBinder.Eval(Container,"DataItem.Category")%>
 ( <%# count here %> )
</asp:HyperLink>
Regards
firoz khan
Delhi
firoz.webdesigner@gmail.com
