Dbe

SELECT ForeignID, ForeignDisplay FROM ForeignTable;

using (db){ using (da){

using (dr) { while (dr.Read()) { CheckBox cb = new Checkbox; //cb.ID = dr.GetString(0); check if they the same group cb.Text = dr.GetString(0); } dr.Close(); }

} }

/**/

int iNewID = SELECT @@IDENTITY;

/**/ foreach checked { INSERT INTO SelectTable (TableID, ForeignID) VALUES (iNewID, iChecked); }