DropDownList1.Items.Clear()
DropDownList1.DataSource = ""
DropDownList1.DataBind()
Dim strsele As String = "select * from class"
Dim datasou As String = "provider=microsoft.jet.oledb.4.0;data source=" & Server.MapPath("database.mdb")
adocmd = New OleDbDataAdapter(strsele, datasou)
adocmd.Fill(ds, "class")
mytable = ds.Tables.Item(0)
Dim i As Int16
Dim values As ArrayList = New ArrayList()
For i = 0 To mytable.Rows.Count - 1
myrow = mytable.Rows.Item(i)
values.Add(myrow.Item(0))
Next
DropDownList1.DataSource = values
DropDownList1.DataBind()
我发现这是因为我在窗体的load事件,因为浏览器每次按刷新之后又重新进行绑定,就会出现我上面问题.我不知道应该如何解决.
form_load
If toolso = True Then
Dim strsele1 As String = "select class as 类别,id as 编号, name as 名称,style as 规格,sour as 厂家,monery as 价格 from datasour where " & datasour & " ='" & datavalue & "'"
adocmd = New OleDbDataAdapter(strsele1, datasou)
adocmd.Fill(ds, "datasour")
'mytable = ds.Tables.Item(0)
' System.Diagnostics.Debug.Write(ds.Tables.Item(1))
DataGrid1.DataSource = ds.Tables.Item(1).DefaultView
DataGrid1.DataBind()
toolso = False
End If
我放了一个逻辑变量后,如是在浏览器按刷新,虽然可以解决我上面的问题.但会现在窗体的datagrid控件中却不会显示数据.不知道如何解决.还有就有该如何清空dropdownlist控件中的数据??