I'm new with Data Sources and am using VB.Net in VS2005, although I have VS2010 available if it matters. In previous code I just wrote queries using OleDbConnection s and OleDbCommands but wanted to learn about using Data Sources.
My requirements are pretty simple, the underlying data in the SQL database is modified from outside sources or triggers I wrote in the DB. For the purpose of this question, all I realy want to do is display in various data grids the data in the tables (no inserting, updating or deleting).
That part was pretty simple, but to refresh the data when it changes has not been easy. The command is given to me to "fill" the adapter like this:
myTableAdapter. Fill(myDataSet. myDataTable)
Problem is, I have to do it on a timer which is not good because I cannot seem to find an event which fires when the source data changes. Can someone help me with this, it seems pretty simple but I just can't locate it.
Ed
My requirements are pretty simple, the underlying data in the SQL database is modified from outside sources or triggers I wrote in the DB. For the purpose of this question, all I realy want to do is display in various data grids the data in the tables (no inserting, updating or deleting).
That part was pretty simple, but to refresh the data when it changes has not been easy. The command is given to me to "fill" the adapter like this:
myTableAdapter. Fill(myDataSet. myDataTable)
Problem is, I have to do it on a timer which is not good because I cannot seem to find an event which fires when the source data changes. Can someone help me with this, it seems pretty simple but I just can't locate it.
Ed