Loading

Pass GridView Rows to SQL Database in one postback.

sankar nandakumaran

Hi....

I am using 3 tier architecture i want a fucntion to pass grdiview rows to Data access layer and save it to a table in SQL Server 2005 Express edition.
Can anyone give an idea to save each row without opening connection at each time. Here my problem is if i have 500 rows , 500 times it is opening connection in Data access layer........

Thanks and Regards
Sankar
[email protected]

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

Naresh Avari14y ago
Accepted answer
Hi Sankar,

I think this will help you to get some idea to pass gridView rows in xml format to your dataaccess layer...

http://weblogs.asp.net/manojkdotnet/archive/2010/01/24/bulk-update-using-gridview-and-sql-server-xml.aspx
sankar nandakumaran14y ago
Thanks naresh kumar for the nice solution it worked well for me . Thanks a lot Sankar