Hi I have to insert multiple rows at the same time,with each row having 4 columns.
It is a sibling table
if there are 4 siblings ,4 rows need to be inserted to database(each row with column childname,siblingname,siblinggrade,siblingschool)
User has to input the sibling Information,which is saved to Database
Here childname will be same for 4 rows with other row entries different.How to do this in VB.net?
Loading
CrishPosted May 16, 2010, 9:23 AM
yes you can insert multiple rows at a time in database using string.
Make string for that like "fld1,fld2,fld3,fld4 | fld1,fld2,fld3,fld4 | fld1,fld2,fld3,fld4 | fld1,fld2,fld3,fld4" and pass it to stored procedure and split over there and then insert all one by one
Don't forget to Mark Do you like this Answer that solved your problem!