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

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

[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

--
I hope this helps,
Steve C. Orr, MCSD, MVP
http://SteveOrr.net

"Andy Sutorius via DotNetMonster.c om" <fo***@nospam.D otNetMonster.co m> wrote
in message news:77******** *************** *******@DotNetM onster.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