listview显示数据库内容的方法,,紧急呼救我的源代码cmd New SqlCommand(mysql, myconn)ListView1.Items.
listview显示数据库内容的方法,,紧急呼救
我的源代码
cmd = New SqlCommand(mysql, myconn)
ListView1.Items.Clear()
myconn.Open()
myreader = cmd.ExecuteReader()
While (myreader.Read())
Dim li As ListViewItem
li = ListView1.Items.Add("", "", "")
li.Text = myreader("客户号").ToString
li.SubItems.Add(myreader("客户名称").ToString)
li.SubItems.Add(myreader("联系人").ToString)
li.SubItems.Add(myreader("电话").ToString)
li.SubItems.Add(myreader("主管工号").ToString)
ListView1.Items.Add(li)
End While
myreader.Close()
运行后出现错误:不能在多处添加或插入项“c001”,必须首先将其从当前位置移除或克隆。参数名:item
[解决办法]
- VB.NET code
Dim li As new ListViewItem("item1",0) li..Checked = True li.SubItems.Add( myreader("客户号").ToString) li.SubItems.Add(myreader("客户名称").ToString) li.SubItems.Add(myreader("联系人").ToString) li.SubItems.Add(myreader("电话").ToString) li.SubItems.Add(myreader("主管工号").ToString) listView1.Items.AddRange(New ListViewItem() {li}) 