Problems with Dataset

Hi,

I'm trying to use a DataAdapter with a complex query (in Oracle) to fill a
Dataset, but the DataAdapter don't accept it, then I try to create the
Dataset manually with the same fields that the query returns in the Designer
that VS.NET2003 provides, and then, create the DataAdapter in runtime, with
the complex query, an then, fill the Dataset, but nothing happens. If I try
to do the same with a DataReader, it works without a problem. There is a
example of my code.

Dim daAdendums As New OracleClient.OracleDataAdapter(complexQuery, conn)
Dim dsAdendums As New PrintDoc.dataset_Adendums
Dim drData As OracleClient.OracleDataReader

daAdendums.Fill(dsAdendums) 'it don't works the dataset is empty
drData = daAdendums.SelectCommand.ExecuteReader 'it works without a problem

Can someone help me?? Thanks

can you please try

Dim dsAdendums As New PrintDoc.dataset_Adendums

as Dim dsAdendums As New DataSet

"SEGACO" wrote:

> Hi,
>
> I'm trying to use a DataAdapter with a complex query (in Oracle) to fill a
> Dataset, but the DataAdapter don't accept it, then I try to create the
> Dataset manually with the same fields that the query returns in the Designer
> that VS.NET2003 provides, and then, create the DataAdapter in runtime, with
> the complex query, an then, fill the Dataset, but nothing happens. If I try
> to do the same with a DataReader, it works without a problem. There is a
> example of my code.
>
> Dim daAdendums As New OracleClient.OracleDataAdapter(complexQuery, conn)
> Dim dsAdendums As New PrintDoc.dataset_Adendums
> Dim drData As OracleClient.OracleDataReader
>
> daAdendums.Fill(dsAdendums) 'it don't works the dataset is empty
> drData = daAdendums.SelectCommand.ExecuteReader 'it works without a problem
>
> Can someone help me?? Thanks