need to create sql dynamically

[Andy Sutorius via DotNetMonster.com]

Hi,

I remember in classic ASP when you had a webpage with a large number of
textboxes and you needed to perform an update sql statement you could loop
through all of the fields and dynamically create a sql statement. I have a
webform with over 200 textboxes and I need to perform a sql update. Is
there a way to do this in ASP.NET?

Thanks,

Andy

 

[Brock Allen]

You can still loop through the Request.Forms collection. I'd arge against
this, given that this will probabaly leave you open to a SQL injection attack.

-Brock
DevelopMentor
http://staff.develop.com/ballen

 

[Steve C. Orr [MVP, MCSD]]

Here is a function that allows you to loop through all the textboxes in a
..NET form:
http://SteveOrr.net/faq/ControlTreeRecursion.aspx