Advertisement
Guest User

Untitled

a guest
Oct 5th, 2015
85
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.03 KB | None | 0 0
  1. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login=sl AND password=sp";
  2.  
  3. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login="+sl+" AND password="+sp;
  4.  
  5. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login=@sl AND password=@sp
  6.  
  7. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login="""+sl+""" AND password="""+sp+""""
  8.  
  9. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login=? AND password=?";
  10. // параметры подставляются по порядку, именя можно задать любые
  11. myOleDbCommand.Parameters.AddWithValue("Login", sl);
  12. myOleDbCommand.Parameters.AddWithValue("Password", sp);
  13.  
  14. myOleDbCommand.CommandText = "SELECT Login FROM People WHERE Login=@Login AND password=@Password";
  15. // параметры подставляются по имени, старый Access такое может не переварить
  16. myOleDbCommand.Parameters.AddWithValue("@Login", sl);
  17. myOleDbCommand.Parameters.AddWithValue("@Password", sp);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement