About Boster Sibande Expertise I can answer questions in the following areas: ASP.Net, VB.Net, C#.Net, Microsoft Access and SQL Server. These are the technologies I use in my day-to-day work. As such, I am very confident and happy to assist
Experience I have two years experience with ASP.Net
Organizations UNDP
Education/Credentials Currently studying MSc. in IT
Expert: Boster Sibande Date: 6/22/2006 Subject: Help need in text populated
Question I am wondering if you would help me with this?
I am using _vbscript or _javascript with asp to doing web application.
In the form(TextBlur.asp), first time you have to put PatientNo and patient last and first name, mid name information by type. After push submit button, these four fields data send to database table named tblTextBlur.
Ever since then when you come to filling this form, you want after you typed PatientNo, the rest three fields will automatical populated.
How can you complete it?
Appreciated!
tblTextBlur
UniqueID PatientNo LastName FirstName MidName
1 C21192-01 Martin Charles H.
10 21201-01 Tolbert Jimmie L.
2 C21192-01 Martin Charles H.
3 21167-01 Stepherson Ronald
4 C21194-01 Richardson Keith B.
5 21183-01 Dupra Ann S.
6 21163-02 Lindemuth Randall S.
7 21184-01 Sobelson Glenn M.
8 C21180-01 Mitchell Polly M.
9 C21187-01 Joseph Etzer
in the tblTextBlur, UniqueID is auto number, the rest are text.
Answer Basically, the idea would be: Whenever someone submits data on the form, you have to check the database if the record exists. If it exists, then the record should be displayed, Otherwise, the record has to be saved as a new record.
This code can be implemented in the event that the textbox loses focus in ASP.net while in classic ASP, you can only implement it on submit/post.
