[rajathtc]

My code for insertion goes here please help. Can anybody tell what is wrong in this code only the first selected value is being inserted what can i do.

 For i As Integer = 0 To lstParticipant.SelectedItems.Count - 1

			  Try
		SQLstr = "INSERT INTO Training_Conducted (Date_of_Training, Training_Code,  Name_of_Facualty,	  
																		   Participant_Name) VALUES
('" & DateTimePicker.Text & "','" & cmbTranCode.SelectedValue & "','" & txtFacInt.Text & ",'" & lstParticipant.SelectedItem(i).ToString & "')"
						Command = New OleDbCommand(SQLstr, Mycn)
						icount = Command.ExecuteNonQuery
						MessageBox.Show("Records Stored Successfully")
					Catch ex As Exception
						MessageBox.Show("could not insert record")
					End Try

help me

*Always use code blocks for your code ==>

This post has been edited by PsychoCoder: 06 November 2007 - 10:47 PM

[girasquid]

How many items are selected?

Try adding a MessageBox.Show("Item Count: " & lstParticipant.SelectedItems.Count) just before your for loop, so that you can be sure there is more than 1 item being selected.

[rajathtc]

i'm getting the selected value
like if i select 2 items count will be 2
if i select 4 items count will be 4

but in the participant column it is inserting System.Data.DataRowView insted of the value from the selected list

[girasquid]

Try using 1stParticipant.SelectedItem(i).Value.ToString(), and tell me what happens in that case.

[rajathtc]

if it is "selecteditems(i).tostring" i'm getting the previous error

if it is "SelectedItem(i).ToString then the first value is inserted and i'm getting the exception like column1 not found for the second value

if it is "SeletedItem(i).Value.ToString then the exception is Public member 'Value' on type 'DataRowView' not found.

[girasquid]

Try selectedValue(i).ToString.

[rajathtc]

if i do that it strores vlues dividing the string into character
ie.,

if the name inside lst box is RAJATH
and the count is 4 it will store
R
A
J
A
in different rows