New ASP-er

  • Thread starter Thread starter HotRod
  • Start date Start date
H

HotRod

Have a few questions that I was hoping someone wouldn't mind answering.

I am currently helping another fellow develop a basic ASP.net webpage so
that we can track some of our program information into either a SQL or
access database, for now we are using MS Access. OK what I'm wondering is

1) We have a list of registered parents and then all of the children that
correspond to each parent
-Is it reasonable to expect that when a parent starts entering their
Last name that there is an auto complete?
-Or once their last name is entered that the child boxes only has a list
of children registered to them?

We are trying to eliminate duplicate children names from being entered, such
as Bob, Bobby, Robert, Rob etc. (All the same kid)

Will using an auto complete or refreshing the dropdown list dramatically
effect the performance?

Can anyone give me a better way or faster way of breaking down the
information entered as you work your way through the sign-in form?
 
I have not seen this Autocomplete in any websites that I can rememeber.
I too have not implemented anything in this regard even for an Intranet
as the round trip would be expensive. There is a concept called Remote
Scripting. If you are comfortable with javascript then you can go ahead
and implement it. This is less expensive compared to a complete
postback, but the code is difficult to maintain and you will be
programming in JavaScript.

As for the Access database, I would recommend that you use SQL Server
MSDE edition and when you are ready to port your application, you can
always port it to SQL Server.

HTH

Trevor Benedict R
Microsoft Certified Solution Developer
 
Have a few questions that I was hoping someone wouldn't mind
answering.

I am currently helping another fellow develop a basic ASP.net webpage
so that we can track some of our program information into either a SQL
or access database, for now we are using MS Access. OK what I'm
wondering is

1) We have a list of registered parents and then all of the children
that correspond to each parent
-Is it reasonable to expect that when a parent starts entering
their
Last name that there is an auto complete?
Click to expand...

No, ASP.NET does not handle auto complete. AutoComplete is a function of
the web browser (Internet Explorer).

However, you could implement a autocomplete clone with Javascript
remoting (or client side callbacks). Check out:

http://www.google.com/webhp?complete=1&hl=en
-Or once their last name is entered that the child boxes only has
a list
of children registered to them?
Click to expand...

You can use a custom validator or validate you can populate the box on
postback.

BUT... how are you going to ensure that the person IS the right parent?
Couldn't it be possible that there are two parents named John Smith? Do
you have any other identifiable info that you could use to look up the
child's name?
 
Hi, comments below..

HotRod said:
Have a few questions that I was hoping someone wouldn't mind answering.

I am currently helping another fellow develop a basic ASP.net webpage so
that we can track some of our program information into either a SQL or
access database, for now we are using MS Access. OK what I'm wondering is
Click to expand...

- if this page is possibly going to be used by more than a few people
simultaneously, id strongly recommend using MSDE instead of Access (or SQL
if you have one).
1) We have a list of registered parents and then all of the children that
correspond to each parent
-Is it reasonable to expect that when a parent starts entering their
Last name that there is an auto complete?
-Or once their last name is entered that the child boxes only has a
list of children registered to them?
Click to expand...

- how is your form going to be used? Is the parent going to be entering
this info from their home PC, or is this form going to be used at a
public/shared PC? Are they entering their own parent info or just signing
in to view/add children? If theyre going to use this form once to enter
data, why bother with autocomplete?
- re: autocomplete is an IE, not ASP.NET, feature that can be enabled by
using "autocomplete=true" in the body tag of the page. But if this page is
being used from a home PC, itd make more sense to use a cookie to save the
parent's name between sessions. And if its on a shared/public machine, it
might be a bad idea to have an autocomplete history showing previous user's
names.
- once they entered their last name, thered need to be a postback from a
"search" button or something, so that the children are populated. Yup sure
this is reasonable.
We are trying to eliminate duplicate children names from being entered,
such as Bob, Bobby, Robert, Rob etc. (All the same kid)
Click to expand...

If a parent is entering their children's data, wouldnt it be safe to assume
they would know that Little Bobby and Robert are the same? Again, its hard
to tell without knowing what youre trying to do.
Will using an auto complete or refreshing the dropdown list dramatically
effect the performance?
Click to expand...

No, as long as you write your query reasonably well.
Can anyone give me a better way or faster way of breaking down the
information entered as you work your way through the sign-in form?
Click to expand...

Impossible to do without more information about what youre trying to do, and
who is using the site and why. Are you literally just talking about a
login/sign-in page?

HTH,
Premier JiangZemin, MCSD.NET
 
Back
Top