July 5, 2009 04:15pm pdt

1. abel 285,609
2. oobayly 259,609
3. Idle_Mind 223,540
4. TheLearn... 214,200
5. CodeCruiser 191,850
6. jpaulino 173,607
7. Dhaest 170,254
8. emoreau 147,684
9. nmarun 142,607
10. ragi0017 113,460
11. kaufmed 107,540
12. sunithnair 92,140
13. webtubbs 91,964
14. Fernando... 90,262
15. Juan_Bar... 86,494
16. daveamour 85,717
17. aibusines... 79,782
18. Tiggerito 76,089
19. angelIII 69,120
20. pivar 61,100
21. jensfiederer 60,125
22. DropZone 57,660
23. wht1986 57,166
24. ged325 51,475
25. amar31... 51,010

1. TheLearn... 2,266,162
2. Idle_Mind 955,307
3. iboutchkine 809,868
4. emoreau 732,402
5. Dhaest 563,521
6. mmarinov 556,677
7. jpaulino 551,755
8. gregoryyo... 527,816
9. Fernando... 473,032
10. jaime_oliv... 467,942
11. graye 454,551
12. naveenko... 451,699
13. testn 352,601
14. RobertRFr... 333,569
15. angelIII 333,228
16. YZlat 332,657
17. surajguptha 324,880
18. Arthur_... 311,249
19. webtubbs 306,271
20. AlexFM 304,664
21. abel 302,509
22. jensfiederer 285,840
23. Mikal613 270,108
24. VBRocks 262,170
25. oobayly 259,609

	[x] Posted via EE Mobile
	Search, ask, and monitor your questions on the go with EE Mobile. Visit Experts Exchange from your mobile device and never be out of touch again.

09/10/2008 at 10:32AM PDT, ID: 23720168

	[x] Attachment Details

[x]

The Solution Rating System

With so many solutions, how can you tell which solutions are most likely to help you and which ones are not? To provide you with a tool to use, we rate our solutions based on various elements that most accurately determine if a solution is a quality solution. To explain what factors affect the solution rating, here are the elements we take into consideration when formulating our solution rating.

The Grade of the Solution
The Zone Rank of the Expert Providing the Solution
The Number of Author and Expert Comments
The Number of Experts Contributing
The Feedback of the Community

Your Input Matters
Because of the way the system is set up, the most important variable in this equation is you. As a member of Experts Exchange, you are able to cast your vote on the quality of the solutions in regard to how complete, accurate, helpful and easy to understand each solution is. When you provide your feedback, each rating is adjusted accordingly. So, if you see a solution that has a poor rating that you think is a good solution, let us know by rating it. As you do, the rating will be adjusted and will become more accurate for other members of our site.

If you have any suggestions that you would like to make for our rating system, please ask a question in the Suggestions Zone of Community Support.

Thank you!

8.0

Trying to pass a variable in a select statement

Asked by lvjan777 in .NET, Microsoft Visual Basic.Net, Scripting Languages

Tags: VB.Net, IE, NA

How can I grab the user name to display only his information in the grid view. I'm using User Authentication and want to match the CurrentUser to the Project Lead Name.

In the following code in the WHERE clause if I put "FirstName LastName" it will work, but I want to grab the person who's logged in and display if Display Name and Current User Name match.
WHERE (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = "FirstName LastName")View the Solution FREE for 30 Days

         
             SELECT     ID, [Project Title] AS Project_Title, [Project Priority] AS Project_Priority, [Project Lead Name] AS Project_Lead_Name, [End Date] AS End_Date, 
                      [Current Status] AS Current_Status, Active, Shop
FROM         projectDetails
WHERE     (Active = ?) AND (Completed = ?) AND ([Project Lead Name] = CurrentUser.DisplayName)
ORDER BY [End Date] DESC
 
reference in code behind
Dim X As String
  X = CurrentUser.DisplayName
  displayName.Text = CurrentUser.DisplayName

20090624-EE-VQP-63 / EE_QW_2_20070628

Trying to pass a variable in a select statement

Asked by lvjan777 in .NET, Microsoft Visual Basic.Net, Scripting Languages

Tags: VB.Net, IE, NA

About this solution