Hi,
If I have a very big view in database, it covers 15 tables, each table has
1000 columns.
When I issue select * from view, the database will give error -- too many
columns.
Can I use a DataAdapter fill DataTable couple times? For example, I only
read 5000 columns from the view each time and I read 3 times. It has an id
column as primary key to help locate the row.
How to write a DataAdapter to fill DataTable 3 times? What is the most
efficient way to do this?
Thanks a lot!
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.
Ryan Liu
Shanghai Fengpu Software Co. Ltd
Shanghai , China
http://www.PowerCATI.com Powerful CATI!
http://www.fpsoft.net.cn
~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.~.