Problems with Dataset

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Back
Top