scope of static property

[Amit]

I'm supporting an asp dotnet application. There is a static property
in the code as below. Can anyone tell me in multiuser enviornment,
this propery will return a different dataset each time it is accessed
by different users?

public static DataSet GetRatings(string ratingString)
{
// Create a new dataset
DataSet dsReturn = new DataSet();

// Open a connection
SqlConnection _connection = new
SqlConnection(GlobalConstant.DBConnection);
_connection.Open();

// Create an adapter and populate the dataset
SqlDataAdapter sqlAdapter = new
SqlDataAdapter("spGetRatingDropdown", _connection);
sqlAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlAdapter.SelectCommand.Parameters.Add("@sRatingC ode",
ratingString);
sqlAdapter.Fill(dsReturn,"SearchResult");
sqlAdapter.Dispose();

_connection.Close();

return dsReturn;

}

[Luke Venediger]

Hi,

Yes, each caller will get a new instance of the dataset. However, if your
dataset property was a static member, then each caller would get the same
instance of the dataset.

Regards,
Luke Venediger
http://blogdotnet.blogspot.net

"Amit" <am**********@rediffmail.com> wrote in message
news:ae**************************@posting.google.c om...

I'm supporting an asp dotnet application. There is a static property
in the code as below. Can anyone tell me in multiuser enviornment,
this propery will return a different dataset each time it is accessed
by different users?

public static DataSet GetRatings(string ratingString)
{
// Create a new dataset
DataSet dsReturn = new DataSet();

// Open a connection
SqlConnection _connection = new
SqlConnection(GlobalConstant.DBConnection);
_connection.Open();

// Create an adapter and populate the dataset
SqlDataAdapter sqlAdapter = new
SqlDataAdapter("spGetRatingDropdown", _connection);
sqlAdapter.SelectCommand.CommandType = CommandType.StoredProcedure;
sqlAdapter.SelectCommand.Parameters.Add("@sRatingC ode",
ratingString);
sqlAdapter.Fill(dsReturn,"SearchResult");
sqlAdapter.Dispose();

_connection.Close();

return dsReturn;

}