Saving Checked Items in CheckedListBox

[shomaipider]

Hi!

How can i use multiple items in my stored procedure?
For example I checked 5 items in my CheckedListBox and iwant to use the ID's of the checked items to filter my record.


This is my code:

Dim strFilterGroup as String
Dim o As Object

For Each o In frm.chkListBoxEmployee.CheckedItems
strFilterGroup = "EmployeeID = '" & o.GetKey & "'"
Next

For Each drow In dtSrc.Select(strFilterGroup)
Dim drowNew As dsDataForExport.tblAttendanceRow

drowNew = dsToDownload.tblAttendance.NewRow()
drowNew.EmployeeID = drow("EmployeeID")
drowNew.StartOfPeriod = drow("StartOfPeriod")
drowNew.EndOfPeriod = drow("EndOfPeriod")
drowNew.TimeKeeperID = drow("TimeKeeperID")
dsToDownload.tblAttendance.Rows.Add(drowNew)
Next

in my dtSrc.Select i want to pass multiple id's there. How can i possibly do that?
thanks!

[jmcilhinney]

Follow the "SQL IN Clause with Parameters" link in my signature.

My code uses a DataAdapter, which I recommend you do too. If you really want to use a TableAdapter then I guess you can create an instance at run time and then set its SelectCommand.CommandText property, although I've never actually tried that.