Advertisement
Guest User

Untitled

a guest
Dec 1st, 2015
75
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.16 KB | None | 0 0
  1. SqlConnection sqlConnection1 = new SqlConnection(MainWindow.g_strConn);
  2. Object returnValue;
  3.  
  4. //commend data 생성
  5. MySqlCommand cmd = new SqlCommand();
  6. cmd.Connection = MainWindow.g_MySqlConn;
  7. cmd.CommandText = "LoginAuthentication";
  8. cmd.CommandType = CommandType.StoredProcedure;
  9.  
  10. //파라메터로 넣을 값들 정의
  11. MySqlParameter parameter = new MySqlParameter();
  12. parameter.ParameterName = "@User_ID";
  13. parameter.MySqlDbType = MySqlDbType.VarChar;
  14. parameter.Direction = ParameterDirection.Input;
  15. parameter.Value = Id;
  16.  
  17. MySqlParameter parameter2 = new MySqlParameter();
  18. parameter2.ParameterName = "@User_Pwd";
  19. parameter2.MySqlDbType = MySqlDbType.VarChar;
  20. parameter2.Direction = ParameterDirection.Input;
  21. parameter2.Value = Pw;
  22.  
  23. cmd.Parameters.Add(parameter);
  24. cmd.Parameters.Add(parameter2);
  25.  
  26. MainWindow.g_MySqlConn.Open();
  27.  
  28. returnValue = cmd.ExecuteScalar();
  29.  
  30. MainWindow.g_MySqlConn.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement