Where should i make fill on tableadapter?constructor?or in the load event?

Question

0.00/5 (No votes)

See more:

Hy, i'm working on a application where i use dataset and tableadapter for the connection with my database.
My question is where it is recomended to make fill on the table adapter?
for example:
this.tableAdapter(this.dataset.table)
Where?In the constructor after InitializeComponent()?or in the Load event of the form?
Thank you.

Posted 28-Apr-11 3:01am

stefy27

Add a Solution

2 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Sandeep Mewara · Accepted Answer · 2011-04-28T03:05:00

Solution 1

Read about ADO.NET here and it will help you.

Look at these:
MSDN: ADO.NET[^]
MSDN: Accessing Data with ADO.NET[^]

The C# Station ADO.NET Tutorial[^]
Using ADO.NET for beginners[^]

In the constructor after InitializeComponent()?or in the Load event of the form?
When you need it. Generally during load.

Posted 28-Apr-11 3:05am

Sandeep Mewara

Updated 28-Apr-11 3:06am

v2

Comments

Albin Abel 28-Apr-11 11:43am

Good links and reusable answer. :) 5

Sandeep Mewara 28-Apr-11 11:44am

:)

Albin Abel · Accepted Answer · 2011-04-28T05:47:00

Simply whenever you need the data, fill it. No need to fill when you are not going to use the data. Adapter simply call some sql queries and populate the result to a data holder like dataset. The beauty of the adapter is it simply encapsulate and abstract things which you manually do with a data reader. Provider specific adapters are there which work on specific data providers, so that the dataset doesn't worry about who are the data provider whether Sql server or MySql.

Forgot to add...Don't use table adapters (in typed dataset) if your dataset holds more than one table. Table adapters having known bugs. Instead use the common dataadapter.