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