Insert/Update values in a gridview
<p>What would be the best way to Insert/Update the values in a Grid view
on clicking a save button placed somewhere.
in the page .
I dont want that to be done like Using Insert Item template and EditItemTemplate.</p>

<p><b>My thought:</b>
"Loop through each row of Gridview and 
connecting to database and 
execute the command
and close the connection."</p>

<p>Or is there any way so that we can connect to database only once and perform 
Insert/Update operations.</p>

<p>any suggestions would be appreciated..</p>

<p>Thanks in advance. </p>
