Creating many objects of same class...

Suma M

Hi,

I have 2 overloaded methods given below
public DataSet LoadDataSet(string SPNAME,string FieldID)
{
sqlcommand cmd=new sqlcommand;
}
============================================
public DataSet LoadDataSet(string SPNAME,string FieldID,string 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?

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Vulpes13y ago
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 M13y ago
Yes exactly but how will this work if many data controls are required to be loaded on page load event
Vulpes13y ago
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.