Comments by Member 4115931 (Top 1 by date)

Member 4115931 30-Mar-18 16:48pm View

string scount;
MySqlConnection con = new MySqlConnection(connectionString);
con.Open();
str = "SELECT COUNT(*) FROM UserData ud, UserInformation ui WHERE ud.SponsorId=ui.PromoterId and ui.PromoterId='RE3103121' and ud.SponsorId='RE3103121'";
com = new MySqlCommand(str, con);
int count = Convert.ToInt32(com.ExecuteScalar());
scount = Convert.ToString(count);
DownLineDirect.Text = scount;

Actually i try to count only similar data id

SponsorId PromoterId
RE01453 RE01454
RE01454 RE01455
RE01454 RE01456
RE01454 RE01457
RE01455 RE01458
RE01455 RE01459

TOTAL NUMBER THIS ID DATA FROM RE01454
DATA 3
BUT THIS ID JOIN ID RE01455
DATA 2

TOTAL NUMBER RE01454 THIS ID 5

PLEASE HELP ME