Hi,
I am trying to use a listbox instead of a textbox. I am trying to select multiple values in the listbox and trying to save the values (comma separated)in a single record in the database table. I am unable to save it as only the first selected value in listbox is saved in the database table. Please find the updated code below in code behind below:

Sub Button1_Click(ByVal sender As Object, ByVal e As EventArgs)
Dim rowIndex As Integer = 0
Dim strItems As String
Dim SelectedItems As String = String.Empty
Dim sc As New StringCollection()

If ViewState("CurrentTable") IsNot Nothing Then
Dim dtCurrentTable As DataTable = DirectCast(ViewState("CurrentTable"), DataTable)
Dim drCurrentRow As DataRow = Nothing
If dtCurrentTable.Rows.Count > 0 Then
For i As Integer = 1 To dtCurrentTable.Rows.Count
'extract the TextBox values
Dim itemIndex As Integer = 0
Dim box1 As TextBox = DirectCast(Gridview1.Rows(rowIndex).Cells(1).FindControl("TextBox1"), TextBox)
Dim box2 As DropDownList = DirectCast(Gridview1.Rows(rowIndex).Cells(2).FindControl("ddlStatus"), DropDownList)
Dim box3 As ListBox = DirectCast(Gridview1.Rows(rowIndex).Cells(3).FindControl("lstText"), ListBox)

Dim lstItem As ListItem
For Each lstItem In box3.Items

If lstItem.Selected Then
strItems = lstItem.Text
If itemIndex <> 0 Then
strItems = ", " + strItems
End If
SelectedItems += strItems
itemIndex += 1
End If
Next



'get the values here

'Response.Write(box1.Text + "<BR/>")
'Response.Write(box2.Text + "<BR/>")
'Response.Write(box3.Text)

sc.Add((ddlProj.SelectedValue & ",") + ((box1.Text & ",") + box2.SelectedValue & ",") + SelectedItems)
rowIndex += 1


Next
InsertRecords(sc)
'Next
End If
End If

Hi,
I am using your code to dynamically generate textbox and saving it to db. I am using a listbox and I am binding the listbox with values frm code behind in Gridview Row Updating instead of SqlDataSource. But the values are not binded in the listbox. Kindly enlighten me .....