Jan 15, 2014 05:07 AM|PatriceSc|LINK
I don't see any of your screenshots. Not sure if blocked on my side or what...
Ah, you don't run the UPDATE statement. You assign a SQL Statement to a sqlStr string but then you execute cmd which is still a SELECT statement... Waht if you insert a cmd=new OleDbCommand(strSql,cnn) to recreate the cmd object for your new SQL statement...
That is :
Dim online As String = "online"
sqlStr = "UPDATE Credential SET [LoginFlag]='" + online + "', [SessionID]='" + SID + "' WHERE [Username]='" + username + "'"
cmd=new OleDbCommand(strSql,cnn) ' Added