Error: System.Data.OleDb.OleDbException: Invalid column name 'dnn:UserID'.
at Microsoft.VisualBasic.CompilerServices.LateBinding.LateGet(Object o, Type objType, String name, Object[] args, String[] paramnames, Boolean[] CopyBack)
at EfficionConsulting.AdvancedDataGrid.AdvancedDataGrid.BindData()
CommandText: select
case
when ((aspm.createdate+1)>getdate()) then
'New user account "'+u.username+'"
created on '+LEFT(CONVERT(varchar(30),
DATEADD(day, DATEDIFF(day, 0, aspm.createdate), 0), 121), 10)+
'.
NOTE: Creating an account does NOT automatically
enroll you for an event.
If you wish to enroll for an event you will need to navigate
back to the event page and complete the enrollment process.
You can verify your event enrollment status
by reviewing the box below with the blue heading
"You have enrolled for the following event(s)"
'
else 'You are logged in.
'
end
as [Account Status]
from aspnet_Membership aspm inner join
aspnet_users aspu on aspu.userid = aspm.userid inner join
users u on u.username = aspu.username
--where u.userid = 8977
where u.userid = [dnn:UserID]