Two Datables in a rdlc Report Form

Question

0.00/5 (No votes)

See more:

I am designing a rdlc file which needs to display data from two different tables in a single dataset. How can i achieve this?

I wanna bind Fields from two different DataTables to TextBoxes in a rdlc file.

Thanks and Regards,

Posted 2-Jan-13 20:17pm

zoozjar

Updated 2-Jan-13 21:04pm

v3

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)

Aarti Meswania · Answer 1 · 2013-01-02T20:28:00

Solution 1

you can create a sql view/store-procedure and set it as report-source
else
you can directly write sql-query while setting data-source for your report.

Happy Coding!
:)

Posted 2-Jan-13 20:28pm

Aarti Meswania

Comments

zoozjar 3-Jan-13 2:34am

Thanks for ur answer :)
I wanna bind data from two different DataTables to TextBoxes in a rdlc Report Form...! How can i achieve...

Thanks...! :)

Aarti Meswania 3-Jan-13 2:44am

you are asking for parameters.

so, simply use comboboxes and bind both with two different data-sources.
like you usual do it as,
cmb1.datasource = dt1
cmb1.displayMember = "name"
cmb1.valuemember = "Id"...

if you want to use textboxes then learn auto-suggest in text box
http://www.codeproject.com/Articles/243368/AutoComplete-Textbox

shiny13 · Answer 2 · 2013-01-02T20:56:00

You can create a DataTable type object with custom columns and then later add values to those columns when you query your data:

C#

DataTable joinedData = new DataTable();
joinedData.Columns.Add("Name",typeof(string));
joinedData.Columns.Add("Address",typeof(string));
joinedData.Columns.Add("Salary",typeof(int));

Here maybe Name and Address are in one table and maybe salary is on a different table.

When querying the data, use a left join or right join to join the tables based on Id or any type of column from your tables depending on your schema. After you make a join statement and store the data in a variable such as 'var query', then iterate through it and add each row's data like the example:

C#

var query = //Type some form of join LINQ statement to left join the 2 tables and store it in in query variable.

foreach (var item in query)
{
    joinedData.Rows.Add(item.Name,item.Address,item.Salary);
}