Transfer Recordset from one table to another tableu using SQL 2000 and VB.net
Posted on 2009-07-15
I have 2 views based on 3 tables.
Vparticipants (View) has two fields in each row
EventID and ParticipantID
the VParticipants may have 1-20 records in the dataset
vAttendance (view) has EventId and ParticpantID in each row.
I have to transfer the vparticipants recordset with each EventID and ParticpantID
to the EventID and ParticipantID fields in the Attendance Table using the vAttendance(view)
I would like to do this action on a button click using VB.net and SQL.
I am still learning about stored procedures so if there is a way I can do this in VB.net
and inline SQL code on the button click . That would speed it up for me.
I am using asp.net VB.net and SQL server 2000