Tag Archives: sqldatasource

Creating and Using TextBox in Rows Like An Array To Update Multiple Records At Once In Asp.Net

Updating multiple data at multiple rows in table is very often process on web application. Especially on interal / private system.

We have to make a grid like excel to do that. User inputs their data into multiple textboxes in rows / cells then clicks submit button to update those data at once.

Asp.Net server input control has many ways to access list of textboxes. Not only using array like asp classic do but we can do it using repeater / listview / gridview / table control as a grid creator and use FindControl method to access control inside grid including textboxes.

I have an example to update email of many customers so that when submit button is clicked then related email textboxes text will be stored on database.

I use VS 2010 and my local SQL Express 2005 with Northwind sample database to make this example.
Continue reading