SQL Server 2005 Connection Crashes With Multiple User Clicking Same Link.

Hi,
I just developed a ASP.NET website with SQL Server 2005 as database. I am having connection crash problem when multiple user click on same link to fetch data from the database. If users click on different links or there is few seconds of time gap between the data access, then it works fine. But the connections crash problem only occurs when 2 or more users click same link at same time.

I am using the following kind of Datalayers to access the data from database:


public static ContentInformation GetContentForUpdate(int ContentId)

{

ContentInformation result = new ContentInformation(); ;

SqlCommand command = new SqlCommand();

command.CommandType = CommandType.StoredProcedure;

command.Connection = Connection;

command.CommandText = "Content_GetContentForUpdate1";

SqlParameter parameter = new SqlParameter("@ContentId", SqlDbType.Int);

parameter.Direction = ParameterDirection.Input;

parameter.Value = ContentId;

command.Parameters.Add(parameter);

try

{

command.Connection.Open();

SqlDataReader reader = command.ExecuteReader(CommandBehavior.SingleRow);



if (reader.Read())

{

// read the data
}

reader.Close();

}

catch (SqlException ex)

{

Trace.TraceError(ex.Message);

throw ex;

}

finally

{

command.Connection.Close();

}

return result;

}


I would be really grateful if someone can help me out with this problem. Waiting for the soonest reply. Thanks.