public class SqlLoader
{
    public SqlLoader()
	{
		m_GetRowCommand = new SqlCommand("dbo.LoadUser");
		m_GetRowCommand.CommandType = CommandType.StoredProcedure;
		m_GetRowCommand.Parameters.Add("Id", SqlDbType.Int);
	}

	protected SqlConnection Connection
	{
		get
		{
            return new SqlConnection(ConnectionString);
		}
	}

	protected SqlCommand m_GetRowCommand;

	public SqlCommand RowCommand
	{
		get { return m_GetRowCommand; }
	}

    public override void LoadObject(DataObject obj, int ID)
    {
        SqlCommand scmd = RowCommand;
        lock (scmd)
        {
            using (scmd.Connection = Connection)
            {
                scmd.Parameters[0].Value = ID;
                if ((scmd.Connection.State & System.Data.ConnectionState.Open) == 0)
                    scmd.Connection.Open();
                using (SqlDataReader rd = scmd.ExecuteReader())
                {
                    if (!rd.Read())
                        throw new Exception();
                    try
                    {
                        obj.Id = (int)rd.GetValue(0);
                        obj.Login = (string)rd.GetValue(1);
                        obj.Email = (string)rd.GetValue(2);
                        obj.RegDate = (DateTime)rd.GetValue(3);
                    }
                    catch (IndexOutOfRangeException)
                    {
                        // Вот тут иногда вылазит ошибка
                    }
                }
            }
        }
    }
}