Bulk insert with gridview using C# asp.net

Question

I'm using checkbox to select the rows in the gridview. How do I insert the muliple selected rows into the table opening the connection for only one time.

Why not use a for / foreach? You could use LINQ's "Where" clause, but it does a for loop in the background as well. — KBoek
– KBoek, Commented Dec 9, 2010 at 7:53

cjk · Accepted Answer · 2010-12-09 08:32:16Z

3

When you postback, read all the checked rows and put the data into a DataTable. You can then use a SqlBulkCopy object to push that DataTable into your database table.

answered Dec 9, 2010 at 8:32

cjk

46.6k9 gold badges83 silver badges113 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

osmirnov · Accepted Answer · 2010-12-09 07:59:18Z

0

Using JS to write into hidden field when user (un)checks a checkbox or to perform ajax call to server with id checked row.

answered Dec 9, 2010 at 7:59

osmirnov

1

Collectives™ on Stack Overflow

Bulk insert with gridview using C# asp.net

2 Answers 2

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related