New Items don't show up

  • Thread starter Thread starter John
  • Start date Start date
J

John

I have one form calls another form, which adds data to a couple tables, then
the first form doesn't see the new datd till i clos and reopen the program.
The data is in the table though from looking through the SQL Server Manager.
Why wont it show up?
 
I have one form calls another form, which adds data to a couple
tables, then the first form doesn't see the new datd till i clos and
reopen the program. The data is in the table though from looking
through the SQL Server Manager. Why wont it show up?
Click to expand...

Make sure you are re-querying the database when the second form is closed.
If you open the second form Modally, you can rebind after control is return
to the first form. Otherwise, you need a notification system implemented
internally to force the first form to re-query.

Also, know that by default items added to the table do not automatically
appear in the form. This is possible with SQL 2005 and ADO.Net 2.0. Otherwise,
ADO uses a disconnected model that just caches the data and ignores changes
on the server.

Jim Wooley
http://devauthority.com/blogs/jwooley/default.asp
 
Hi John,

Would you tell me what data source you are using in your project? If you
are using DataSet/DataTable, when new item is added into it, controls that
are bound to the DataSet will display the new item immediately.

However, this feature is not supported by other data source, such as
List<T>. If you want to represent the new item in the data-bound control
after you add it in the data source, you could call the
CurrencyManager.Refresh method to force a repopulation of data-bound list.

You could get the CurrentManager object by the sentence:

CurrencyManager mgr = this.BindingContext[datasource] as CurrencyManager;

Or, if you use BindingSource as the data source, you could get the
CurrentManager object directly by its CurrencyManager property.

CurrentManager mgr = bindingSource1.CurrencyManager;

Hope this helps.
If you have anything unclear, please feel free to let me know.


Sincerely,
Linda Liu
Microsoft Online Community Support

==================================================
Get notification to my posts through email? Please refer to
http://msdn.microsoft.com/subscriptions/managednewsgroups/default.aspx#notif
ications.

Note: The MSDN Managed Newsgroup support offering is for non-urgent issues
where an initial response from the community or a Microsoft Support
Engineer within 1 business day is acceptable. Please note that each follow
up response may take approximately 2 business days as the support
professional working with you may need further investigation to reach the
most efficient resolution. The offering is not appropriate for situations
that require urgent, real-time or phone-based interactions or complex
project analysis and dump analysis issues. Issues of this nature are best
handled working with a dedicated Microsoft Support Engineer by contacting
Microsoft Customer Support Services (CSS) at
http://msdn.microsoft.com/subscriptions/support/default.aspx.
==================================================

This posting is provided "AS IS" with no warranties, and confers no rights.
 
Thanks, I have it working now. SeemsI fix things a lot faster in the
morning than the afternoon.
 
Back
Top