|
Hi Jackie,
Are you talking about database table, if yes then next time when user logs in that you can clear that table.
Regards,
S Kumar
|
|
|
|
|
Thanks Kumar,
Yes, I was talking about the Sql Database, and i store a list of product attributes in a seperate table, but this table is for users that haven't logged in yet. (i use this table just like use Cookies, but i don't use Cookies to store those information).
I was using "Application("ActiveUser")" to give each user that visits our website a sessionID, and then store something they choose in this seperate table, what i am doing is trying to delete all records belongs to a sessionID once the user leaves our website.
Please Help, thanks
Jackie Ding
|
|
|
|
|
Hi Jackie,
Your application might be like online shopping and users like Guest user.
If yo can keep track of signoff or logout then you can put that part of code in this code.
You can write code in session end of global.asax.
Regards,
S Kumar
|
|
|
|
|
Hi Kumar,
You are right, I am dong an online shoppingcart project.
I was trying to write code in session-end, but i really didn't how to write it. So could you please help??
i am trying to keep the session id increase by 1 each time, so that each user, even he hasn't login yet, can be seperated from other users, but the annoying thing is the session just repeat it again and again. For example, i run the website, and put something into a shoppingcart, and then leave without paying the money, and i do it for several times, but then the session number just start from 1 again, so the shopping cart doesn't only include current user's thing, but also the previous one's thing.
Now i am really really sad about it......, but still have no idea to fix it.
Have you got a MSN, I really need your help now, cause i am really in a hurry.
Please, Thanks
Jackie Ding
|
|
|
|
|
Try to write a subject that means something. What you have now is totally irrelevant to the question.
You don't have to create a session id yourself, there already is one. Use Session.SessionId. That will not start over when your application starts over.
You can put code to remove the data in the Session_End method in global.asax, that will take care of most sessions. You can not rely on it to remove the data from all sessions, though. There are some situations where that method might not be called. If you don't have too much traffic, you could take care of those manually, though.
---
b { font-weight: normal; }
|
|
|
|
|
Thanks Guffa,
I am trying what you said, but it doesn't work yet.
I set the datatype of the session.sessionID as nvarchar(MAX), but i am not sure whether i am right or wrong. I can input the sessionID into my database on the design page, but when i go to the shopping cart page, there is a big problem, says "Input string was not in a correct format", and "Source error: An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below".
So what can i do now? change the sessionID datatype to the uniqueidentifier?? but i think i did try, but failed as well.
Please help, thanks
Happy New Zealand Labour's day!!;)
-- modified at 19:00 Sunday 22nd October, 2006
Jackie Ding
|
|
|
|
|
I have several controls in a flow-layout panel which can be scrolled vertically. I dont want to scroll the flow-layout panel using mouse but it should scroll down when i click a button. How to do that?
Any hint?
.X.
|
|
|
|
|
My application used RichTextBox, I want it notify the color like VB.NET.
Example
If user use keyword Private it became blue
Thanks
................
|
|
|
|
|
All you have to do is search the articles. Second link down[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I want to use command to open as below
Read Mail
New message
Send Page
Thanks
................
|
|
|
|
|
Again - you've left out a LOT of detail that we need to answer this "question"...
Open what? Outlook? Outlook Express? Or are you trying to get at an SMTP/POP server in your own code? ...
Details man!! Details!! The quality of answer you get is directly tied to the quality of the question!
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
I want to open OutLook express(New Message, Inbox, Send page)
Thanks
................
|
|
|
|
|
I don't know how to do this
Add(text As String, image As System.Drawing.Image, OnClick As System.EventHandler) As System.Windows.Forms.TollStripItem
Thanks
-- modified at 22:32 Saturday 21st October, 2006
-- modified at 22:36 Saturday 21st October, 2006
................
|
|
|
|
|
This isn't a question. You want to do what with this?
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
i want to make a delay function in microseconds using vb 6 i am really stucked with that need it really quick .plz help me.
.o0|EvolvingLogics|0o.
|
|
|
|
|
One method would be to use the API function Sleep. In a module class, make a declaration as such:
Public Declare Sub Sleep Lib "kernel32" Alias "Sleep" (ByVal dwMilliseconds As Long)
If it is Public, you will be able to call the function from anywhere else in the program. When you want to use the function, just call Sleep with the number of milliseconds you would like the delay. The link below is the MSDN description of the function. It mentions alternative methods if needed.
http://msdn.microsoft.com/library/default.asp?url=/library/en-us/dllproc/base/sleep.asp
|
|
|
|
|
He's looking for something with a much higher resolution than 1 millisecond.
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
The only timer that has that kind of resolution is QueryPerformanceCounter[^].
Dave Kreskowiak
Microsoft MVP - Visual Basic
|
|
|
|
|
You know in games you have a console like where you can run commands and things like "echo test" and the console promptly replies "test", how would i go about coding this in vb.net. i have no idea where to start, and its fundamental to this game. any ideas would be appreciated
Thanks, Terence
|
|
|
|
|
Hello All,
I had wrote a small piece of code in Visual basic 6.0 and MS Access 2000.
In Access I have 1 table tbl_expire it includes from, to and amount columns.
from - 01/09/1993 to - 31/12/1998 - Amount - 300 - date format is dd/mm/yyyy
from - 01/01/1999 to - 14/01/2000 - Amount - 275
from - 15/01/2000 to - 28/02/2001 - Amount - 250
from - 01/03/2001 to - 28/02/2002 - Amount - 225
If user enters like - 01/05/2000 then I should get Amount 250, but I am getting 275.
SSql = "select tbl_expire.from as from_dt, to,amount from tbl_expire where '" & Format(TxtDate, "dd/mm/yyyy") & "' >= format(from, 'dd/mm/yyyy') "
SSql = SSql & " and '" & Format(TxtDate, "dd/mm/yyyy") & "' <= format(to, 'dd/mm/yyyy') order by from asc"
Set rs = db.OpenRecordset(SSql, dbOpenDynaset)
If Not rs.EOF Then
TxtFinAmt.Text = Format(rs!maturity_amt, "0.00")
End If
rs.Close
Regards,
S Kumar
|
|
|
|
|
That is because you are comparing the dates as strings. If you examine the result that you get, you see that you actually get both 275 and 225.
If you want the comparison to work, there are two things that you can do. You can compare the dates as dates, or you can use a date format like ISO 8601, i.e. yyyy-mm-dd, that is actually comparable in string format.
---
b { font-weight: normal; }
|
|
|
|
|
Hello Guffa,
Thanks a lot.
ISO-8601 -- yyyy-mm-dd works for me.
Regards,
S Kumar
|
|
|
|
|
i am trying to make an app in vb about services but i can't find the type SC_HANDLE's structure in any MSDN documentation.
where can i find it?
Thanks in advance
|
|
|
|
|
FULL JUSTIFICATION IN RICH TEXT BOX CONTROL IN VB.NET
I am developing a small application for document movement by using RICH TEXT BOX in VB.NET. Thix box is meant for inputting by user any text. The text can be formatted in almost all maner, like RIGHT, CENTER and LEFT ALIGNED. However, I want the text to be FULLY JUSTIFIED (BOTH SIDE) too.
Can anyone suggest me how to do it ? Please respond as it is very urgent, I will be grateful.
T. ALEX JOHN
BHOPAL (INDIA)
|
|
|
|
|
Help me!
I have a database is Users.mdb(userName and UserPass...) and put on a PC on LAN (ex: PC1).
Please show me how to code check UserName and Password then response to my App (put on PC2) for login and get data form other table.
-------------------------
adnvn
|
|
|
|