vb.net+access读数顺序不相同?
With AxCommonDialog1
.Filter = "Microsoft Office Access(*.mdb)|*.mdb "
.DefaultExt = ".mdb "
.ShowOpen()
If Len(.FileName) = 0 Then Exit Sub
cn = New OleDbConnection( "provider=Microsoft.Jet.OLEDB.4.0; " & _
"data source= ' " & .FileName & " ' ")
End With
cn.Open()
cmd = New OleDbCommand( "select 点号,X坐标,Y坐标 from ZB ", cn)
rd = cmd.ExecuteReader
Do While rd.Read()
ComboBox1.Items.Add(rd.Item(0))
Loop
为什么输出的顺序和access表中的顺序不同?
[解决办法]
order by 要排序的字段