| public executeReader ( String SQL ) : System.Data.SqlClient.SqlDataReader | ||
| SQL | String | |
| return | 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();
}