Persistencia.Conexao.executeReader C# (CSharp) Method

executeReader() public method

public executeReader ( String SQL ) : System.Data.SqlClient.SqlDataReader
SQL String
return System.Data.SqlClient.SqlDataReader
        public SqlDataReader executeReader(String SQL)
        {
            SqlCommand cmd = cn.CreateCommand();
            cmd.CommandText = SQL;
            return cmd.ExecuteReader();
        }

Usage Example

Example #1
0
        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();
        }
All Usage Examples Of Persistencia.Conexao::executeReader