sql server - Calling Procedure in asp.net -

i want call procedure populate drop down in form. right using code this:

 <td class="style4">choose category:&nbsp;<font color="red">*</font></td>  <td class="style3">      <asp:dropdownlist id="dropdownlist1" runat="server" datasourceid="cat1"                                                         datatextfield="catname" datavaluefield="catname">      </asp:dropdownlist>      <asp:sqldatasource id="cat1" runat="server" connectionstring="<%$ connectionstrings:billingdatabase%>" providername="system.data.sqlclient" selectcommand="select [catname] [category]">      </asp:sqldatasource>  </td> 

the procedure:

go create procedure [dbo].[spshowproducts] begin   select catname category  end go 

sorry, i'm not sure understand question - more details appreciated.

if user defined function stored procedure should able use basis data. bind dropdownlist sqldatasource, , set source sqldatasource name of stored procedure rather specifying raw sql.