Reading values from multiple "similar" controls

[Bijoy Naick]

I have a form with mutiple text fields, all of similar nature.. for
example:

userName1, location1
userName2, location2
..
..
..
userName10, location10

all are text fields. while reading the input and saving to a database,
I'd like to be able to read all of them in a single loop and issue the
appropriate SQL commands. In ASP 3.0 I can do the following:

for i = 1 to 10
sql = "INSERT into TABLE VALUES ('" & Request.Form("userName" & count)
& "','" & Request.Form("location" & count) & "')"
execute sql stmt
next

How would i go about doing this in ASP.NET? I am not using the Request
object. I am using an event trigger (button clicked) to gather the info
and save to a database.

Bijoy

 

[Peter O'Reilly]

for i = 1 to 10

sql = "INSERT into TABLE VALUES ('" & Request.Form("userName" & count)
& "','" & Request.Form("location" & count) & "')"
execute sql stmt
next

Your classic ASP implementation will work for ASP.NET. (Most likely you
will need to modify the syntax a bit)