dt = ds.Tables("data")
ComboBox1.DataSource = dt
ComboBox1.DisplayMember = "versement"
Dim index As Integer = ComboBox1.Items.Count - 1
Dim dr As DataRow = dt.Rows(index)
Dim strValeur As String = dr.Item("versement").ToString
Dim arStr() As String = strValeur.Split(" ")
ComboBox1.Items.AddRange(arStr)
Dim itemvers() As String
For Each line As DataRow In dt.Rows
itemvers = line("versement").ToString.Split
For Each item As String In itemvers
ComboBox1.Items.Add(item)
Next
Next
dt.Clear()et
dt = Nothingmais toujous le meme message d'érreur.
Vous n’avez pas trouvé la réponse que vous recherchez ?
Posez votre questionDim Conn As New OleDbConnection(ConStr)
SavInto.Connection = Conn
SavInto.CommandType = CommandType.Text
Conn.Open()
Dim s As String = String.Empty
For i = 0 To ComboBox1.Items.Count - 1
s += ComboBox1.Items(i).ToString() + " "
Next
SavInto.CommandText = "INSERT INTO tblContacts(nom,prenom,age, versement)" & _
"values ('" & TextBox1.Text & "','" & TextBox2.Text & "','" & TextBox3.Text & "','" & s & "') "
SavInto.ExecuteNonQuery()
Conn.Close()
Dim cb As New OleDb.OleDbCommandBuilder(da)
Dim dsNewRow As DataRow
dsNewRow = ds.Tables(0).NewRow()
dsNewRow.Item("nom") = TextBox1.Text
dsNewRow.Item("prenom") = TextBox2.Text
dsNewRow.Item("age") = TextBox3.Text
dsNewRow.Item("versement") = ComboBox1.Items(0)
For i = 1 To ComboBox1.Items.Count - 1
dsNewRow.Item("versement") = dsNewRow.Item("versement") & " " & CStr(ComboBox1.Items(i))
Next