Creating many objects of same class...

Question

Hi I have 2 overloaded methods given below public DataSet LoadDataSet(string SPNAMEstring FieldID) { sqlcommand cmd=new sqlcommand; } ============================================ public DataSet LoadDataSet(string SPNAMEstring FieldIDstring FieldName) { sqlcommand cmd=new sqlcommand; } Now instead of creating 2 objects of the same class can i declare a sqlcommand object and use it in any number of methods.. i want to put this sqlcommand object in a global class and use it.. Is this correct?

Vulpes · Answer

If it's an ASP.NET application then you can add a global class to the App_Code folder. That should then be accessible throughout the application including in the Page_Load eventhandler.

Suma M · Answer

Yes exactly but how will this work if many data controls are required to be loaded on page load event

Vulpes · Answer

Yes you can. If you're going to put it in a global class I'd make it static so that it can be accessed throughout the rest of the application without the need for an object reference. class Global { private static SqlCommand cmd = new SqlCommand(); public static SqlCommand Cmd { get { return cmd; }} } You can then access with Global.Cmd.