Multiple Fill Method!!

Multiple Fill Method!!

Postby 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.
ahijazi
 
Posts: 44
Joined: Mon 01 Oct 2007 11:13

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24

Postby 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.
ahijazi
 
Posts: 44
Joined: Mon 01 Oct 2007 11:13

Postby 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.
Alexey.mdr
 
Posts: 729
Joined: Thu 13 Dec 2007 10:24


Return to dotConnect for Oracle