Database Information Not Refreshing

  • Thread starter Thread starter Mike
  • Start date Start date
M

Mike

Hi Jody,

I'm not sure we're talking about the same thing. The
issue is not with my program it is with Visual Studio.NET

I go to Tools -> Connect to Database in Visual Studio.NET.
I then connect to my database, and am able to view tables,
data etc...in the "Server Explorer" on the left.

At this point everything is fine and I can see all the
tables, fields and data in the database.

Now... I Run my program in debug mode, and through my
program add a record/etc... I can go to the database and
see the data but then when I go into "Server Explorer" and
go down to the table, I do not see the new data in .NET
(the data is in the database). The refresh at the table
level (in the Server Explorer) should "theoretically"
requery the database and get the new data (otherwise, why
bother having a refresh?)
 
I assume you are querying a database and populating a
local data table in ADO.NET. To "Refresh" the data
you "Clear" the table and use the "Fill" command in the
DataAdapter.

Compared to earlier versions of ADO, ADO.NET requires more
control from the designer in order to give greater
flexibility.

HTH
Rob
 
Back
Top