Windows Forms: TableAdapter and DataSets

Question

0.00/5 (No votes)

See more:

Hi all,

I have two forms (Form1 & Form2). Form1 contains a DataGridView control and its related dataset and TableAdapter. How do I access them in Form2? I would like to write it like this:

addressTableAdapter1.Update(mpRetailDataSet1); //by creating objects of them is not working

Please reply with an example.

[orig. title]
how to get TableAdapter and DataSet of DataGridView in Another Windows Form

Posted 19-Jan-11 1:15am

ks ravi

Updated 19-Jan-11 1:27am

Slacker007

v2

Add a Solution

1 solution

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)

OriginalGriff · Answer 1 · 2011-01-19T01:29:00

Solution 1

Depending on which form creates the other, set up a public property in the created form which set to the DataSet and TableAdapter.

So, if Form1 create Form2, then Form2 has:

public DataSet dataToManipulate {get; set;}
public TableAdapter tableToManipulate {get; set;}

And Form1:

Form2 frm = new Form2();
frm.dataToManipulate = myDataSet;
frm.tableToManipulate = myTableAdapter;
frm.ShowDialog();

Posted 19-Jan-11 1:29am

OriginalGriff

Comments

ks ravi 19-Jan-11 8:27am

hi OriginalGriff,

thanks for reply, its working but showing Existing Form1(DataGridView form) Window along with new Form1.How to remove existing form or update to the existing form

Espen Harlinn 20-Jan-11 15:01pm

5+ Nice and simple, OP should have been able to take it from here...