Pass GridView Rows to SQL Database in one postback.

Question

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 
[e-mail]

Answer 1

Can any one could solve this problem, if yes plz help me to solve it.

Answer 2

hai Sanjay Kumar,

Thanks for your valuable reply, Actually what iam trying to implement is to make a repeater user control that can generate dynamic columns , that is if i use that repeater in a web form with 3 columns  i must be able to use that repeater control in the next web form for more than or less than 3 columns , so the problem is i need to bind that data with out using source code, that is "Eval" method can only add one data from a particular table only, i need to generalize that part and need to made that part data binding in general, so can i bind data to a repeater without source code by using only code behind.

Please pardon me if there is any confusions, ask me for more clarifications to my idea.

Answer 3

Hi

try this

http://www.c-sharpcorner.com/UploadFile/47548d/twitter-bootstrap-and-repeater-control-in-Asp-Net/