Solved

Reusing the datatable instance created by default on bound controls

Posted on 2009-05-14
6
281 Views
Last Modified: 2012-05-07
This is more of a general question and am posting this after searching through the IDE generated code and not being able to find what I need!

I have a form with bound controls (combo boxes mostly). When I added them, the IDE automatically created the table adapters (whose creation instances I can see in the designer code) and on the form load event added code of the kind I've posted here.

My question is, while I can find the table adapter instances, I cannot locate the instances of the datatable themselves - I would prefer to reuse what's already been created for submitting my updates rather than create a new one.

Any help pls?

Thanks,
this.tblGroupsTableAdapter.Fill(this.dsSaphireOra.tblGroups);

Open in new window

0
Comment
Question by:Ignis2
  • 3
  • 3
6 Comments
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24386493
You can see in the statement above that you have a Typed Dataset called dsSaphireOra and a Typed DataTable called tblGroups. Is that not what you are looking for?

http://thetonesofillusion.blogspot.com/2009/04/vb-net-typed-and-untyped-dataset.html
0
 

Author Comment

by:Ignis2
ID: 24393461
Umm, no. I do have the typed datasets - I'm not sure where the instance of these is being created and just how the plain thing works is a bit confusing!
Because, if I want to use it, I usually do something like

tblGroups tbl = new dsSaphireOra.tblGroups();

And I cannot find the instance being created anywhere - does the IDE create  a default instance on running which is what is accessible from the this pointer?
0
 
LVL 83

Expert Comment

by:CodeCruiser
ID: 24393558
If the above line is automatically added to the code then it means that its an instance. I am not sure if default instance concept applies here.
0
DevOps Toolchain Recommendations

Read this Gartner Research Note and discover how your IT organization can automate and optimize DevOps processes using a toolchain architecture.

 

Author Comment

by:Ignis2
ID: 24393799
Just to make things a little clearer, these are created when i bind the controls to the datatables. I can see instances of the table adapters being created :

tblGroupsTableAdapter = new dsSaphireOra.tblGroupsTableAdapter()

but can't find any reference to the datatables themselves. Any idea why? Am just trying to understand how this works, so I have better control over my code!
0
 

Author Comment

by:Ignis2
ID: 24393802
the lines of code I'm talking about are in the form.designer.cs - generated by the IDE!
0
 
LVL 83

Accepted Solution

by:
CodeCruiser earned 200 total points
ID: 24393882
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Entering time in Microsoft Access can be difficult. An input mask often bothers users more than helping them and won't catch all typing errors. This article shows how to create a textbox for 24-hour time input with full validation politely catching …
Exception Handling is in the core of any application that is able to dignify its name. In this article, I'll guide you through the process of writing a DRY (Don't Repeat Yourself) Exception Handling mechanism, using Aspect Oriented Programming.
This is Part 3 in a 3-part series on Experts Exchange to discuss error handling in VBA code written for Excel. Part 1 of this series discussed basic error handling code using VBA. http://www.experts-exchange.com/videos/1478/Excel-Error-Handlin…
This is a video describing the growing solar energy use in Utah. This is a topic that greatly interests me and so I decided to produce a video about it.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

14 Experts available now in Live!

Get 1:1 Help Now