When I do a query that selects 0 records I get an error. How to avoid this? Here's my code:
VB Code:
  1. DA = New OleDbDataAdapter(Query, myConnString)

  2. Dim CB As New OleDb.OleDbCommandBuilder(DA)

  3.  
  4. DA.InsertCommand = CB.GetInsertCommand

  5. DA.UpdateCommand = CB.GetUpdateCommand

  6. DA.DeleteCommand = CB.GetDeleteCommand

  7. Try

  8.     DA.Fill(DS, Table) ' This is where I get the generic error

  9. Catch e As OleDbException ' I added this code

  10.     Try

  11.         DA.FillSchema(DS, SchemaType.Mapped, Table)

  12.     Catch ex As Exception

  13.         MsgBox(ex.ToString)

  14.     End Try

  15. End Try
There is a peice of code I added to manage this case, but when I add a row to the table and update, the operations goes OK, but I don't have my row in the database.

Thx