an example how to read all textboxes in form

Hi
can anyone find me something (link or example) how to read all names and values from all the textboxes of a page.
The user will get a list of items with a textbox where the user should type the amount or any other value.
I'll use something like the repeat region (dreamweaver) to make these rows from Sql server 2000.
After all values are set the user should click at the button "update all".


I dont prefer the datagrid because you have to (clickon) edit each time you want to edit one record.

Please show me the aspx example using VB.



thank you guys

 
bdsnvAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

mrichmonCommented:
All you need to do is name your textboxes using a numeric ending.

Such as:

Name1
Name2
Name3
Name4
etc..

Then in the code behind of the aspx page you have a loop that iterates over the textboxes appending the current index of the loop to the name of the textbox.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
bdsnvAuthor Commented:
mrichmon,
no problem naming the textboxes. I can put the id-field e.g. tbox1001,tbox1002 and so on.

can you show me the loop in vb?
Dim loopresult
Dim fieldID
Dim fieldValue

For...
   loopresult=loopresult & fieldID & "=" & fieldvalue";"

something simple like that.

 I can send this loopresult to sql server where i can update the records individualy with e.g.  triggers /procedures.
thnks
mrichmonCommented:
I am not a VB person....
castrumCommented:
I think you can use "recordcount"... for example your rs is myRS
first descbe your rs parameters like connection etc. then add
"myRecords=myRS.recordcount"(it returns an integer)

After that you can use For ... Next like that:

for x= 1 to myRecords
      loopresult=loopresult & fieldID & "=" & fieldvalue";"
      myRS.movenext ' step forward for next record
next


I hope this works
 
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Web Development Software

From novice to tech pro — start learning today.