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?)




>-----Original Message-----
>ado.net is disconnected. You will find that you may be
executing a bit of
>sql to actually update the database but you are not re-
loading the data back
>into your dataset
>
>Have a look at the documentation on DataAdapters
>
>Cheers
>Jody
>MCSD.Net
>
>"Mike" <(E-Mail Removed)> wrote in message
>news:106801c38c45$4dce8cc0$(E-Mail Removed)...
>> I have an access database connected through odbc. I can
>> connect to the database and see all the tables and data
in
>> Visual Studio.NET. However, when I run my program and
add
>> a row to a table, that row does not show up in the
Visual
>> Studio View. Using the refresh or run at the table,
>> database or dataconnection level does not retrieve the
new
>> data either.
>>
>> I have to disconnect from the database and reconnect in
>> order to see the new data. I'm running VS.NET 2003
>> version 7.1.3088, and have checked for updates.
>>
>> Can you please tell me how to refresh this data or is
this
>> a bug
>>
>> Thank you,
>>
>> M...
>> .
>>
>>
>
>
>.
>

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
>-----Original Message-----
>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?)
>
>
>
>
>>-----Original Message-----
>>ado.net is disconnected. You will find that you may be
>executing a bit of
>>sql to actually update the database but you are not re-
>loading the data back
>>into your dataset
>>
>>Have a look at the documentation on DataAdapters
>>
>>Cheers
>>Jody
>>MCSD.Net
>>
>>"Mike" <(E-Mail Removed)> wrote in message
>>news:106801c38c45$4dce8cc0$(E-Mail Removed)...
>>> I have an access database connected through odbc. I
can
>>> connect to the database and see all the tables and
data
>in
>>> Visual Studio.NET. However, when I run my program and
>add
>>> a row to a table, that row does not show up in the
>Visual
>>> Studio View. Using the refresh or run at the table,
>>> database or dataconnection level does not retrieve the
>new
>>> data either.
>>>
>>> I have to disconnect from the database and reconnect in
>>> order to see the new data. I'm running VS.NET 2003
>>> version 7.1.3088, and have checked for updates.
>>>
>>> Can you please tell me how to refresh this data or is
>this
>>> a bug
>>>
>>> Thank you,
>>>
>>> M...
>>> .
>>>
>>>
>>
>>
>>.
>>
>.
>