Writing a stored Procedure in ASP

Sir, my code was :


Repected People,

I wrote a stored procedure which was to display the number of times a name was repeated.

So i wrote the procedure as above stated , let me reformulate :

STORED PROCEDURE:

ALTER PROCEDURE countentries
/*
(
@parameter1 int = 5,
@parameter2 datatype OUTPUT
)
*/
AS
select Name ,Count(*) As Count from contacts
group by Name
/* SET NOCOUNT ON */
RETURN

Now in the SQLDataSource i did something like this :

<pre lang="xml"><asp:SqlDataSource ID="sql" runat="server" ConnectionString="<%$ ConnectionStrings:contacts %>" SelectCommandType="StoredProcedure" SelectCommand="countentries" /></pre>

I wanted to display the count of "Name" column, i finally used a grid view to show the result.
The grid view extracted the result out of my select statement.

But my experiment was to try it out on a Details View, but it failed let me show you the code:

<pre lang="xml"><asp:DetailsView id="dv" DataSourceID="sql" AllowPaging="true" AutoGenerateEditButton="true" AutoGenerateDeleteButton="true" AutoGenerateInsertButton="true" AutoGenerateRows="false" CssClass="detailsview" PagerSettings-Mode="NumericFirstLast" runat="server"><Fields><asp:BoundField DataField="Name" ReadOnly="true" HeaderText="Person Name" InsertVisible="true" /><asp:BoundField DataField="Count" HeaderText="Count" ReadOnly="false" InsertVisible="true" /> </Fields></asp:DetailsView></pre>


Thanks

5.