For Each id As Object In Arguments.SelectedValues Using sql As New SqlProcedure("spInsertAttendanceDetail") sql.AddParameter("@ConstituentIdNo", constituentIdNo) sql.AddParameter("@AttendanceID", attendanceID) sql.ExecuteNonQuery() End Using Next
INSERT INTO tblAttendanceDetail (AttendanceID,ConstituentIdNo) Select @AttendanceID,@ConstituentIdNo where @AttendanceID=Arguments.SelectedValues and @ConstituentIdNo=Arguments.SelectedValues
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)