Results 1 to 2 of 2

Thread: Why only sorted When i click Second Time

  1. #1

    Thread Starter
    Lively Member
    Join Date
    Nov 2002
    Location
    Malaysia
    Posts
    124

    Why only sorted When i click Second Time

    Private Sub cboAddSupplier_SelectedIndexChanged(ByVal sender As Object, ByVal e As System.EventArgs) Handles cboAddSupplier.SelectedIndexChanged
    DataSet41.Clear()
    OleDbDataAdapter4.SelectCommand.CommandText = _
    "SELECT * FROM Item WHERE " & _
    "Supplier = '" & cboAddSupplier.Text & "' " & _
    "ORDER BY Item ASC"
    OleDbDataAdapter4.Fill(DataSet41)

    End Sub

  2. #2
    Registered User
    Join Date
    Nov 2002
    Location
    Växjö, Sweden
    Posts
    314
    You mean you have to run that code twice to get it to sort?!?

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width