----------------------------------------------------------- New Message on MumbaiUserGroup
----------------------------------------------------------- From: Jigs Message 1 in Discussion Hi Umesh,. In addition to what Parvez mentioned. Select Project Add Class and create a public shared function. Public Class GlobalSharedFunctions Public Shared Function GetConnection() As SqlClient.SqlConnection End Function End Class Then from your code you can call it as GlobalSharedFunctions.GetConnection(). but then where you are opening connection and closing connection is you have to take care. Ideally it should be like this Private Shared Function GetConnection() As SqlClient.SqlConnection End Function Public Shared Sub InsertRecord() Dim x As SqlClient.SqlConnection x = GetConnection() 'Do you work here x.Close() End Sub This is just to give you some idea, you need to find your way to fit as per your application needs. Regards, Jignesh Desai http://www.dotnetJiNi.com ----------------------------------------------------------- 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]
