Solved

Reusing the datatable instance created by default on bound controls

Posted on 2009-05-14
6
283 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
Salesforce Made Easy to Use

On-screen guidance at the moment of need enables you & your employees to focus on the core, you can now boost your adoption rates swiftly and simply with one easy tool.

 

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

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

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

Many of us here at EE write code. Many of us write exceptional code; just as many of us write exception-prone code. As we all should know, exceptions are a mechanism for handling errors which are typically out of our control. From database errors, t…
Wouldn’t it be nice if you could test whether an element is contained in an array by using a Contains method just like the one available on List objects? Wouldn’t it be good if you could write code like this? (CODE) In .NET 3.5, this is possible…
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 video shows how to use Hyena, from SystemTools Software, to bulk import 100 user accounts from an external text file. View in 1080p for best video quality.

828 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