Maybe this will help you guys understand this better..
Source code:
<asp:ObjectDataSource ID="odsGVMembers" runat="server"
SelectMethod="getMemtype" TypeName="WCSMemberManagement.BAL">
<SelectParameters>
<asp:ControlParameter ControlID="ddlMemberType" DefaultValue="9" Name="MemID"
PropertyName="SelectedValue" Type="Int32" />
</SelectParameters>
</asp:ObjectDataSource>
Stored Procedure:
ALTER PROCEDURE [dbo].[GetMembersOfAMemberType]
@MemberType INT
AS
BEGIN
SET NOCOUNT ON;
SELECT
m.MemberID
, m.FirstName
, m.LastName
, m.MemberTypeID
, mt.MemberTypeDescription
FROM dbo.tblMember m
INNER JOIN dbo.lkpMembershipType mt
ON m.MemberTypeID = mt.MemberTypeID
WHERE m.MemberTypeID = @MemberType
END