For Each item As CheckedListBox In CheckedListBox1.Items If item.SelectedItems.ToString Then 'Insert code for inserting data to SQL cmd.CommandText = "insert into Module_Control_tbl (empl_ID,Module_ID) Values('" & ComboBox1.SelectedValue & "','" & CheckedListBox1.SelectedValue & "')" ComboBox1.Focus() cmd.Connection = Cn cmd.ExecuteNonQuery() MsgBox("Assign Module Successfully to Employee") Form7_Load(sender, e) End If Next
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)