Only What I Want Is How To Count Pairs Under Particular User?

Question

1.00/5 (2 votes)

See more:

i am creating multi level binary tree project in asp.net. i have developed binary tree successfully till now. but i now i have to count pairs for particular user. suppose, one person registers two person under them that is called one pair. and if both registered persons also registers two and two under them.. then that is called three pairs. only what i want is how to count pairs under particular user???

Follow this article www.rajneeshverma.com/?tag=/Multi-level-marketing. I understand all the other things from that article but now understand how to count pairs.. Hope you understand my question now...

Posted 13-Feb-14 1:36am

Harpreet_125

Updated 13-Feb-14 3:52am

v3

Add a Solution

Comments

CHill60 13-Feb-14 8:19am

Your question doesn't really make sense. Use the Improve question link to add a detailed explanation of where you are stuck

Harpreet_125 13-Feb-14 9:52am

ZurdoDev 13-Feb-14 8:55am

I have no ideas either. Actually, I do have one. Please explain more clearly what you are asking.

Harpreet_125 13-Feb-14 9:53am

Hope you understand my question now...

ZurdoDev 13-Feb-14 9:54am

Somewhat. But where are you stuck?

Harpreet_125 13-Feb-14 10:00am

i have no idea how to count pairs for a user from database.. like pairs are showing in binary tree. i am saving data same like article.. any suggestions

ZurdoDev 13-Feb-14 10:01am

To count pairs in a database you use GROUPING. For example:

SELECT userid, COUNT(*) AS pairs
FROM table
GROUP BY userid

something along those lines.

Sergey Alexandrovich Kryukov 13-Feb-14 9:13am

Not even a question. There is nothing to discuss here. To get help, you need to do some decent job to formulate your problem.
—SA

Harpreet_125 13-Feb-14 9:53am

Hope you understand my question now...

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Joshi, Rushikesh · Answer 1 · 2014-02-13T17:05:00

Harpreet, I read all comments above.

I think you need to write a recursive function which will keep checking for children members available or not. Either you can implement Breadth Search or Depth Search Algorithms depending on your number of levels. (See Data Structure Algorithms for same).

Writing such method on UI is only advisable if you have Irrational Database (Objects), if you are thinking to get data from database. Then I would suggest you to write such functionality in database itself. (I had bad experience long back when I wrote such functionality in UI, but I was just college graduate and was not using Internet much :) )

-- Thanks Rushi