public static int UpdateLastLogin(string userName, string sessionID)
{
if (userName == null)
return 0;
Database db = OmegaLoveSqlDataHelper.CreateConnection(ConnnectionString);
DbCommand dbCommand = db.GetStoredProcCommand("prc_Profile_Update_LastLogin");
SqlParameter parm1 = new SqlParameter("@UserName", SqlDbType.NVarChar);
parm1.Direction = ParameterDirection.Input;
parm1.Value = userName;
parm1.Size = 50;
dbCommand.Parameters.Add(parm1);
SqlParameter parm2 = new SqlParameter("@SessionID", SqlDbType.NVarChar);
parm2.Direction = ParameterDirection.Input;
parm2.Value = sessionID;
parm2.Size = 32;
dbCommand.Parameters.Add(parm2);
int retValue = db.Ex ...
Go to the complete details ...