Page 1 of 1
Multiple Fill Method!!
Posted: Sun 20 Jan 2008 06:11
by ahijazi
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.
Posted: Mon 21 Jan 2008 10:07
by Alexey.mdr
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.
Posted: Tue 22 Jan 2008 06:32
by ahijazi
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.
Posted: Tue 22 Jan 2008 12:57
by Alexey.mdr
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.