How to convert vb.net script to sql server script?

See more:

VB

SQL-Server-2008R2

I have this script in vb.net:

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

The script inserts record based on how many record I selected in my data view grid which is in multiple selection mode. But for some reason I need to do the scrip in inserting record in sql server. Thanks!

What I have tried:

I tried this code:

INSERT INTO tblAttendanceDetail (AttendanceID,ConstituentIdNo)
       Select @AttendanceID,@ConstituentIdNo where @AttendanceID=Arguments.SelectedValues and @ConstituentIdNo=Arguments.SelectedValues

but it throws an error.