Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SqlConnection sqlConnection1 = new SqlConnection(MainWindow.g_strConn);
- Object returnValue;
- //commend data 생성
- MySqlCommand cmd = new SqlCommand();
- cmd.Connection = MainWindow.g_MySqlConn;
- cmd.CommandText = "LoginAuthentication";
- cmd.CommandType = CommandType.StoredProcedure;
- //파라메터로 넣을 값들 정의
- MySqlParameter parameter = new MySqlParameter();
- parameter.ParameterName = "@User_ID";
- parameter.MySqlDbType = MySqlDbType.VarChar;
- parameter.Direction = ParameterDirection.Input;
- parameter.Value = Id;
- MySqlParameter parameter2 = new MySqlParameter();
- parameter2.ParameterName = "@User_Pwd";
- parameter2.MySqlDbType = MySqlDbType.VarChar;
- parameter2.Direction = ParameterDirection.Input;
- parameter2.Value = Pw;
- cmd.Parameters.Add(parameter);
- cmd.Parameters.Add(parameter2);
- MainWindow.g_MySqlConn.Open();
- returnValue = cmd.ExecuteScalar();
- MainWindow.g_MySqlConn.Close();
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement