Advertisement
Guest User

Untitled

a guest
Dec 7th, 2016
58
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.66 KB | None | 0 0
  1. string query = @"SELECT SUM(CAST(ConcurrentUsers AS INT)) FROM [website].[db]
  2. WHERE(ConcurrencyLicensing NOT LIKE 0)";
  3.  
  4. SqlConnection conn = new SqlConnection(entityBuilder.ProviderConnectionString);
  5. SqlCommand cmd = new SqlCommand(query, conn);
  6.  
  7. try
  8. {
  9. conn.Open();
  10.  
  11. object userNameObj = cmd.ExecuteScalar();
  12.  
  13. if(userNameObj != null)
  14. {
  15. int getUserName = (int)userNameObj;
  16. return getUserName;
  17. }
  18. else
  19. {
  20. return 0;
  21. }
  22. }
  23. finally
  24. {
  25. conn.Close();
  26. }
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement