Mutiple access to same function returning error.

See more:

DataReader

Hi all,

We have a problem with multiple user access. When two users clicking same button at same time, One is able to get data and other getting an error 'Invalid attempt to read when no data is present'.

Inner exception :System.InvalidOperationException: Invalid attempt to read when no data is present. at getData(int id)at PopulatePage() at Page_Load(Object sender, EventArgs e) at System.Web.Util.CalliHelper.EventArgFunctionCaller(IntPtr fp, Object o, Object t, EventArgs e) at System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e) at System.Web.UI.Control.OnLoad(EventArgs e) at System.Web.UI.Control.LoadRecursive() at System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)

Please find function getData below.

private static SqlConnection _connection;
    public static SqlConnection Connection
    {
        get
        {
            if (_connection == null)
            {
                SecurityClass Secure = new SecurityClass();
                _connection = Secure.PublicConnection();
            }
            return _connection;
        }
    }

public static object getData(int id)
    {
        
        using (SqlCommand cmd = new SqlCommand("spGetdata", Connection))
        {
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.AddWithValue("@ID", id);

            try
            {
                if (Connection.State != ConnectionState.Open)
                {
                    Connection.Open();
                }
                using (SqlDataReader sqlReader = cmd.ExecuteReader())
                {
                    sqlReader.Read(); 
                }
            }
            catch (Exception ex)
            {
                throw ex;
            }
            finally
            {
                if (Connection.State == ConnectionState.Open)
                {
                    Connection.Close();
                }
            }
        }
        return object;
    }

Please suggest a solution to this issue.
Thanks in advance.