Save & Refresh SELECT Statement

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

So, I am updating a SQL Database using a Windows Form. When I save the
record I would like to refresh the SELECT command, but I don't know how. Is
it possible to refresh the dataadapter or reselect so a Combo Box is properly
updated with the changes?
 
Put the data pull into its own routine. WHen the Update method is called,
recall that method and rebind. Unless you are working with huge sets of data,
this is okay. If you are dealing with huge sets, apply changes after Update
is successful and rebind the "changed" dataset (this will also work for small
sets of data, but reduces network load on large sets).


---

Gregory A. Beamer
MVP; MCP: +I, SE, SD, DBA

***************************
Think Outside the Box!
***************************
 
Back
Top