hi guys ,
i have a client table, genheader table ,gendetails table
i made a class for each table which has open and close the connecion inside it

in my form, combobox is binded to cleint table,
other textbox and dtpicker is binded to genheader class and datagrid into gendetails class, for each class that i used im opening and closing it ,my question is which is better in performance and code reusability the three class which has its own open/close connection or i will combine all these and to have one class only with 1 open/close connection?
m designing acctng system in ntier using vb.net
tnx in advance

I think it is better ou use 1 connection to get data, but it is always a trade-off. Also think of the class as a relation so you can have better code reusability and try to model the relation.



It is not how much we do,
but how much love we put in the doing.

-Mother Theresa