How to add table to stored procedure

Question

Hi,

 

this is my table structure :

 

 

 

and this is my stored procedure :

 

ALTER PROCEDURE [dbo].[uspGetAllTeamMembers](@TeamID INT)

AS

BEGIN


SELECT

tm.TeamID,
m.MemberID,

m.MemberName,

m.MemberStatus,

ml.MemberLoginName,
ml.MemberLoginID,

tm.MemberJoinedDate,

tm.MemberLeftDate


FROM TeamMember tm

INNER JOIN MemberLogin ml

ON tm.MemberLoginID = ml.MemberLoginID

INNER JOIN Member m

ON m.MemberID = ml.MemberID


WHERE tm.TeamID = @TeamID


END

 

so i want to add another table Team to this stored procedure to get the TeamStatus values=1

 

please give a help

Answer 1

If you are looking for a code to get the selected values from checkboxlist then you can use below code

var checkboxValues = [];
                //Get selected value from checkbox like below
                $('[id*=chktagindex] input:checked').each(function () {
                    checkboxValues.push(this.value);
                });
                var result = checkboxValues.toString();

 You need to change the checkboxlist markup like below

<asp:CheckBoxList ID="chktagindex" runat="server" Width="162px">
                <asp:ListItem Text="TagIndex1" Value="TagIndex1"> </asp:ListItem>
                <asp:ListItem Text="TagIndex2" Value="TagIndex2"></asp:ListItem>
                <asp:ListItem Text="TagIndex3" Value="TagIndex3"></asp:ListItem>
            </asp:CheckBoxList>

 

Answer 2

Hi Nitish,

As you have given heading of your question "checkboxlist select query in j query" and also provided your code snippet. But, you have not properly ask what difficulty you are facing? So, can you modify your question for better understanding?

Thanks