----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: aamirOnline Message 2 in Discussion Hi Jignesh I think your design is not correct. Instead of definig connection in the control itself your controls should have DataSource like property. Where you will assign the data from outside the controls rather then fetching data from withing themselves. this is the way that microsoft implements with their data-aware controls like datgrid, datalist etc... And one more thing if you just want to fetch data for read only purpose or just for displaying purpose you must use datareader then dataadapter and datasets because datareader is much much faster. after implementing such kind of architecuture you will only required one connection per page and you will not face connection locking problem also.... meaning 5 times less over head if you have 5 controls hope you got the answer regards m aamir maniar ----------------------------------------------------------- To stop getting this e-mail, or change how often it arrives, go to your E-mail Settings. http://groups.msn.com/mumbaiusergroup/_emailsettings.msnw Need help? If you've forgotten your password, please go to Passport Member Services. http://groups.msn.com/_passportredir.msnw?ppmprop=help For other questions or feedback, go to our Contact Us page. http://groups.msn.com/contact If you do not want to receive future e-mail from this MSN group, or if you received this message by mistake, please click the "Remove" link below. On the pre-addressed e-mail message that opens, simply click "Send". Your e-mail address will be deleted from this group's mailing list. mailto:[EMAIL PROTECTED]
