How to hand write OleDbAdapter?

[Karl]

Hi all,
I know I can use Adapter Wizard in forms to create adapter. But, in order to
make the code better structured, I want to create a dataset and some
OleDbadapters in a class file. So I cannot use wizard. However, the wizard
generated adapter code is so long, I am not sure how to hand code it in the
class file. So here is the question:

What is the common practice to write a adapter code in a class file (not a
form!)? Do I have to create it in a form and copy and paste or is there a
simpler way to hand write a OleDbAdapter (fully functional, including
select, update, insert, delete)?

thanks,

Kai