public executeReader ( String SQL ) : System.Data.SqlClient.SqlDataReader | ||
SQL | String | |
리턴 | System.Data.SqlClient.SqlDataReader |
public void logar(String usuario, String senha) { String SQL = "SELECT * FROM dbo.CadLogin WHERE usuario = '" + usuario + "' AND senha= '" + senha + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idCadLogin = Convert.ToString(dr["idCadLogin"]); } dr.Close(); oConexao.fechaConexao(); }
public void logar(String usuario, String senha) { String SQL = "SELECT * FROM dbo.CadLogin WHERE usuario = '" + usuario + "' AND senha= '" + senha + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idCadLogin = Convert.ToString(dr["idCadLogin"]); } dr.Close(); oConexao.fechaConexao(); }
public void logar(String nomeUsuario, String senha) { String SQL = "SELECT * FROM Usuarios WHERE nome = '" + nomeUsuario + "' AND senha= '" + senha + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idUsuario = Convert.ToString(dr["idUSuario"]); } dr.Close(); oConexao.fechaConexao(); }
public void logar(String nomeUsuario, String senha) { String SQL = "SELECT * FROM Usuarios WHERE nome = '" + nomeUsuario + "' AND senha= '" + senha + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idUsuario = Convert.ToString(dr["idUSuario"]); } dr.Close(); oConexao.fechaConexao(); }
public void RecSenha(String idCadLogin, String email, String usuario, String senha) { String SQL = "SELECT idCadLogin, email, usuario, senha FROM dbo.CadLogin WHERE email = '" + email + "' AND usuario= '" + usuario + "' UPDATE dbo.CadLogin"; SQL += " SET senha = " + senha; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idCadLogin = Convert.ToString(dr["idCadLogin"]); } dr.Close(); oConexao.fechaConexao(); }
public void verificarEmail(String email) { String SQL = "SELECT * FROM Usuarios WHERE email = '" + email + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idUsuario = Convert.ToString(dr["idUSuario"]); this.email = Convert.ToString(dr["email"]); this.senha = Convert.ToString(dr["senha"]); } dr.Close(); oConexao.fechaConexao(); }
public void RecSenha(String idCadLogin, String email, String usuario, String senha) { String SQL = "SELECT idCadLogin, email, usuario, senha FROM dbo.CadLogin WHERE email = '" + email + "' AND usuario= '" + usuario + "' UPDATE dbo.CadLogin"; SQL += " SET senha = " + senha; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idCadLogin = Convert.ToString(dr["idCadLogin"]); } dr.Close(); oConexao.fechaConexao(); }
public void verificarEmail(String email) { String SQL = "SELECT * FROM Usuarios WHERE email = '" + email + "'"; Conexao oConexao = new Conexao("SQLServer"); SqlDataReader dr = oConexao.executeReader(SQL); while (dr.Read()) { this.idUsuario = Convert.ToString(dr["idUSuario"]); this.email = Convert.ToString(dr["email"]); this.senha = Convert.ToString(dr["senha"]); } dr.Close(); oConexao.fechaConexao(); }