public DataSet consultarTodos()
{
String SQL = "SELECT idGeneros as ID, generos as Genero FROM dbo.Generos";
Conexao oConexao = new Conexao("SQLServer");
SqlDataAdapter adapter = new SqlDataAdapter(SQL, oConexao.cn);
DataSet ds = new DataSet("Tabela");
adapter.Fill(ds, "Tabela");
oConexao.fechaConexao();
return ds;
}