How to add items in combobox at runtime when the combobox is bound to the database

Question

hi

      my combobox is already bound to the database. if i try to add an item.it will display

an error message item collection cannot be modified.if any one have any idea about how to

do it help me.i have ask this question many times still i can't able to find a correct solution .

thanks in advance.

Answer 1

Hello，

As far as I see，a combobox cannot do both of the things together……Maybe you can use foreach to loop your datasource and call "Add" method to add one by one。

---

   QQ我：
下载MSDN桌面工具(Vista,Win7)
我的博客园
慈善点击，点击此处

Answer 2

Hi

Did you mean this way:

        Dim cmd As SqlCommand
        Dim dr As SqlDataReader

        con.Open()

        Dim sql As String = "SELECT * from table"
        cmd = New SqlCommand(sql, con)
        dr = cmd.ExecuteReader()
        cbo1.Items.Add("new item")
        If dr.HasRows Then
            While dr.Read()
                cbo1.Items.Add(dr(0))
            End While
        End If
  

Its a code to fill combobox . and the line below is aimed to add item independantly of binded data 

 cbo1.Items.Add("new item")

Post your code if its posisble to se how we can help you

Regards

---

Best Regards...Please mark as answer if my post is helpful http://yosr-jemili.blogspot.com