Guest User

Untitled

a guest
May 3rd, 2018
109
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 0.74 KB | None | 0 0
  1. public static void GetTables(Members src)
  2. {
  3.  
  4. OracleConnection conn1 = MyConnectionClass.GetConnection(src.DB, src.ID, src.Password);
  5.  
  6. conn1.Open();
  7. using (OracleCommand command= new OracleCommand("SELECT * FORM DBA_USERS WHERE USER NAME=" + src.ID + " and PASSWORD=" + src.Password + "", conn1))
  8. {
  9. using (OracleDataReader reader = command.ExecuteReader())
  10. {
  11. int count = 0;
  12. while (reader.Read())
  13. {
  14. count = count + 1;
  15. }
  16. }
  17. }
  18. }
  19.  
  20. SELECT * FROM DBA_USERS WHERE USERNAME=" + src.ID + " and PASSWORD=" + src.Password + ""
  21.  
  22. SELECT * FROM DBA_USERS WHERE USERNAME=:uname and PASSWORD=:pwd
Add Comment
Please, Sign In to add comment