assign the datatable value into datatable of the dataset

Question

0.00/5 (No votes)

See more:

dear friends i am doing a desktop application for my company.
Actually i need to display some content in windows report.I have a dataset and a datatable(reporttable) with in dataset.I use this dataset as source of the report.

Query = "SELECT Item_Description,Stock FROM Inventory_Control";
.
.
.
public DataTable table = new DataTable();
LogInDBAdapter.Fill(table);

from the filled table i need to get the data for the dataset(datatable-reporttable) to display it in windows report.

kindly help me complete this project.
Thank you

Posted 15-Jul-10 6:36am

John Sathish Tamilarasu

Updated 15-Jul-10 7:33am

v3

Add a Solution

Comments

saloni15 15-Jul-10 12:43pm

Couldn't get 2nd part of ur problem...plz elaborate or write the code u r running...also for report r u using crystal reports or anydng else

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 · Answer 1 · 2010-07-15T08:16:00

2 Options:

1: Instead of using public DataTable table = new DataTable();
Use: DataSet table = new DataSet(); Keep rest of code as it is and you can directly use this dataset now.
Use table in your report.

2: Create a new dataset and add this table to it.

DataSet myDS = new DataSet();<br />
myDS.Tables.Add(table);

Use myDS in your report.

John Sathish Tamilarasu · Answer 2 · 2010-07-20T21:13:00

thank sandeep,
I got some idea now,but even i am not clear about the issue,

In the project i am using the class(icclass) where i am filling the table using the query.
In my form i declared a dataset dset= new dataset();
dset.tables.add(icclasss.table);
I Added a new dataset named dataset1,and i create a datatable1 in that.i planned to create a report using this datatable1.
Now i created a object dataset1 ds = new dataset1();
Now i want to assign the dset table values to the ds table(datatable1).
or otherwise i want to create a report directly from the filled table.
You help is needful!
thank you!

assign the datatable value into datatable of the dataset

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0