A
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("@sRatingCode",
ratingString);
sqlAdapter.Fill(dsReturn,"SearchResult");
sqlAdapter.Dispose();
_connection.Close();
return dsReturn;
}
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("@sRatingCode",
ratingString);
sqlAdapter.Fill(dsReturn,"SearchResult");
sqlAdapter.Dispose();
_connection.Close();
return dsReturn;
}