Multiple Fill Method!!

ahijazi · Post by **ahijazi** » Sun 20 Jan 2008 06:11

Dear CoreLab Team;

I try to create datatable with more than one fill method, it didn't work ??, when try to access the other fill methods (FillbyX for example) it did not apear in the datatable. ????

IDE: VS 2005
Package: OraDirect 4.35
Wizared: Data -> Add New Data Source

Best Regards,
Ahmed Hijazi. P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Mon 21 Jan 2008 10:07

Data -> Add New Data Source creates standard DataSet.
You cannot use OraDirect features with standard DataSet.
Use Tools -> Oracle -> DataSet Wizard.
This wizard will use OraDirect provider-specific code generator and create typed CoreLab.Oracle.DataSet.

ahijazi · Post by **ahijazi** » Tue 22 Jan 2008 06:32

Dear CoreLab Team;
- My Quastion is about how to create one datatable with more than fill method, either by your wizared or the standard one with OraDirect provider

- by using regular MSDataSetGenerator i can do it so well, but OracleDataSetGenerator do not ??

- i need to know how to do this issue by using your wizared if it possible.

Best Regards,

Ahmed Hijazi P. Eng.

Alexey.mdr · Post by **Alexey.mdr** » Tue 22 Jan 2008 12:57

If you want to fill an OraDirect .NET typed DataSet with other than standard “Fill()” method you need to create an OracleDataAdapter instance.
So your steps are:
- run Tools -> Oracle -> DataSet Wizard...
- drag&drop OracleDataAdapter
- specify the SELECT statement of the adapter
- fill your DataSet with this adapter.