Hi, I was wondering if it was possible to mass upload records into a datagrid view either by copy paste, or by inserting them into a multiline textbox then coding them to insert into it.
Any bulk inserting is adding record one by one. Just look like you can input multiple record at one time and click submit button once and all records inserted to db. Actually, system do inserting one by one from looping the records.
So you can make a table with multiple rows with multiple input controls and a button. When you click the button, read data row by row and do inserting one by one.
ohhaibamf
Member
1 Points
12 Posts
Bulk Add Items into Datagrid View
Jun 13, 2012 07:35 PM|LINK
Hi, I was wondering if it was possible to mass upload records into a datagrid view either by copy paste, or by inserting them into a multiline textbox then coding them to insert into it.
thanks,
ohhaibamf
Qin Dian Tan...
All-Star
113532 Points
12480 Posts
Microsoft
Re: Bulk Add Items into Datagrid View
Jun 15, 2012 06:50 AM|LINK
Hi,
Any bulk inserting is adding record one by one. Just look like you can input multiple record at one time and click submit button once and all records inserted to db. Actually, system do inserting one by one from looping the records.
So you can make a table with multiple rows with multiple input controls and a button. When you click the button, read data row by row and do inserting one by one.
Thanks,
If you have any feedback about my replies, please contactmsdnmg@microsoft.com.
Microsoft One Code Framework